did you check database compatibility setting that dot notation is enabled

> On Apr 2, 2020, at 6:14 PM, Matt Bollwitt via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello –
> 
> I’m running into a condition where USE ENTITY SELECTION is not working with 
> an entity selection that is built with entitySeletion.add() command. I’m 
> wondering if I’m using it correctly. I’m running 4Dv17r6. Here is a 
> simplified version of what I’m trying to do:
> 
> C_Object($sel;$sel_d;$sel_find)
> C_Date(vFindDate)
> vFindDate:=Date(ALERT("Enter date:"))
> $sel_d:=ds.People.query("Receive_Mail = :1";True)           //all records to 
> be compared
> $sel_find:=ds.People.newSelection()  //empty entity
> For each ($item;$sel_d)
>                $sel:=ds.Entries.query("People_ID = :1 order by Entry_Date 
> desc";$item.LinkID)
>                If ($sel.length#0)              //anything found?
>                                If ($sel[0].Entry_Date<=vFindDate)           
> //compare date of first entry
>                                                $sel_find.add($item)
>                                End if
>                End if
> End for each
> USE ENTITY SELECTION($sel_find)
> 
> I can trace this and see that the $sel_find is a selection of entities from 
> People. However, when I try to pull that entity selection back into a normal 
> selection it does nothing. The selection of records in the People table is 
> the same selection as it was before the method was ran.
> 
> Can you use the entitySelection.add command  to build the entity and then 
> later use the USE ENTITY SELECTION command? I had this working using classic 
> 4D commands and thought I’d convert it to ORDA. I’m wondering if I’m 
> understanding the .add command correctly or if something else needs to be 
> done with that object before I call the USE ENTITY SELECTION.
> 
> Thanks!
> 
> Matt Bollwitt
> 
> **********************************************************************
> 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
**********************************************************************

Reply via email to