We have a query using the Table API, querying the table "core_company" with the following "sysparm_query":
name=Richard Lewis Law
The response includes two records, one of them with a space at the end, such as:
- Record 1, name is "Richard Lewis Law"
- Record 2, name is "Richard Lewis Law " (notice the extra space at the end)
It would be ideal if the IS operator (=) can respect the equality and avoid the second record.
Is there a way for this to be avoided?
Obviously, we will clean up those records as they are duplicates, but it still behaves in an unexpected way.
Thanks
