Data Adapter Methods filters type ?

Sergey
Contributor III

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,

1 ACCEPTED SOLUTION

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

View solution in original post

3 REPLIES 3

NicolasArgente
Valued Contributor

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

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

Thanks Nicolas, exactly what I needed as a confirmation 🙂

Wikus
New Contributor III

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?