Hello, I have an ML script-filter:
from pycelonis.pql import pql
...
query += PQLFilter(query=FILTER TABLE.COLUMN='Test')
and need to set it up to that 'test', 'TEST', 'Test' will return the result, but cannot find a way in the documentation to setup/disable case sensitivity. How can I do this???
Hi,
you can force the table to either, allcaps or all lower case. Like below
query += PQLFilter(query=Filter Lower(table.column) = 'test')
Hi,
you can force the table to either, allcaps or all lower case. Like below
query += PQLFilter(query=Filter Lower(table.column) = 'test')
Great, thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
