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

Hi HamzaJ 

Thanks for the info, sure, it was not enabled. But, unfortunately, I think that is not going to solve the issue. We need to perform AND and OR combination inside a filter of a field, not between filters related to different fields.

Thanks

HamzaJ's avatar
HamzaJ
Data Integration
07-20-2023

Then you could try to do advanced configuration on your filter and add something like this:

{
    "or": [{
        "last": {
            "count": 1,
            "offset": 7
        }
    }, {
        "last": {
            "count": 1,
            "offset": 14
        }
    }],
    "and": [{
        "last": {
            "count": 1,
            "offset": 7
        }
    }, {
        "last": {
            "count": 1,
            "offset": 14
        }
    }]
}

This is something that is only applicable within 1 filter. In this case its a date, however you can change it to text or numbers depending on your filter

 

  • 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