Wildcard exclusions in Explore Queries

Answered

7 Comments

  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi @..., for the use case you described, I think you could create a standard calculated attribute with the following formula:

    CONTAINS([Requester email],"nouser")

    Then you could add that attribute as a query filter and set it to "false" so that your query returns only requester emails that don't include "nouser". Hope that helps!

    0
  • Louis Borocki

    I figured it would be a calculated metric. What I don't see is how to set as false.

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Ah, for my suggestion to work, it has to be an attribute, not a metric. :) After you create the attribute, you'll be able to add it as a filter to your query:

    1. Next to Filters at the top of your query, click Add.
    2. Select the standard calculated attribute you created and click Apply.
    3. Then click the filter you just added (the gray box) and click false, then Apply.

     

    0
  • Louis Borocki

    I typed metric, but I meant attribute :)

    I saw that "false", but wasn't sure. Thank you for clarifying. It works.

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    Excellent, glad it worked!

    0
  • Louis Borocki

    One additional question. The query pulls from the Support Tickets Dataset. As a result, I only get orgs and requesters that have tickets. Those that we have created with no tickets are not queried. Is there a way to query ALL orgs and requesters?

    0
  • Erin O'Callaghan
    Zendesk Documentation Team

    It looks like this recipe should do the trick! Explore recipe: Displaying organizations with no tickets

    0

Please sign in to leave a comment.

Powered by Zendesk