How to include join table fields or order-by in entities?

[Andy Parsons]

I have a many-to-many relationship between 2 tables (collections and items) and the join table contains additional data besides the left and right foreign keys. Specifically, it contains a "sequence" field which dictates the order of the items in the collection. Is there a way to include this field in an expression such as:

(select collections (with items) ...

or alternatively :order by the "sequence" field value?

Thanks for any insight!

[Immo Heikkinen]

In short, it is not possible without creating entity for the link table. Here's earlier discussion on it:

https://groups.google.com/d/topic/sqlkorma/r3kR6DyQZHo/discussion

https://groups.google.com/d/topic/sqlkorma/hpfARX6WN2M/discussion

--
You received this message because you are subscribed to the Google Groups "Korma" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlkorma+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Andy Parsons]

Thanks- apologies for not catching the earlier thread in my search. This approach works perfectly.

You received this message because you are subscribed to a topic in the Google Groups "Korma" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sqlkorma/TIU3a1VE304/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sqlkorma+u...@googlegroups.com.