Restricted CMR query

[ihunter]

In an m-m relationship, I'd like to restrict the
objects returned on the basis of a field in the
join table.

E.G.

Tables: User, Message, User_Message

User_Message contains flag 'valid'.

I want to return all Messages for User which are 'valid'

Can I modify the CMR to effect this?

Many Thanks
Ian Hunter

[juhalindfors]

No, you currently cannot add attributes to the CMR relation table :-(

-- Juha

[ihunter]

Thanks for the reply...

Customised finder and a 3rd EJB it is then!

Ian