Boolean

Is true

• Definition: Checks if the boolean field is exactly equal to true or false.

• Use Case: Useful for filtering based on specific binary states.

  • Example: Filter customers who are subscribed to the newsletter.

    • is_subscribed Equals true → Matches customers who are subscribed.

  • Example: Filter customers who are not subscribed.

    • is_subscribed Equals false → Matches customers who are not subscribed.

Is false

• Definition: Checks if the boolean field is not equal to a specific value (true or false).

• Use Case: Useful for excluding specific binary states.

  • Example: Exclude customers who have accepted terms and conditions.

    • has_accepted_terms NotEquals true → Excludes customers who have accepted terms.

  • Example: Exclude inactive customers.

    • is_active NotEquals false → Excludes customers who are inactive.

IsEmpty

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

• Use Case: Useful for identifying missing or undefined boolean fields.

  • Example: Find customers where the "is_subscribed" field is not set.

    • is_subscribed IsEmpty → Matches customers where the "is_subscribed" field is empty or undefined.

IsNotEmpty

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

• Use Case: Useful for ensuring that the boolean field has been set.

  • Example: Filter customers where the "is_active" field has been defined.

    • is_active IsNotEmpty → Matches customers where the "is_active" field is set to either true or false.