= Equals : Retrieves records where the field exactly matches the given value.
Example : City Equals Pune
≠ Isn't Equal : Retrieves records where the field does NOT match the given value.
Example : City Isn't Equal to Pune
Contains : Retrieves records where the field includes the given value as part of the text.
Example : City Contains "Pune"
Is Empty : Retrieves records where the field has no value or is completely blank.
Example : City Is Empty
Is Not Empty : Retrieves records where the field has any value (not blank or null).
Example : City Is Not Empty
and : The results must satisfy all specified conditions.
Example : City Equal To Pune AND Gender Equal To Female
or : The results can satisfy any of the specified conditions.
Example : City Equal To Pune OR Gender Equal To Female