The audit table is in our sights to re-factor and part of this is to break each audit into a separate record.
Kind regards -- -- Matthew Bryant Product Development Manager Daemon Internet Consultants Adobe Solutions Partner http://www.daemon.com.au/ p. 02 9380 4162 f. 02 9380 4204 On 05/06/2007, at 1:17 PM, bsmith wrote: > > 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 > > > > > -- > 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 -~----------~----~----~----~------~----~------~--~---
