RE: Using the length parameter in a ORDA query.

2020-04-27 Thread lists via 4D_Tech
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 Subject: Using the lengt

Re: Using the length parameter in a ORDA query.

2020-04-27 Thread Eric Naujock via 4D_Tech
Lahav Thanks for the feedback. After writing up the question and sending it I tried to do a query where I just wanted to get all the parents when there is a child. It turns out the trick was to think a bit odd about the question. If you query under ORDA and there is no result you get “n

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 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 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 >