Filter data with 2 "and" connectors and multiple "or" connectors

Ask for Help
1

Hello,

is there any way to filter data with a mix of “and” connectors and “or” connectors.
In the collection components I can only use either “and” or “or” connectors.

I somehow managed to get a filter option in the navigation tab (if I show multiple collections under “options” the filter option appears).
I thought I could set “and” connectors and in the collection components “or” connectors. But unfortunately the filter in the navigation tab doesn’t work.

Any other ideas one could think of?

Thank you!

2

Can you explain how your filter would be set up if it you could set it up the way you want? There are various workarounds, and sometimes you just need to change your thinking a little bit.

1 Like
3

Yes, of course.

I would like to filter out all “draft” elements. If a data row is set to “draft” (by a TRUE / FALSE switch), that data should not be shown.

On top of that I want to filter data based on different OR paramenters:

  • some posts are for all members
  • some posts are specifically for one member (if the email in the data equals the email of the user)
  • and some posts are for certain user categories

What I am missing is to filter out posts that are on “draft” status.

Is there a way to to this:

Don’t show posts where “Draft IS NOT TRUE” and show posts where (posts for all members OR posts for members category OR email equals user email).

I thought I could filter out the posts on draft on the navigation tab, but that filter doesn’t work. I hope I could explain myself.

Thank you very much for your help!

4

Ok, a case like this is best done in the table itself with an IF column. I would set it up like this:

IF Draft is checked THEN false
ELSEIF AllMembers THEN true
ELSEIF Category THEN true
ELSEIF Email is User Email THEN true
ELSE false

With this, your filter only needs to look at the single IF column value. If the result is true, then show that row.

3 Likes
5

Yes, this is genius!! I guess I just need to make the column user specific and that’s it. I will try this. I just had eye surgery and I am starting to see better, but I need some time off screen. :slight_smile:

1 Like
6

Not sure what you need to be user specific, but computed columns will become user specific if any of its source columns are user specific. That’s because most computed columns are computed on the user’s device based on the data that’s available to that user.

7

I see… My question user categories are dynamic, meaning I have a query to pull in the relevant user emails.

In order to determine if a user is part of a category I would make a query

Ifelse user category contains user email.

But you are right, I probably don’t need it to make user specific, since it’s done based on the user email anyways.

Thanks a lot Jeff!

1 Like