On Mon, Apr 27, 2020 at 8:19 PM Eric Naujock <[email protected]> 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:[email protected]
**********************************************************************
