Exists filter for Parent Topic Group and Parent of the Parent Topic Group | Community
Skip to main content
Level 2
August 5, 2020
Question

Exists filter for Parent Topic Group and Parent of the Parent Topic Group

  • August 5, 2020
  • 0 replies
  • 423 views

Hello, the goal is to be able to filter an issue report by the Parent Topic Group and the Parent of the Parent Topic Group.

Background:

I have a project that houses a request queue. The queue has three queue levels: Topic Group A>Topic Group B>Queue Topic (Client>Category>Sub-Category). I am able to use text mode (queueTopic:parentTopicGroup:name and queueTopic:parentTopicGroup:parent:name) to pull in the Parent Topic Group (Topic Group B/Category) and Parent of the Parent Topic Group (Topic Group A/Account) into the report view as well as a grouping parameter, but cannot figure out how to filter by them.

My hunch is I will need to use an Exists statement but I'm having trouble writing the correct syntax. Does anyone have experience with this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.