Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Order and priority of applying filters in expression

Good day!

Colleagues, i need to consult with you about order and  priorities of applying filters in any expr.

As i know, expressions calculating can react to three sources of filters:

1. Current selection

2. Bookmark filter

3. Inside field filter

4. Searching inside field filter

Some example:

sum({[Bookmark filter] <City={[Inside field filter]}, Delivery_point={"=Searching inside field filter "} >}sales)

As far as i understand, these ways for liltering have such orders and priorities:

1.Searching inside field filter  - First in order, first priority

2.Inside field filter  - Second in order, second priority

3.Bookmark filter - Third in order, third priority

4.Current selection - Fourth in order, fourth priority

Could you correct me please, if i write some wrong?


Many thanks.

3 Replies
sunny_talwar

It would be interesting to know if there is such an order of priority. AFAIK there isn't any priority.

Anonymous
Not applicable
Author

Thanks, dear)

swuehl
MVP
MVP

Interesting question.

I would rather look at this like the set identifier / bookmark in combination with the field modifiers define a set as a whole.

Is there an priority / order  in applying the field modifier to the base set identifier? I don't think so, and I believe it shouldn't.

As it shouldn't make a difference to the aggregation result if you make a manual selection in field A before you make a selection in B compared to first B, then A.

What do you think? Have you any hints that there is a priority in applying filter?

Regards,

Stefan