Forum Discussion

soporteparaptx's avatar
soporteparaptx
Cloud Apps
07-19-2023

Combine AND and OR in a filter

Hi  We need to perform a filter based on dimension values, according to AND and OR logic like (field starts with 1 OR field starts with 2) AND field does not contain 4 Is there a way to perform...
dashboards & reporting
soporteparaptx's avatar
soporteparaptx
Cloud Apps
07-20-2023

Thanks HamzaJ 

I have tried this way:

{
  "or": [
    {
      "startsWith": "212"
    },
    {
      "startsWith": "213"
    },
    {
      "startsWith": "215"
    },
    {
      "startsWith": "21101"
    },
    {
      "startsWith": "21102"
    },
    {
      "startsWith": "21114"
    }
  ],
  "and": [
    {
      "doesntStartWith": "215081001"
    }
  ]
}

But if I check the SQL is generating, the AND section is not included...

Any idea about that?

Best!

soporteparaptx's avatar
soporteparaptx
Cloud Apps
07-20-2023

see this example... it's not working