FIltering of numeric-string records dont work.

[tejasshah-MK]

When we use the get_records functions with filtering, if the the value we want to filter out in the key value pair is string but has numbers only, the code doesnt work out. it treats that string as integer. so for eg we want to filter out the record with "status":"2", the code doesnt work.

the above image is the query but it doesnt filter out that element. but instead of a "2", if there is a normal string, the command works perfectly, please have a look into it.

[leplatrem]

I tried to reproduce locally, and got this:

>>> client.get_records(bucket="main-workspace", collection="tests")
[{'number': 3, 'text': '3', 'id': '5cb1abf5-c8d1-4677-a4f0-ea67ea33652a', 'last_modified': 1741088465702}, {'number': 2, 'text': '2', 'id': '393da8ae-0264-49a7-a85e-0de64175722a', 'last_modified': 1741088455982}]

Works as expected with number:

>>> client.get_records(bucket="main-workspace", collection="tests", **{"number": 3})
[{'number': 3, 'text': '3', 'id': '5cb1abf5-c8d1-4677-a4f0-ea67ea33652a', 'last_modified': 1741088465702}]

Does not work as expected with strings:

>>> client.get_records(bucket="main-workspace", collection="tests", **{"number": "3"})
[{'number': 3, 'text': '3', 'id': '5cb1abf5-c8d1-4677-a4f0-ea67ea33652a', 'last_modified': 1741088465702}]

Should return empty list [] since there is no record with number="3"

>>> client.get_records(bucket="main-workspace", collection="tests", **{"text": "3"})
[]

Should return a list, since there is a record with text="3".

As workaround, you can pass a string explicitly:

>>> client.get_records(bucket="main-workspace", collection="tests", **{"text": '"3"'})
[{'number': 3, 'text': '3', 'id': '5cb1abf5-c8d1-4677-a4f0-ea67ea33652a', 'last_modified': 1741088465702}]

And a fix could be implemented here to pass ?arg="{value}" when value is a string