I am looking at creating a dashboard report for the Umbraco backoffice that would show content that has been updated in a specified time range.
I have started by looping through the results of the GetPagedDescendants method of the ContentService on the root node to then call the GetPagedItemsByEntity of the AuditService for each content descendent but, as this has to build up a list before I can look at filtering and pagination, it means there's going to be a DB call for every page on the site so it is very slow!
Is there are better service or method of the AuditService that allows me to query the audit logs of all content directly, with some filter, that would only involve 1 DB call - a bit like a query on the umbracoLog DB table - that would return the auditItem with a navigation property to audited entity?
Most recent audit of all content
Hi,
I am looking at creating a dashboard report for the Umbraco backoffice that would show content that has been updated in a specified time range.
I have started by looping through the results of the GetPagedDescendants method of the ContentService on the root node to then call the GetPagedItemsByEntity of the AuditService for each content descendent but, as this has to build up a list before I can look at filtering and pagination, it means there's going to be a DB call for every page on the site so it is very slow!
Is there are better service or method of the AuditService that allows me to query the audit logs of all content directly, with some filter, that would only involve 1 DB call - a bit like a query on the umbracoLog DB table - that would return the auditItem with a navigation property to audited entity?
Many thanks Greg
Might be worth checking the code for https://github.com/enkelmedia/TheDashboard it may give you info you require
is working on a reply...