Wildcard exclusions in Explore Queries
AnsweredIs there a way to filter a row in an Explore query to exclude items using a wildcard?
Use case: We auto-create our Orgs from our customer system using an API. At the same time, we auto-create a default requester. That requester has "nouser" in the email address.
I have a simple query that pulls orgs and requesters, but I want to exclude the "nouser" requesters. I can filter the field by paging through ALL the nouser(s) and selecting them, but it would be so much easier to use some kind of wildcard.
Thank you,
-
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!
-
I figured it would be a calculated metric. What I don't see is how to set as false.
-
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:
- Next to Filters at the top of your query, click Add.
- Select the standard calculated attribute you created and click Apply.
- Then click the filter you just added (the gray box) and click false, then Apply.
- Next to Filters at the top of your query, click Add.
-
I typed metric, but I meant attribute :)
I saw that "false", but wasn't sure. Thank you for clarifying. It works.
-
Excellent, glad it worked!
-
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?
-
It looks like this recipe should do the trick! Explore recipe: Displaying organizations with no tickets
Please sign in to leave a comment.
7 Comments