Display Value of State Field in report from sys_audit table

[Ankita34]

We are trying to configure history report on alm_asset table using sys_Audit table for the state field(install_status) where values are 1,2,3, 4 etc in sys audit table fields old value and new value. We need to display if old value = 1 then display customized attribute = "In use" or if oldvalue = 7 then display customized attribute = "In Maintainence"

Pls suggest.

[Mahfuz Qureshi1]

I achieved it by creating a data base view from sys_audit, sys_choice & third table of your choice for which element is getting changed. Create report on the database view.