Email

Contains

• Definition: Checks if the email address contains a specific substring.

• Use Case: Useful for partial matches, such as filtering by domain or specific patterns.

  • Example: Filter users whose email contains "gmail".

    • email Contains "gmail" → Matches [email protected], [email protected].

NotContains

• Definition: Checks if the email address does not contain a specific substring.

• Use Case: Excludes email addresses with certain substrings.

  • Example: Exclude users whose email contains "test".

    • email NotContains "test" → Excludes [email protected], [email protected].

EndsWith

• Definition: Checks if the email address ends with a specific substring.

• Use Case: Useful for filtering by domain or top-level domain (TLD).

  • Example: Filter users whose email ends with ".com".

    • email EndsWith ".com" → Matches [email protected], [email protected].

StartsWith

• Definition: Checks if the email address starts with a specific substring.

• Use Case: Useful for filtering by specific prefixes or patterns.

  • Example: Filter users whose email starts with "admin".

    • email StartsWith "admin" → Matches [email protected], [email protected].

Equals

• Definition: Checks if the email address is exactly equal to a specific value.

• Use Case: Useful for exact matches.

  • Example: Filter users whose email is "[email protected] ".

    • email Equals "[email protected]" → Matches [email protected].

NotEquals

• Definition: Checks if the email address is not equal to a specific value.

• Use Case: Excludes specific email addresses.

  • Example: Exclude users whose email is "[email protected] ".

    • email NotEquals "[email protected]" → Excludes [email protected].

EqualsOneOf ("In" Filter)

• Definition: Checks if the email address matches one of the values in a predefined list.

• Use Case: Useful for matching multiple specific email addresses.

  • Example: Filter users whose email is "[email protected] ", "[email protected] ", or "[email protected] ".

    • email EqualsOneOf ["[email protected]", "[email protected]", "[email protected]"] → Matches any of the listed email addresses.

EqualsNoneOf ("NotIn" Filter)

• Definition: Checks if the email address matches none of the values in a predefined list.

• Use Case: Excludes multiple specific email addresses.

  • Example: Exclude users whose email is "[email protected] " or "[email protected] ".

    • email EqualsNoneOf ["[email protected]", "[email protected]"] → Excludes [email protected], [email protected].

IsEmpty

• Definition: Checks if the email field is empty (i.e., no value is present).

• Use Case: Useful for identifying users with missing or incomplete email data.

  • Example: Filter users who have not provided an email address.

    • email IsEmpty → Matches users with no email value.

IsNotEmpty

• Definition: Checks if the email field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring that all users have an email address.

  • Example: Filter users who have provided an email address.

    • email IsNotEmpty → Matches users with an email value.