GET_CHANGES output - Audit BO

tford · Post by **tford** » Tue Nov 03, 2009 6:12 pm

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

I'm not clear what this button will do.

tford · Post by **tford** » Tue Nov 03, 2009 6:23 pm

What is the max length of your status attribute?

tazzmaxx · Post by **tazzmaxx** » Tue Nov 03, 2009 8:52 pm

Hi Tom,

The button should intiate the StatusChange process.

The max length on the status attribute is 20

tford · Post by **tford** » Tue Nov 03, 2009 9:10 pm

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

tazzmaxx · Post by **tazzmaxx** » Wed Nov 04, 2009 12:06 am

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.

tford · Post by **tford** » Wed Nov 04, 2009 12:41 am

Please try changing your status attribute to 100 characters.

I think you will be surprised at the result.

tazzmaxx · Post by **tazzmaxx** » Wed Nov 04, 2009 3:25 am

Tried it and it works as before...creates a Logit record but does not capture the old value or new value.

It only works if the record is changed by data entry.

I am assuming that you have made this work by changing data on the regular user BO and the Logit BO has a record with the changes made. I don't question this at all. This has worked for me since the GET_CHANGES function was added to Aware. What has never worked on any BO in any of my business spaces are changes that occur to a record that are updated by a process or a rule.

Support, can you confirm that GET_CHANGES will acknowledge the Old value and New Value for changes to the BO via processes and rules. It does not appear to work.

tford · Post by **tford** » Sat Nov 07, 2009 1:15 pm

You are right. I am sending over a sample BSV to support.

tazzmaxx · Post by **tazzmaxx** » Sun Nov 08, 2009 5:25 am

Thanks Tom!

aware_support · Post by **aware_support** » Tue Nov 10, 2009 6:55 am

This should be fixed in version 4.8

wings · Post by **wings** » Sun Nov 15, 2009 7:30 am

Back to my original problem.

How can I display the output better in aware:

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

The REPLACE function wont work and I assume I'm replacing CHR(13) with \n. Going by the data in the audit object I am using.

tazzmaxx · Post by **tazzmaxx** » Sun Nov 15, 2009 8:02 am

The problem is better but still does not work. When a process changes a BO a audit record is created but it is the same as before where the result is as follows:

Modified instance of 11462 of Client
Attribute Old value New value

There are no changed values...only an audit record that fires when a system process changes a BO.

If you need a example BSV please let me know and I will send one ASAP as we really need this to work properly.

aware_support · Post by **aware_support** » Mon Nov 16, 2009 4:11 am

REPLACE_PATTERN function does work. Use this:

REPLACE_PATTERN(MyObject.MyAttribute,'\t','<br>')

This will replace tabulation symbols with <br>

As far as the problem described by tazzmax is concerned - please send us the BSV (ideally a small one). The problem you describe does not happen in our tests.

wings · Post by **wings** » Mon Nov 16, 2009 6:50 am

Thanks support