Filter by Topic Group Name on Issue Report | Adobe Higher Education
Skip to main content
R
ryanbrogz1
Level 4
October 17, 2023
解決済み

Filter by Topic Group Name on Issue Report

  • October 17, 2023
  • 2 の返信
  • 1596 ビュー

I'm trying to create a filter for an issue level report where the parent topic group does not contain a certain name.  Sadly, parent topic group name doesn't appear to be one of the canned/selectable filters to simply add, unless it's called something other than parent topic group name.  So, I'm resorting to text mode.  I found this post (https://experienceleaguecommunities.adobe.com/t5/workfront-questions/filtering-on-topic-groups/m-p/502440#M34190) where someone else was able to filter by ID.  But, the parent topic group ID is unique within each project, so ID isn't doable.

 

Has anyone run into this before?  I don't see why adding an extra filter like the below isn't working:

queueTopic:parentTopicGroup:name=Special Requests
queueTopic:parentTopicGroup:name_Mod=cinotcontains

 

The "Show Filters" button on the report reads exactly like what I'd want, but the report generates an error.

 

このトピックへの返信は締め切られました。
ベストアンサー skyehansen

my guess is that your report filter has too many levels. If this is the case you might be better off resorting to an exists statement. Here’s a sample post showing a similar situation (too many levels).

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/task-report-for-projects-by-converted-issue-originator-s-home/m-p/622553#M56526

2 の返信

skyehansen
Community Advisor
skyehansenCommunity Advisor回答
October 17, 2023

my guess is that your report filter has too many levels. If this is the case you might be better off resorting to an exists statement. Here’s a sample post showing a similar situation (too many levels).

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/task-report-for-projects-by-converted-issue-originator-s-home/m-p/622553#M56526

R
ryanbrogz1作成者
Level 4
October 18, 2023

Thanks for the reply, didn't have any luck.  I get the queueTopic:parentTopicGroupID filter to work, but the ID is unique every time, so I thought queueTopic:parentTopicGroup:name may do the trick, which it doesn't.  I saw someone else suggest in the other post about using custom forms, which looks to work fine in some brief testing, that's probably the route I'll go here.

skyehansen
Community Advisor
skyehansenCommunity Advisor
October 25, 2023

I'm not sure why you "didn't have any luck", since you didn't bother posting any error messages? If you followed along with the original link I posted, you should have gotten to something that looked like this sample code below.

EXISTS:A:$$OBJCODE=QUET EXISTS:A:ID=FIELD:queueTopicID EXISTS:A:parentTopicGroup:name=Special Requests EXISTS:A:parentTopicGroup:name_Mod=cicontains EXISTS:A:$$EXISTSMOD=NOTEXISTS

 First two lines: there exists a queue topic where the queue topic's ID is the queueTopicID of your issue. (as you mentioned above, this is the unique identifier)

Next two lines: ALMOST exactly what you had, but now you are allowed to "remove one of the levels" (this is from my original response -- you have too many levels, and an exists statement is how you get to remove one level)

Last line: instead of saying "cinotcontains" your filter says "cicontains" and the last line is how you say "not"

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
October 18, 2023

Do all the parent topics contain another identifying factor? Possibly the same custom forms? You could try filtering on Category ID then.

R
ryanbrogz1作成者
Level 4
October 18, 2023

Another identifier was the parent topic group description, I tried using a "does not contain" then certain words/phrase.  But, that landed at the same spot - I could get the filter working with the ID of the parent topic group successfully, but not the name or description.

 

I think I will go the custom form route for this one.  I know I can put a calc field there of the topic group name, then just filter from that in any subsequent report(s).

    契約条件Accessibility statement

    Loading footer...