Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
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}. Howe...
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
Icon for OneStream Employee rankOneStream Employee
2 years ago

Thanks Nicolas, exactly what I needed as a confirmation 🙂