OriginalPostID-244965
Discussion posts and replies are publicly visible
@Paule.....I really appreciate your suggestion. It was a lifesaver for me. I also had the same issue where in my case tasks could be assigned to both users or groups (multiple). For some reason users were working and I was struggling with the group piece since yesterday night.
If it helps someone:
In my report I have 2 separate colums for assignees:
1. C29 (Assigned Users) = tostring(touser(task_assignee_owner())) of formatting "Normal Text"2. C30 (Assigned Groups) = tostring(togroup(task_assignee_owner())) of formatting "Group Profile"
Code piece in my queryAnalystics
if( runtimetypeof(ri!assignedTo_usrgrp)=5, /*Check for Groups*/ apply( a!queryFilter( field:"c30", operator:"includes", value:_ ), touniformstring(union(togroup(ri!assignedTo_usrgrp),togroup(ri!assignedTo_usrgrp))) ), {} ), if(rule!APN_isBlank(ri!assignedTo_usrgrp),{}, a!queryFilter( applyWhen: runtimetypeof(ri!assignedTo_usrgrp)=4, /*Check for Users*/ field:"c29", operator:"includes", value:ri!assignedTo_usrgrp))