How to print Long Name or Short Name for a Translate Value
I am creating a query to pull information for Requisitions and currently when I run the query and include the REQ_STATUS I get a return for the translate value such as C = Complete and O = Open. What would I include in the query if I wanted it to return to me the Long Name or the Short Name? Instead of the query returning either C or O, I would want it to return either Complete or Open.
Thanks in advance.