Re: Using the length parameter in a ORDA query.

2020-04-27 Thread Peter Bozek via 4D_Tech
On Mon, Apr 27, 2020 at 8:19 PM Eric Naujock wrote: > Thanks Peter. > That could be considered but the part I asked about was only part of the > query, In reality it had more parts to the query. Where essayWordCount is > an long integer. > > $records:= ds.Parent.query (“essayWordCount >100 and >

Re: Using the length parameter in a ORDA query.

2020-04-27 Thread Eric Naujock via 4D_Tech
Thanks Peter. That could be considered but the part I asked about was only part of the query, In reality it had more parts to the query. Where essayWordCount is an long integer. $records:= ds.Parent.query (“essayWordCount >100 and parentReference_return #null) I have one monster query

Re: Using the length parameter in a ORDA query.

2020-04-27 Thread Peter Bozek via 4D_Tech
On Mon, Apr 27, 2020 at 6:54 PM Eric Naujock via 4D_Tech < 4d_tech@lists.4d.com> wrote: > 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

Re: Using the length parameter in a ORDA query.

2020-04-27 Thread Eric Naujock via 4D_Tech
riginal 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 > Subject: Using the length parameter in a ORDA

RE: Using the length parameter in a ORDA query.

2020-04-27 Thread lists via 4D_Tech
bject: 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. Th

Using the length parameter in a ORDA query.

2020-04-27 Thread Eric Naujock via 4D_Tech
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