GET_CHANGES output - Audit BO

wings

I am using the new function GET_CHANGES to implement an audit of BO's.

The formatted output of this uses tabs and CR/LF and when I display the data it is not formatted correctly as follows:

Modified instance 200288 of Address
AttributeOld valueNew value
HouseNumber222
FormattedAddress11/2 Jones Street11/22 Jones Street
UpdatedOn 2009-09-27T15:20:00 2009-09-30T18:50:00
UnitNumber111

This is not readable. I could write a rule to replace the tabs and CR/LF and mark it up as html but there isn't a function that allows me to replace tabs or CR/LF that I can find.

Any suggestions?

tazzmaxx

I have noticed that GET_CHANGES does not work for any system related changes.

I have GET_CHANGES implemented so that if there was any change to the record an audit is created. When something like a status change (which is made by a rule) occurs then the GET_CHANGES function does not work. Why is this so? Shouldn't it capture all changes whether they are made directly or indirectly to the record?

tford

Can you describe your situation in detail so I can see if I can reproduce it?

aware_support

You can try replacing '\t' and '\n' symbols using REPLACE function (not sure if it will work, though)

If GET_CHANGES is used in the rules of an object, it should be the last to execute, which you can achive by setting the priority of the rule

tazzmaxx

I have a rule that fires when a record changes that calls the GET_CHANGES function. The rule is as follows:

If Client WAS CHANGED Then
CREATE AuditRecord WITH AuditRecord.Description=GET_CHANGES(Client),AuditRecord.AuditObject=AuditObjects,AuditRecord.BOID=Client.ID,AuditRecord.BOName=Client.ObjectIdentifier,AuditRecord.MadeBy=LoggedInSystemUser.LoginName

I have changed the priority of this rule to the lowest value but it does not work when processes change the record only when changes are made directly to the record.

An example is a process that automatically changes the Status of the this record from one status to another. This is the type of information that we must have an audit record for. When the process runs the record changes to another status and a audit record is written that looks like the following:

Modified instance of 11462 of Client
Attribute Old value New value

There is nothing under the old and new values.

Any ideas?

Thanks

tford

Do you have any PROTECT action on Client?

tazzmaxx

Hi Tom,

Yes, PROTECT is being used in another rule on the Client BO

tford

You will have to allow system changes in the PROTECT.

tazzmaxx

I removed PROTECT completely from Client and it still operates the same. Could it be anything else?

tford

Have you looked at the logs?

tazzmaxx

I always do...but in this case I did not see anything. I am creating a separate bsv to see if I can create the same outside of my larger bsv.

tazzmaxx

Hey Tom,

I created a separate bsv and I still have the problem with system changes to the record.

The design is such that an audit record should be created for any change to the Client record but if I fire off a process to change the status from state to another the system does not record anything.

Would you have a few extra minutes to check out the bsv?

Thanks

tazzmaxx

Support,

Can you confirm whether or not GET_CHANGES is supposed to work for system changes. I cannot get it to work for something as simple as changing a status via a process from one state to another. The GET_CHANGES function only seems to work for changes made within the BO.

Thanks

tford

Yes, GET_CHANGES works for system changes.

I created a BSV with this rule on the RegularUser BO:

CREATE Logit WITH Logit.Hold=GET_CHANGES(RegularUser)

It created new instances of Logit BO when changes were made to RegularUser.

tazzmaxx

I agree that it will create a record for the changes but it will not tell you what changes were made. Please try the following and let me know what you get:

Add a new attribute to RegularUser called Status with the options of OPEN or CLOSED
Create a process called StatusChange and enter the following rule:

RegularUser.Status = 'CLOSED'

Add a button to the RegularUser form and click the button

You will have a Logit record created but it will only have the following:

Modified instance 12423 of RegularUser
Attribute Old value New value

This is nice because it states that a change was made but it appears that the GET_CHANGES does not work for system changes. I would expect to see that the Old value was Null and the New Value is CLOSED

tford

3. Add a button to the RegularUser form and click the button

I'm not clear what this button will do.

tford

What is the max length of your status attribute?

tazzmaxx

Hi Tom,

The button should intiate the StatusChange process.

The max length on the status attribute is 20

tford

Make your status longer & see if that fixes it. I'm guessing it gets truncated.

tazzmaxx

I'm not sure that I understand, the status field is setup to capture 20 characters and the only 2 options are Open (4 characters) and Closed (6 characters). I can't imagine that the status length would have anything to do with the GET_CHANGES function.

The status field is fine, it is the data being written (or not being written) to the Logit BO that is missing data.

I am guessing that this is an Aware issue as the GET_CHANGES does not capture data changed by a process or a rule.