What I am trying to do -
Show only those records on incident table where manage_sid field contains only numeric value.
manage_sid is a string field.
To achieve the same, I am running filter on incident table with query -
active=true^manage_sid>=1
But I am not getting the expected results. The query is returning all the records even the ones with alphabets or alphanumeric values.
Expected result - Records which have only numeric values.
Can someone please help me out here.
TIA
