@ThivyaGR show pyID as usual, and add a hidden calculated column CaseIDNum that extracts only digits from pyID and casts to a number, then set the report default sort to CaseIDNum so sorting is numeric. Keep filtering enabled only on the pyID column and disable filtering on CaseIDNum, so users filter by real case IDs while the sort still uses the hidden numeric. If you let users sort in the grid, set the table to use report sorting or point the column sort to CaseIDNum to avoid lexicographic order. In your function alias, strip non digits and cast to bigint or decimal to force numeric sort; for example use a regexp replace and cast on the database. If performance matters, consider persisting the numeric part in a real property set on case creation and index it, instead of computing it on the fly. For searching by case ID, either enable full text search for your Work class and reindex so pyID is searchable, or add a report parameter SearchText and a condition like pyID contains Param.SearchText. For exact matches, prefer equals on pyID to avoid partial hits. In Constellation, you can also add an Open by ID action or case picker so users can jump straight to ABC-12345. Test with mixed IDs to confirm filter uses pyID while sort uses CaseIDNum.