How to display other values in Old value column, ex. 1 -> Operational, 2 -> Retired
This table is created by database view. Does BR can do it? What methods and how they should be used?
Hi @thebananek ,
'1' is representing to operational and it is showing 1 in the 'history' because it is the value of that field and the Display Value/Field Label is Operational.
Similarly for 2,3,4, and 5.
- If you will do reporting on [cmdb_ci] table, you need to simple select the 'operational Status' is 'Operational' and so on for others.
- In [sys_choice] table you can either user label field or value field
