to-many relationship where I don't want most of the items

"Robert A. Decker" <[email protected]> Sun, 21 Jun 2026 17:25:03 +0200
Newsgroups gmane.comp.java.cayenne.user
Message-ID <[email protected]>
I have a to-many relationship where I really only want to pull out a few =
out of hundreds. In this case, it's those with is_visible set to true. I =
never actually work with them when is_visible is false, but I can't =
delete them either because they audit changes.

person.dataMarkerEntries - this is modelled in the modeller and pulls =
all data marker entries from the database. I don't want this.
person.visibleDataMarkerEntries  - this is my method and it has a query =
that only pulls out visible data marker entries from the database:

ObjectSelect<DataMarkerEntry> query =3D =
ObjectSelect.query(DataMarkerEntry.class)
.where(DataMarkerEntry.IS_VISIBLE.isTrue())
....

However, the visibleDataMarkerEntries won't include non-persisted (new) =
data marker entries. But if I call dataMarkerEntries to see the =
non-persisted data marker entries then will it pull all of them out of =
the database too?

Is there a way for me in visibleDataMarkerEntries to also include =
non-persisted data marker entries off of my personr instance?

Rob