Filters Search Failing With Underscore (_)

[drveresh]

The search filter with an underscore (_) in the field name is failing, is this normal, or does it require any formatting?

Example endpoint: "/records/logs?page=1,20&order=id,desc&filter=msg,cs,account_id"

There, I am searching in the log records, where the field msg contains a string like "Service account_id 1234 is updated". So, I want to search all log records that contain the string "account_id".

I am not sure, but this could be a bug or something else.

Please help me out with its solution.

[mevdschee]

The search filter with an underscore (_) in the field name is failing, is this normal, or does it require any formatting?

Hi Veeresh, Maybe because "CS" does a SQL "LIKE" and underscore is a wildcard in SQLite? I'll try to reproduce the bug. Kind regards, Maurits

[daddyfix]

I had the same problem with underscores and 'cs' and 'sw' filters
/records/scripts?filter=filename,cs,nfs_tools/&include=id,filename
and
/records/scripts?filter=filename,sw,nfs_tools/&include=id,filename
would not work

I had to modify my query with 'eq'. but luckily the search field is exact.
/records/scripts?filter=filename,eq,nfs_tools/&include=id,filename
-> {"records":[{"id":10,"filename":"nfs_tools/"}]}

I think its the sqlite3 'LIKE'