Trim Trailing commas in the In query operator field #8681

Is your feature request related to a problem? Please describe.
When querying for multiple objects within a specific range (EX. CO #1, 3, 323, 2300) using the In operator field, it is frustrating to have the query raise an Incorrect Format error because I accidentally left a comma on the end of the list.

Describe the solution you'd like
In the In Query operator field, trailing separators (commas, spaces, etc.) should be removed from the end of the string.

Describe alternatives you've considered
An alternative error message notifying the user that trailing separators are preventing the query from running.

Reported By
The Royal Botanic Garden Edinburgh