Inverting advanced filter conditions
Posted: 05 January 2013, 14:07
Hi,
Is it possible to invert a condition in an advanced filter? I know this is possible for some of the conditions, but not all, e.g. I can't find a way to filter based on "Categories DO NOT contain Salary'.
Also, I've got a vague memory that it was possible to nest filter expressions to allow more advanced queries such as The amount is greater than 0 AND (Name is "Amazon" OR Name is "Google"). I couldn't find a way to do that though - am I misremembering or was it a feature of an earlier release?
Many thanks for a fantastic app, and looking forward to v5!
Matt.
Is it possible to invert a condition in an advanced filter? I know this is possible for some of the conditions, but not all, e.g. I can't find a way to filter based on "Categories DO NOT contain Salary'.
Also, I've got a vague memory that it was possible to nest filter expressions to allow more advanced queries such as The amount is greater than 0 AND (Name is "Amazon" OR Name is "Google"). I couldn't find a way to do that though - am I misremembering or was it a feature of an earlier release?
Many thanks for a fantastic app, and looking forward to v5!
Matt.