How to store GET_CHANGES result

kklosson

I'd like to implement this in my log. I intend to add an attribute called Changes and will store the result of the GET_CHANGES function there. Does anyone have a sample of a result of this function? How many characters should I commit to this?

itdeptcorp

Hi,

Yes here is one we use

If Customer WAS CHANGED Then
CREATE SystemAudit WITH SystemAudit.Action='Update',SystemAudit.Description=GET_CHANGES(Customer),SystemAudit.MadeBy=LoggedInSystemUser.LoginName,SystemAudit.ObjectName='Appointment',SystemAudit.ObjectID=Customer.ID

BenHayat

itdeptcorp wrote
Hi,

Yes here is one we use

If Customer WAS CHANGED Then
CREATE SystemAudit WITH SystemAudit.Action='Update',SystemAudit.Description=GET_CHANGES(Customer),SystemAudit.MadeBy=LoggedInSystemUser.LoginName,SystemAudit.ObjectName='Appointment',SystemAudit.ObjectID=Customer.ID

Just curious, you, check for Customer changes, you store GET_CHANGES(Customer), Customer.ID, but for Object Name, you store "Appointment"?

What's the size of SystemAudit.Description attribute you defined in configurator?

Thanks!

itdeptcorp

We obfuscated the "objects" a little in the process to give you the overall view - but not break our NDA

This may help:

Objectname = SystemAudit and has 6 attributes

Action (Plain text) Insert, Update, Delete and Viewed
Description (Plain text) 400 chars
MadeBy
MadeOn (CURRENT_TIMESTAMP)
ObjectID
ObjectName

BenHayat

itdeptcorp wrote
We obfuscated the "objects" a little in the process to give you the overall view - but not break our NDA

This may help:

Objectname = SystemAudit and has 6 attributes

Action (Plain text) Insert, Update, Delete and Viewed
Description (Plain text) 400 chars
MadeBy
MadeOn (CURRENT_TIMESTAMP)
ObjectID
ObjectName

Thanks!
I actually have a very similar system that I had developed in the past in the .Net and now implementing it in Aware.

itdeptcorp

no worries - there were many more planned processes surrounding this which are on the books to complete - just no time..

tford

I remember reading in release notes at some point in the past that GET_CHANGES could now be formatted with HMTL in some way. I didn't find any details in the User Guide or Rule Language Reference though.

BenHayat

tford wrote
I remember reading in release notes at some point in the past that GET_CHANGES could now be formatted with HMTL in some way. I didn't find any details in the User Guide or Rule Language Reference though.

Good memory Tom;
Yes, it was in recent version that I also read, they added HTML format. But I'm not how Aware formats that GET_CHANGES info.

itdeptcorp

I will dig into that and take a look next week - if any remarkable things come out of it I will post in Tips and Tricks.