database view - display other values then in Old value

[thebananek]

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? 

[Community Alums]

Hi @thebananek ,

What do you mean by other values in old value? can you explain more please.

[thebananek]

Hi @Community Alums 

Simply I need it to do report. And value 1 doesn't carry any information so I wish to use some label instead. As on screenshot below instead of "1" should be "Operational". 

[Community Alums]

Hi @thebananek ,

If you report on the database view table it will only show the numbers not really "operational", you need to find another field which displays the required label.

[thebananek]

I think about something like:
If variable in Old Value column has value 1 then display Operational

But I am not sure how this can be implemented in BR script.