How to create an advanced user defined filter

Question

I need to create a user defined filter like this:
if (field1 = 10 and field2 = 12) or (field3 = 13 and field4 = 13) or (field5 = 15 and field6 = 16)
In Settings->User Interface->User-defined Filters, I've created a filter like this:
['|', '|', ['&', ['field1', '=', 10], ['field2', '=', 12]], ['&', ['field2', '=', 13], ['field4', '=', 14]] , ['&', ['field5', '=', 15], ['field6', '=', 16]]]
But it's giving error on client browser:
ValueError: Invalid leaf ['&', ['field1', '=', 10], ['field2', '=',

Temur · Accepted Answer

You're using too much parentheses for polish notation [1] ...
you should use something like:
['|', '|', '&', ('field1', '=', 10), ('field2', '=', 12),'&', ('field2', '=', 13), ('field4', '=', 14), '&', ('field5', '=', 15), ('field6', '=', 16)]

[1] https://en.wikipedia.org/wiki/Polish_notation

Jignesh Mehta · Answer

Hello Carlos,
Try this :-
*['|', '|', [('field1', '=', 10), ('field2', '=', 12)], [('field3', '=', 13), ('field4', '=', 13)], [('field5', '=', 15), ('field6', '=', 16)]]*
*
*Hope it will help you
Thanks,*
*

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!