Forum Discussion

Sergey's avatar
Sergey
Contributor III
2 years ago
Solved

Data Adapter Methods filters type ?

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,

Data Management
Workflow
  • NicolasArgente's avatar
    NicolasArgente
    2 years ago

    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

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    2 years ago

    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

    • Sergey's avatar
      Sergey
      Contributor III
      2 years ago

      Thanks Nicolas, exactly what I needed as a confirmation 🙂

  • Wikus's avatar
    Wikus
    New Contributor III
    2 years ago

    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?