Custom Sort for Reports Using "State"

[JBrians]

I'm trying to sort a report using the State field. I need the States in order for a specific catalog item process. Does anyone know how to create a custom sort using States?

[pratikjagtap]

Hi @JBrians ,

Use the State Field's Order (Value) for Sorting
If your states are defined with specific values in ascending order, you can sort by state (the number field) directly in your report:

• Go to the report definition.
• In the "Sort by" option, choose State (not State display value).
• Set order to Ascending.

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍 !

Regards,

Pratik

[JBrians]

@pratikjagtap How do I tell if the States have a value?

[AshishKM]

Hi @JBrians ,

State field is choice type, what do you mean by "value" here, can you share the basic filter condition you applied for this catalog item specific report.

-Thanks,

Ashish Mishra

[JBrians]

from previous comment: "If your states are defined with specific values in ascending order, you can sort by state (the number field) ". 

I'm not sure what Pratik meant by specific values in ascending order. Here is screenshot of report. I want to show them in order of approval process...Draft --> Pending Manager Approval --> Submitted --> Accepted.

Current Sort option is only A-Z or Z-A.