White space first of =* operator

[MrSEKIRO]

Version

2.14.2

Details

Hi,
I am using GridifyAsync for finding the records which some field contains some string starting with whitespace, but it ignores the first white space of that string.
e.g. I want to look for " Something" on column error:
error Like =* Something

the sql would be like:

SELECT * 
FROM tbl_Log 
WHERE Error Like '% Something%'

but it search for all strings in error column which has "Something".

Steps to reproduce

• Step 1
  make some table with string column
• Step 2
  search using below expression:
  error Like =* Something

[alirezanet]

Hi @MrSEKIRO,
Thank you for the feedback. this is a known issue, You can find a temporary workaround here (although not sure if it works for your case)
But I'll try to fix this issue in the next versions

[MrSEKIRO]

For my case it just return the result if there is no spaces and trimming is not needed.

I should wait for next version.
Tnx @alirezanet

[alirezanet]

I just tested the leading space behavior and noticed you can escape it if needed. so another workaround would be this:

Error =*\ Something

But I'm also considering adding a new configuration to disable the AutoTrim feature. what do you think?

[MrSEKIRO]

That may work but in my case I am doing some translations to Gridify filters and it won't fit well.
How about using quotations for Contains filters like that?

[alirezanet]

That may work but in my case I am doing some translations to Gridify filters and it won't fit well. How about using quotations for Contains filters like that?

If you mean something like this Error=*' Something' it will cause another problem, what if you want to search for a string that contains ' instead of space ... so basically it doesn't change anything and probably makes it worse because we need two escapes instead of one in that case. Error=*\' Something\'