Showing results for 
Show  only  | Search instead for 
Did you mean: 

Report Center - sorting results by WF #

We created a custom report in WFM. One of the fields returned is the Workflow number, which is formatted like WF 1, WF 2, WF 3, etc. When I sort by that column, WFM doesn't seem to be handling it right. If I sort by Workflow Number smallest to highest, It thinks that WF 101 is is smaller than WF 2! Is there any way to correct this??
(2) Replies
Flexera Alumni

The issue occurs as the field is treated as a string. And so WF 101 is less than WF 2. If it is a custom sql report, then you can possibly make the change in the sql to get the report you want.

Thanks Alpesh! Any thoughts on my other question below?
Top Kudoed Authors