Task report with filtering issues when task has multiple custom forms attached | Community
Skip to main content
Level 4
October 10, 2024
Solved

Task report with filtering issues when task has multiple custom forms attached

  • October 10, 2024
  • 1 reply
  • 804 views

Hi, 

I've created a report to show the custom forms attached to tasks. I have a new custom form that I need to attach to all existing tasks and I thought I could use the task report and filter for tasks missing a specific custom form and attach the form that way. I haven't had any success with the filters and it seems to be related to tasks having multiple custom forms, which is not working with filtering or grouping. 

When grouping, only the first custom form in the task shows. Is there any way to use text mode in a grouping to show all the attached custom forms as a string?

Is there a way to keep inline editing but show the task custom forms to be searchable in the report filter? Filtering for the form name missing didn't work, despite trying many combinations and types of category report field types. For reference, the text mode for Task-Category report field is shown below:

displayname=Custom Form Name
linkedname=direct
namekey=category.name
tile.name=component.objectcategories
valuefield=customFormsNames
valueformat=HTML
viewalias=category.name

I tried to find "customFormNames" in the API but didn't find it anywhere. I thought that may help.

 

Any ideas on this are appreciated. Thanks

Cathy

 

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

I'm a bit baffled by what's not working in terms of filters. You should be able to filter on Categories / Name / not equal to? But if that doesn't work, please use the notexists filter detailed in this similar post.

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/textmode-for-filtering-custom-forms-in-project-report/m-p/699349#M62852 

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
October 10, 2024

I'm a bit baffled by what's not working in terms of filters. You should be able to filter on Categories / Name / not equal to? But if that doesn't work, please use the notexists filter detailed in this similar post.

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/textmode-for-filtering-custom-forms-in-project-report/m-p/699349#M62852 

CBuckwalAuthor
Level 4
October 11, 2024

The only way I got the report to filter properly was to use the notexists filter you gave me the link to, Skye. Thanks very much for that! The filter worked perfectly with the text mode below with the Task-Category Name field.

 

EXISTS:A:$$EXISTSMOD=NOTEXISTS
EXISTS:A:$$OBJCODE=OBJCAT
EXISTS:A:categoryID=custom form ID
EXISTS:A:objID=FIELD:ID