Skip to main content

Hi All,

 

I'm wondering if there is an option to see history of augmented attribute?

 

Let's take a look on below example:

 

If we are changing status (augmented attribute) to "Urgent", we always want to see this case with priority "High", no matter that we will change this status to "In progress" later on. Priority field should works like IN() formula - we want to check if at least once this status was used so the priority can be assigned properly.

 

In addition to that, can we somehow see the history of those changes in simple table? For example three columns - date | user who set the status | status.

And I'm not talking about Activity History which seems to not be very customizable and is showing each field as separate change.

 

Many thanks in advance for your help!

I don't think there's a straightforward way to fix this problem. But what you can do is create a new table. Then, whenever you're updating the attribute, make sure to update this new table too. This way, you'll have the correct values whenever you need them.


Hi,

 

When using augment attributes in a new views, they always create a new table - for example:

 

when I wanted to add customisable notes to my case table called: "WORK_ORDER_CASE_TABLE" a new "WORK_ORDER_CASE_TABLE_AUG_CASE_NOTE" tables has been created. As you can see in the picture it contain info who, when updated the values in the augmented table. You can also add PQL code to check if specific status (like urgent) was appearing in the values for that case and "flag" it permanently with some colour and value :)

 

imageHope I correctly understood your problem, let me know if that helps!

 

Best Regards,

Mateusz Dudek


Hi Mateusz,

 

Thanks for your reply.

I just checked that but seems not to work?

 

In new views I cant even see the table Im looking for (so the one you mentioned - when we are creating augmented attribute, then respective table is created which stores values for those attributes). From what I heard, we cant see currently in new views records which were created manually. The record we are talking about in theory was not created manually (but manually triggered). However maybe the reason of not seeing that is just the fact it was created long time ago. No clue 🙂

 

However in old views I was using that, but it keeps only the newest value.

This is not the case in your set up?

 

Lets take one example - Document X.

Below you can see changes on the status:

 

image.pngIn table which was automatically created "XYZ_AUGMENTED_STATUS" I see only the most recent change - no history:

 

image 

Regards,

Maciek


Hi Maciek,

 

I've make some tests and it seems you're right - no full history of changes is kept - only last recent status, my bad. In theory that could be fixed with applying trigger to a augmented attribute table but for now it's not possible :|

 

The only option I can think of is to add AF that will read those values from whole table, and run a skill that will store it in the regular table, with some sort of message that they were 'saved', but that's very clumsy workaround...

 

AF proposition:

image 

Skill proposition:

imageLong term solution would be to report 2 feature request:

A) AF allowing for replacing skills - saving data into table (maybe can be done with custom HTTP request, with right header)

B) Allowing augmented attribute table to be linked to triggers

C) Full change history for Augmented Attributes table + ability to interact with them

 

Best Regards,

Mateusz Dudek


Reply