"Cannot filter by field [status] because it is a complex, multiple, or chil

"Cannot filter by field [status] because it is a complex, multiple, or child of a multiple data type. (APNX-1-4203-020)"

Why am I getting this error?
I have two CD's "A" and "B"
their relationship is "A" has many "B"
I am trying to apply filter on a column of "B" by referring it in CDT "A" ...

OriginalPostID-130523

OriginalPostID-130523

  Discussion posts and replies are publicly visible

Parents Reply
  • Hi I have a use case for a customization to campuspass/workforse safety application. We would like to filter incidents by user role, I was able to attach the user.role cdt to the incident cdt to make incident.user.role and use it in the record to display it in the grid. Unfortunately the filter does not work as a user can have multiple roles. When I try to filter by incident.user.role.roleId it fails with the same complex/multiple error. 

Children