In the database join element you have the capability of creating a where clause and a filter where, this is great but very restrictive. I also understand that the "Filter Where" is a WIP. I was playing with this feature and I noticed that the "Filter Where" just appends to the "Join Where" clause with an "and" between each statement. In my situation I need 2 separate where clauses, one for the element on the form and one for the filter interface in filters and advanced search.
So here is what I am thinking; would it be possible to add a dropdown for the integration statement between each where clause to specify how you want the "Join Where" and "Filter Where" to interact? I.e. Maybe have 3 options;
So here is what I am thinking; would it be possible to add a dropdown for the integration statement between each where clause to specify how you want the "Join Where" and "Filter Where" to interact? I.e. Maybe have 3 options;
- "And Join" - This is default behavior.
- "Or Join"
- "Separate - No Join" - This would not use the "Join Where" clause in the filters and only use the "Filter Where" clause for filters if the "Filter Where" is present.