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
HamzaJ's avatar
HamzaJ
Data Integration
07-19-2023

I think it is enabled by default. You can check this by going to a dashboard and click on the three dots ,next to the plus-icon to add a filter, and selecting Filter Relationship.

If it is not there , you can enable it by going to Admin > System Management > Configuration > Base configuration > Filters and enable filter relationship

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