Nested filters in lookup functions how to contain OR condition inside AND

[arturkulik]

hello,
we have perfect function:

https://github.com/espocrm/espocrm/issues/3422

but i can not contain OR object in 'AND' main type filter ( example idea below)

the problem is that i connect with OR two different fields attribute1 and attribute2
(i was using name like '$where','$it','$it2' etc)




the solution is to search 2 times , merge results and do unique
but it would be easier doing at once like report can


can You help?

[yuri]

Hi, I don't understand the question.

In the example, it won't give any result as the first two items are mutually exclusive (within an AND block). It checks that the name equals both 'A1' and 'A2' which is not possible.

You also need to return the statement inside parentheses at the very end, as the last statement. You don't do it for $where2. The value of the latest statement is returned as the result of the (...) block.

Note that this syntax is optional, to be able to define a tree like structure in a functional way.

[arturkulik]

so is it anyway possible to serach like that:



i need to transfer report conditions here:

[yuri]

Yes. It is. It looks correct, maybe there are some mistakes if it does not work for you.

[arturkulik]

THANK YOU! , problem was ","at line 46 (should be " ; " )