CURRENT PROBLEM
Using filter to find objects in set, there must be a sequence in which relation is filtered first prior to other relation and it is inclusion only. e.g. (Relation 1 AND criteria for relation 1) AND (Relation 2 AND criteria for relation 2)
WHAT DO YOU RECOMMEND
- Allow (Relation 1 AND criteria for relation 1) OR/AND (Relation 2 AND criteria for relation 2)
- Consider all query logic, like how it is currently considered within each relation criteria input.
HOW COULD IT BE DONE
Method 1. Enable a master relation that contains all relations so users can filter all relation equally,
Method 2: Add an query logic selector between each relation criteria, for users to choose the inclusion or exclusion criteria.
REAL WORLD USE CASES
Example 1: Category of project type relation OR Person’s name for Participant relation.
Example 2: I am trying to make a view for status checking and fill up different relations that are empty. But if I enter all the relation and its criterion, it filters out everything because no one object has all requested relations empty.
RECOMMENDED ALTERNATIVES
/
ADDITIONAL CONTEXT
This logic should be applied to all future changes to set, collection and anything related to query.