I've noticed some very disturbing query behavior as of late. I'm
trying to do query result sorting where there is some referenced data
I'd potentially like to sort by as well. For example:
query.orderByAsc(MyQueryModel.ROOT.object().referencedObject().attribute())
Despite also including "query.distinct()" I always get a
result set that includes duplicates... but ONLY when ordering by a
referenced object's attribute. For instance,

query.orderByAsc(MyQueryModel.ROOT.object().attribute())

does NOT include any duplicate results. This applies to
multi-dimensional sorts as well. If they are all "first
order" attributes then I get the right result set. If I try to
order by any "second order" attributes then the result set
includes duplicates.

So... what gives? This seems completely broked to me. Anyone know if
this is known or if there is something that could be off in our query
building?
Thanks!
John

I've noticed some very disturbing query behavior as of late. I'm
trying to do query result sorting where there is some referenced data
I'd potentially like to sort by as well. For example:
query.orderByAsc(MyQueryModel.ROOT.object().referencedObject().attribute())
Despite also including "query.distinct()" I always get a
result set that includes duplicates... but ONLY when ordering by a
referenced object's attribute. For instance,

query.orderByAsc(MyQueryModel.ROOT.object().attribute())

does NOT include any duplicate results. This applies to
multi-dimensional sorts as well. If they are all "first
order" attributes then I get the right result set. If I try to
order by any "second order" attributes then the result set
includes duplicates.

So... what gives? This seems completely broked to me. Anyone know if
this is known or if there is something that could be off in our query
building?
Thanks!
John

I haven't seen this behavior yet, but I'd suggest you file a defect for
this.

--
Regards,
Patrick
Jazz Work Item Team