• Sign In
  1. Messages

how to log longer strings for auditing

LabKey Support Forum (Inactive)

View Message

view list print
how to log longer strings for auditing Ben Bimber  2011-09-28 07:34
Status: Closed
 
across the EHR, I set most of the failure callbacks to use a standard function that inserts a message into the audit trail. i've got this working both client-side and in validation scripts. this has provided a really good mechanism to find out when something goes wrong. the only problem is that it seems i'm limited to 200 characters when inserting into the audit trail. Is this just a limitation to that table, or am i missing something? i ask b/c i'd like to insert the whole stack trace to provided better debugging info.

thanks.
 
 
jeckels responded:  2011-09-30 09:43
Hi Ben,

The two string/varchar fields key1 and key2 (which may have different labels for the various types of audit events) are limited to 200 characters. Comments allows up to 500 characters. Right now there isn't a TEXT or otherwise unlimited field, though that would be useful for scenarios like this one.

Thanks,
Josh