After your recent changes to the SDP data model, I can't retrieve all the values of a multi-select on a single query. As it seems that one can't use nested selects on SDP reports, how can we retrieve those values (multi-select additional fields) when we need to return them from a request's query?
select value from Request_UDF_PickListValues
where picklistid in (select udf_pick44 from Request_Multi_Fields_1 where
workorderid = workorder.workorderid)
If I use the custom report, I'll get one row for each multi-select additional field (from the same request). How can I retrieve only one row per request and all the multi-select values in a column, like I did before?
Thanks.