• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 7 replies
  • Subscribers 5 subscribers
  • Views 4909 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

We cannot filter out the report data based on group selected by user

chanakyar

hi All,
I have a requirement that on task report a user can filter with the Assigned To (user or group) funtionality (=tp!asignees). I have userOrGroup picker field where a user can select a user or a group . Based on that selection , reportdata will be fetched from portal report (Report = task by process model). But problem is that when we select user the filter is working fine but in case of user it is not working fine. We cannot filter out the report data based on group selected by user. Every time it is showing no data. Please help.

OriginalPostID-210488

OriginalPostID-210488

  Discussion posts and replies are publicly visible

Parents
  • 0
    The approach I'd try here would be: in the query filters, have logic to differentiate whether the input value was a user or group. AFAIK the report data will return something like "[Group:29]" when a task is group-assigned, where "29" is the group ID. We can then filter against this. If we assume single assignment of tasks and a single user-or-group box entry, then this becomes maybe not too painful to pull off.
Reply
  • 0
    The approach I'd try here would be: in the query filters, have logic to differentiate whether the input value was a user or group. AFAIK the report data will return something like "[Group:29]" when a task is group-assigned, where "29" is the group ID. We can then filter against this. If we assume single assignment of tasks and a single user-or-group box entry, then this becomes maybe not too painful to pull off.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.