04-20-2023 12:59 AM
Hi !
When working on Data Adapter method types, there is alsways a mention about a filter, like here for the WorkflowProfile method : Example: {AllProfiles}{Empty String or Filter Expression}.
However, what are the different filter expression available ? So far I was able to use "=" or "<>"... is it possible to use contains, do not contains, like ?
Many thanks !
Regards,
Solved! Go to Solution.
04-20-2023 03:26 AM
Hey Sergei,
In the filter expression did you try under the WHERE clause to add the the "SQLish" equivalent. It should work.
{Dimension type}{Dimension name}{Member Filter}{where column1 LIKE '%word1%'} - It is the equivalent of Contains.
Cheers
04-20-2023 03:26 AM
Hey Sergei,
In the filter expression did you try under the WHERE clause to add the the "SQLish" equivalent. It should work.
{Dimension type}{Dimension name}{Member Filter}{where column1 LIKE '%word1%'} - It is the equivalent of Contains.
Cheers
04-24-2023 04:07 AM
Thanks Nicolas, exactly what I needed as a confirmation 🙂
06-23-2023 03:44 AM
Hi Nicolas,
I am trying to specify the columns to show in the result using {where column1 = 'ColumnName'} but I get an error:
Syntax error: Missing operand after 'column1' operator.
Any idea what is wrong?