DQL enable (row_based) hint only returning first occurrence of repeating field
When I perform a standard DQL on a single object, I get values for repeating fields in a single, comma-delimited field. This is exactly what I want. When I attempt to retrieve a repeating value while joining two or more objects together, I get the following error:
[DM_QUERY2_E_REPEAT_TYPE_JOIN]error: "Your query is selecting repeating attributes and joining types."
Based on other web searches, I come to realize that I can resolve this problem by adding the "enable (row_based)" hint. That returns a valid result; however, it only returns the first value in the repeating field. For example, if I query a field called "repeating_field" using a standard search like:
select repeating_field from dm_document
I would get a response like "1234,abcd" - exactly what I want.
If I query "repeating_field" using a join and the row_based hint like:
select a.repeating_field from dm_document a, some_other_object b, dm_relation c
where b.r_object_id = c.parent_id and
a.r_object_id = c.child_id
I would get a response like "1234" - not good - "abcd" is missing.
Any idea how I may fix this?