Skip to main content
Answer

Filtering by SOOrder status in Report Designer

  • August 2, 2023
  • 2 replies
  • 173 views

Forum|alt.badge.img

Hi,

 

I am trying to replicate the filters shown below in the report designer, but I am having some difficulty doing this. It seems that the report designer doesn’t like me using the full name of the status (e.g. Open, On Hold) but rather it prefers the single letter representation of the status.

 

So far I have found that letters like ‘O’ and ‘H’ work as the filter value from looking at other existing reports, but I am not sure where to find the full list of letters related to these statuses.

 

Is there a screen in the system or a table that I need to look at which will provide me with all the available statuses and their associated letter representations?

 

Kind regards,

Andrew

 

 

Best answer by Manikanta Dhulipudi

Hello @AndrewA 

If you click on Inspect element for a data field it will give you the drop down values

 

2 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hello @AndrewA 

If you click on Inspect element for a data field it will give you the drop down values

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • August 2, 2023

Perfect, thanks for such a quick reply @manikantad18 !