Colin- I'm new to OJB, so i don't know of a way to do what you're attempting w/in OJB. (others may chime in here) But you could use a view (assuming your DB supports them) & have the mapping point to the view table which only shows the valid/active rows.
just a possible work-around... -pgm -----Original Message----- From: Colin Kilburn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: where-clause criteria for collection-descriptor? Hi All, I'm sorry if this question has been asked before, the archive search capability seems to be broken. This is my first project using OJB, and I enjoy the convenience of the collection-descriptor/inverse-foreignkey mapping. What I'd like to do however is specify additional criteria as to what records are populated in the collection. For example, I would like to have only records whose "active" attribute is set to "true" to appear in the collection. Looking in the repository.dtd it doesn't look like I can do this declaratively. Can anyone give me a hint as to how I would go about this? I will gladly provide more detail if it's not clear what I'm trying to do. Please let me know. Thanks in advance, Colin --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
