Database View Show Label from Choice Table

[Stanley Martin]

Have a requirement to provide a report for the client that shows when the State field is changed and what it changes from and to.  Found a great article from @Ankit Priyadarshi about creating the Database view between the Audit table and Incident.  I have a custom table within the Human Resources Core scope that is extended from Task.  Got the Database View created just fine and when I try the view it reports the data just fine. However, the State field shows the numeric values and not the labels.

Here is the view

So, instead of old value = 11, I'd like to show Submitted, which is grabbing the Label value from sys_choice based on the table and the element.

[Aman Kumar S]

I don't think that is possible, for audit tables you will only get backend values and not the display value

[Aman Kumar S]

Hey,

Can you confirm, if your issue was resolved?

If yes, please mark correct and close the thread, will be helpful to others 🙂

[Ankit P]

Hi Sanley,

You can create a string field on the Case Report table to store the display value of the state and then use the same field instead of the original state field.

You need the new field and Business rule to update that field every time the state changes.

Hope this helps.

Please mark the answer correct/helpful if it works.