Take a look at FORMULA and eval() syntax in queries... Lahav
-----Original Message----- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Eric Naujock via 4D_Tech Sent: Monday, April 27, 2020 10:54 AM To: Technical iNug 4D <4d_tech@lists.4D.com> Cc: Eric Naujock <e...@mac-cafe.com> Subject: Using the length parameter in a ORDA query. I am trying to preform an unusual query. I em effectively thing to find all the records in a parent where the parent has children. Any suggestions other than build a collection of records primary keys and use an “in” conditional. Which feels dirty. This this case I have a table “cases” with records and a Child table with records. There is a one to many relationship from child to parent with a return path of “childReference_return” I am looking for all the parents who have children. There is more to the query but I am only looking at this parent child element. I have tried using something like. $records:=ds.Parents.query (“childReference_return.length>0”) But when I do this I get null back. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************