Cheers Matthew - that would be cool B.
On Jun 5, 3:31 pm, Matthew Bryant <[EMAIL PROTECTED]> wrote: > 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 Partnerhttp://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 -~----------~----~----~----~------~----~------~--~---
