Hello,
I have a case module. I also have an assigned module. In my assigned module I can assign 1-many users to a case and provide more information about that user and what they are doing in the case. I need this in a separate module for a number of different reasons; instead of just adding an Assigned To field in the case module.
I would like to display ALL cases that one of those users is assigned to based on the {$userId} variable.
If I was doing SQL my SQL would look like this…
select * from {case module} where recordID in (
select {RecordId for case} from {assigned module} where {assigned user field} = ${userID}
)
How can I accomplish this using a Prefilter in a Record List?