Relation of relation sort and search

Hiya All.

I have a problem with relational searching and sorting.

I am able to sort and search with a single level relation.

Say i have this structure:

Client ->HAS_MANY-> Properties ->HAS_MANY-> Keys


Keys ->HAS_ONE-> Properties ->HAS_ONE-> Client

Within the keys gridview i would like to sort and search by client

I can search and sort by property but not the second level relation

I hope this makes sense




Anyone have any ideas?



Hi Liam,

A code snippet describing your issue would help people understand what is the problem.

BTW, searching by HAS_MANY relation (or HAS_MANY -> HAS_MANY nested relation) could be possible, but I couldn’t imagine sorting by it. How do you sort by HAS_MANY relation?