AnsweredAssumed Answered

Attempting to log user queries

Question asked by Ely_Age on Oct 13, 2009

Title

Attempting to log user queries

Post

So we're in the process of becoming SOX compliant. That means building audit trails for yours truly. While I have a number of things already being logged, I've run into a snag. 

 

I currently have a number of common searches performed via scripts, but users still have the option to search directly from fields on the layouts. It's these freeform searches I need to log, but with 70+ fields in that table I only want to capture the field names they access and what is queried.

 

My first though was to set up a calculation field:

 

Calc_Field = Case(Field1 or Field2 or Field3...; Get(ActiveFieldName) & " | " & Get(ActiveFieldContents) &"¶"& Calc_Field)

 

Unfortunately, I never though about it not evaluating while in find mode. Ideally I'd like to be able to store that information directly in a related table instead of having to parse it out after the fact. 

 

Any thoughts?

 

FMP 9.03 Adv

OSX 10.sux 

Outcomes