Just thought I'd report back for anyone who might try to acheive something similar in the future.
The audit table includes listings for items "returned to draft", which could be a declined approval. Comments for approve/return-to-draft actions are held in the commentlog field of each type's db table - one large text field, so they can't really be tied programatically to a particular action in the audit trail. Based on that - it looks like there's no way to get a useful report on approvals/declinations in 3.0.1 B. On Jun 1, 12:17 pm, bsmith <[EMAIL PROTECTED]> wrote: > Thanks for that Matthew, I've done as you've suggested. > > Just throwing this out there again - the client is pretty keen to > analyse the reasons that requested approvals are declined... I can't > see anything in the Audit trail that will let me get this information > - anyone have any ideas off the top of their head? > > - Ben > > On May 29, 2:19 pm, Matthew Bryant <[EMAIL PROTECTED]> wrote: > > > Hey B, > > > findType will fail (return empty string) if the objectid is an > > orphan. ie. exists in the refobjects table but not in its original > > content type. > > > You could simply skip the objects returned by the findType where the > > typename is an empty string. > > > Kind regards > > > -- > > -- Matthew Bryant > > Product Development Manager > > Daemon Internet Consultants > > Adobe Solutions Partnerhttp://www.daemon.com.au/ > > p. 02 9380 4162 > > f. 02 9380 4204 > > > On 29/05/2007, at 11:48 AM, bsmith wrote: > > > > Hi, > > > > I've got a client who's requested some custom reporting for FarCry > > > 3.0.1: > > > > Report 1: By date range and/or by user > > > - number of pages / content items (news, events, customtypes etc.) > > > created, edited, sent to draft, deleted, approved/declined > > > - number of images uploaded and edited. > > > - link to the relevant administration area / public page for each of > > > these items > > > > Report 2: By date range and keyword - pages most updated, pages least > > > updated, most popular pages accessed > > > > Report 3: By date range and keyword - navigation changes, additions, > > > deletions > > > > Report 4: By date range and/or by user - List of pages that have been > > > declined approval with notes > > > > So, my questions are: > > > - Is there an easy way to associate the audit log with the various > > > types? I've tried farcry.fourq.fourq.findType() but this often fails. > > > - Is there a way to discern 'declined' actions (looks to me like > > > they're just returned to draft)? > > > - Anything else that i might find useful when working through this? > > > > Cheers guys, any insight appreciated > > > > B. > > > > -- > > > Message protected by MailGuard: e-mail anti-virus, anti-spam and > > > content filtering. > > >http://www.mailguard.com.au/mg > > > -- > > Message protected by MailGuard: e-mail anti-virus, anti-spam and content > > filtering.http://www.mailguard.com.au/mg --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
