Report Center - sorting results by WF #

[jmc3000]

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??

[Alpesh]

Hi,

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!

[jmc3000]

Thanks Alpesh! Any thoughts on my other question below?