Unable to combine AND and OR in filter for multiple conditions

Question

So I wish to filter a table for various conditions in a dashboard.

The easy way to do this would be like this: condition1 AND condition2 AND (condition3 or condition4 or condition5 or conditionX). But I can't seem to be able to achieve this in dashboards. The only way i found was:

(condition1 and condition2 and condition3) OR (condition1 and condition2 and condition4) OR (condition1 and condition2 and condition5) OR (and so on for every other OR condition)

However, I know that you can better combine AND and OR in map viewer. Why not in dashbords?

Thanks!

EDIT

Just to be clear, I'm talking about filtering data in a TABLE.

mikaël · Answer

Hi,

I was about to say that ther filters I'm trying to put up are for a table, so that only necessary information is shown.

But your comment has made me rethink my dashboard and I added another selector and I think I'll be able to do what I want and as you suggested, the user will choose what he/she wants to be shown.

I still think there we should be able to better combine AND and OR statements in filters, so I guess I'll leave the question open.

But I thank you very much!

DatXNguyen · Answer

Hi, all.

The best setup is supposed to let application's users DO THEIR OWN selection, not our own preset.  I managed to do some for my property's set for they to make choice of type, choice of total SQ FT, etc....  Well, it is OK to set for a few but if the selection choices are 4, 5 , quite a big mess on the header's bar

mikaël · Answer

Hi!

Yes the second type of statement solves my problem. However I must apply this condition for multiple fields, so it's rather long to do in the dashboards interface. Plus, everytime I edit my source (arcade expression), I have to start all over. I guess I'll do it in the JSON and then push it through the API.

Considering my first statement, it is mathematical and logical. You can do it in SQL:

select fields from table where field1 < 150 and field2 = 1 and (field3 = 100 or field4 = 200);

In map viewer, you can change the "levels" of the filters, so you can have nested AND and/or OR.