Re: Foxtrot query will not run with negation conditions, even if other conditions are applied [message #1469 is a reply to message #1468] |
Tue, 21 June 2022 14:54 |
FoxTrot Engineering
Messages: 406 Registered: April 2020
|
Senior Member |
|
|
The order of the search criteria should not matter (if it does, this should probably be regarded as a bug). However, filters ([then filter by date], [then apply advanced filter] and [then filter by spotlight attribute]) are always evaluated after the other criteria (even when you add some additional criteria below the filters).
As filters can be slow, you should always try to reduce the scope first with appropriate criteria. And if you have multiple filters, it should be faster to place the filter that reduces the scope the most before the other ones.
One of the purposes of [all items of type] is to let using filters when you have no other criterion, while pushing users to use a more restricting criterion.
Jérôme - FoxTrot Engineering
|
|
|