I want to check two fields if the user is in any of that fields that records should come.
For this how to use OR kind of operator ? Please let me know.
I mean it is two different fields. the value may be matched either any of the field.
Did you get any solution to this??
i also have some entries in a list view. I would often like to view the entries with some filters like x == “abc” OR y == “pqr”. But i cant find a way to do that in the erpnext UI. I can do using custom script, but that seems too much of an effort everytime i wanna view something.
Is there no way from the UI to have an OR operator like we have “AND” by default (since we can add multiple filters, that act as AND)??
isn’t equal condition correct x equals abc and y equals pqr ??
Hi @all,
Frappe’s UI for filters currently has limitations when applying OR conditions. It supports = for predefined values (like Select) and LIKE for text-based fields, but there’s no native support for combining conditions with OR logic directly in the filter UI. Custom solutions are needed for more complex queries.
1 Like
well, that also works, but those are not the filters i am looking for. I wanted specifically for OR. ‘x equals abc…’ is just an example.
Interesting. I was thinking this must be a common thing for many to use an OR filter. is there an issue in the backlog where someone might be picking this up to incorporate in the UI in the near future?