Re: Complicated SQL queries

2024-01-30 Thread Christian Gonzalez
Sorry for the late follow up, but this query did return the rows I wanted using purely cayenne expressions and object select rather than creating a new objEntity in the model. My last question is if there is any fast way to convert the returned Array Objects into the ObjEntity class for ObjectEntit

RE: Complicated SQL queries

2024-01-30 Thread Jurgen Doll
Hi Christian Since the selected columns are all that’s required for ObjEntityE and there’s a simple relationship between ObjEntityE and ObjEntityA we should be able to just get ObjEntityE directly: List results = ObjectSelect.query( ObjEntityE.class ) .where( ObjEntityE.PROP_FOR_OBJ_A .dot