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...
Forum Discussion
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
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!
see this example... it's not working
