Groups assigned for a task are displaying as [Group:102] rather than Group name

I tried searching Forum already but did not find solution for this. I am following current best practices and using a!queryProcessAnalytics to display a Portal Report in Tempo, however the Groups assigned for a task are displaying as [Group:102] rather than Group name.

I am following the R7.9 Task Report Tutorial which does include how to do special handling for Task Status and Task Details, but for some bizarre reason not Task Assigned Groups. It can not be handled they way Status and Details are as there is no special column config formatting for groups as it is text.

Please help. Thanks.

OriginalPostID-150105

OriginalPostID-150105

  Discussion posts and replies are publicly visible

  • Thanks for the info. When I try to use your attached portalReportColumn in the report display interface rule, I'm getting this error:

    Could not display interface. Please check definition and inputs.

    Interface Definition: Expression evaluation error in rule 'portalreportcolumn' at function 'apply' [line 32]: Invalid usage of keywords and non-keyword arguments in partial function evaluation. The number of inputs cannot exceed the number of blanks to fill when keywords are used in the partial function.

  • With that, now I am getting the error below. If it helps, I've attached the tempo interface rule which uses your rule, which I've named rule!eobAOTportalReportColumn.

    Thanks!

    Could not display interface. Please check definition and inputs.

    Interface Definition: Expression evaluation error while parsing rule 'eobaotportalreportcolumn' at function 'if' parameter 3 [line 29]: Missing right parenthesis in expression, found COMMA


    eobAOTreport.txt

  • No worries, Attached the portalReportColumn once again as I have found a missing comma in it. Please check it again, if there are any issues, we can debug the main rule then.

    portalReportColumn.txt

  • Great, thanks. Now we are back to this error:
    Could not display interface. Please check definition and inputs.

    Interface Definition: Expression evaluation error in rule 'eobaotportalreportcolumn' at function 'apply' [line 28]: Invalid usage of keywords and non-keyword arguments in partial function evaluation. The number of inputs cannot exceed the number of blanks to fill when keywords are used in the partial function.

  • @greggl No worries, I will be replicate the same in our internal environment and will be back with the working code shortly. Mean while please do let me know if you get any leads over the issue.
  • @greggl Changed the definition of getFormattedUserOrGroupName as per your requirement and renamed it to AT_getUserOrGroupDisplay. Also uploaded the changed definition of AT_portalReportColumn because of the new rule .AT_getUserOrGroupDisplay.

    FYI, the rules (AT_getUserOrGroupDisplay,AT_displayTextCell,AT_getTaskStatusDisplay, AT_portalReportColumn,eobAOTReport) were created in my system and the report is working perfectly. Especially AT_getUserOrGroupDisplay is tested in following scenarios successfully and the rule works perfectly and fits your tutorial:
    1. when the row holds null value
    2. When the row holds single User
    3. When the row holds multiple Users
    4. When the row holds single group
    5. When the row holds multiple groups
    6. When the row holds users and groups

    Please test it and do let me know if you have any concerns or follow up questions.