Number fields stored as text don't allow searching with 'TO' operator, '<' or '>'

[mariongalley]

Describe the bug
Now that we have fixed the specific field search, we want to use the search bar for searching durations (other examples we tried were searching in recipient org income and planned dates). However, because these fields are stored as text, it means it's not possible to search for e.g for duration '12 TO 36' or duration '>12'.

Expected behavior
I expect to be able to search number fields using these characters and operators.

[BibianaC]

@mariongalley, could you attach a screenshot of how you search, please?

[ruth360Giving]

Hi - here are some examples:

additional_data.recipientOrgInfos.latestIncome: [10000 TO 100000]

• Returns no results but should match the results on GrantVis

plannedDates.duration>12

• returns inaccurate results where duration is not greater that 12

[BibianaC]

Thanks @ruth360Giving . It might return results, but not be accurate.