John,
Cologon's SuperLog includes an example for how to parse the data out of the "big field" into Audit records so you can manipulate/report on it how you wanna.
Sincerely,
Chris Kubica
On May 25, 2011, at 1:14 PM, John Wenmeekers wrote:
> On Wed, 25 May 2011 08:29:01 -0700, John Weinshel <[log in to unmask]> wrote:
>
>> Hi John
>
> Hi John....
>>
>> I missed Salman's reply, and it helps if you quote at least part of the
>> post to which you're responding, so that, in this case, I would know what
>> Salman had suggested.
>
> Sorry, I sent a reply directly from my mobile email program. No 'quote'
> button there....
> I should not use new toys.....without mastering all the features....
>
> Salman suggested a plug in.
> We try to use only native functions in FileMaker, if possible.
>
>
>> In any event, I recall your original post said something about 'not just
>> an audit', but that you seemed to be asking for exactly that-- a record of
>> who changed what, and when they did so. Or am I missing something and you
>> want more than that?
>
> It is a little bit more.
> We already use an (adapted) audit log system. (based on Ray Cologon's AuditLog)
> That will log the changes and return the changes all in one field.
>
> What we need is the possibility to use the data about the changes to
> generate reports.
> Like:
> how many changes on a specific record during a day, day range, week, month.
> Which field has the most changes.
> Which change happens the most...
>
> I only see this possible if we push the changes, not in a field, but in a table.
> Table = records = data = possibility to use functions = generate reports.
>
> We have already a system to capture meta data from tables and work with the
> results.
> Only the changes to fields and records is a gap.
>
> I hope this is a little more clear.
>
> In Kindness
>
> JW
|