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.
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?