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
> parentReference_return #null)
>

Eric,

yes, that was clear that this is just simpified case, but still, cannot you
use something like

records:=ds.Children.query(essayWordCount >100 &
otherChildCondition).parentReference.query("conditions for parent...")

Peter Bozek


>
> I have one monster query that is generated by concatenating strings to
> build the query part and Objects creating the parameters passed to the
> query.
>
> I have used code like you example in my parking lot function.
>
**
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
**

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 that is generated by concatenating strings to build 
the query part and Objects creating the parameters passed to the query.

I have used code like you example in my parking lot function.

> On Apr 27, 2020, at 2:08 PM, Peter Bozek  wrote:
> 
> 
> 
> 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 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.
> 
> Not sure if I understand it, but why not to select all children and map them 
> to parents?  You would have something like this:
> 
> $records:=ds.Children.all().parentReference
> 
> where parentReference is name of relation from Children to Parents tables.
> 
> HTH,
> 
> Peter Bozek
> 
> 
>  
> 
> 
> 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
**

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

Not sure if I understand it, but why not to select all children and map
them to parents?  You would have something like this:

$records:=ds.Children.all().parentReference

where parentReference is name of relation from Children to Parents tables.

HTH,

Peter Bozek



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

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 “null” back, instead of 
an empty set.  Using this Idea I tried to do the query like this.

$records:=ds.Parents.query (“childReference_return # null”)

This gives me a list of exactly what I want. Of course I can’t check directly 
to see if there is more than a quantity of children, but for what I need it was 
good enough. I think to check for a quantity of children I would have to likely 
use an eval.

> On Apr 27, 2020, at 1:00 PM, lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> 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 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
> **

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

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

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