Hi Lundin,
your cypher-statement looks fine. I try it tomorrow and give you feedback.
In case you have interest to know more about our software migRaven, please
let it me know.
See you
Frank
Am Mittwoch, 26. März 2014 19:45:37 UTC+1 schrieb Lundin:
>
> Hi
>
> for some reason i couldnt get the param clausle to work but this one with
> inline values work
>
> CREATE (m { id:4646,parentid:3456,path:563,up:43,down:3634,
> inheritance:62623,name:"fdg",status:0 })<-[:rel_child_ini { status:0 }]-n
> WITH m AS folder START ace_nodes=node(*) FOREACH (ace_node IN filter(
> ace_node IN [[33774,1],[33775,1],[33776,1]] WHERE id(ace_nodes)=head(
> ace_node))| CREATE UNIQUE folder<-[:rel_right { status:0,explicit:head(
> tail(ace_node))}]-ace_nodes) RETURN DISTINCT ID(folder), folder.id, folder
> .parentid;
>
>
> One thing i noticed was that in your filter function you had | but i think
> it should be where ?
> I dont know if this make sense, i just played around with it, but it created
> 2 nodes and 1 relationship set 9 properties.
>
> The params should work aswell.
>
> Den onsdagen den 26:e mars 2014 kl. 18:48:01 UTC+1 skrev Frank Garling:
>>
>> Helo,
>>
>> the following statement
>>
>>
>> {"query":"start n=node({share}) create (m
>> {id:{id},parentid:{parentid},path:{path},up:{up},down:{down},inheritance:{inheritance},name:{name},status:{status}})<-[:rel_child_ini{status:0}]-n
>>
>> with m as folder start ace_nodes=node({ace}) foreach(ace_node in
>> filter(ace_node in {list}| id(ace_nodes)=head(ace_node))| create unique
>> folder<-[:rel_right{status:0,explicit:head(tail(ace_node))}]-ace_nodes)
>> return distinct ID(folder), folder.id, folder.parentid",
>> "params":{"share" : 33784, "ace":[33774,33775,33776], "id":"-226341832",
>> "parentid":"0", "path":"//server/share/folder", "up":"0", "down":"0",
>> "inheritance":"0", "name":".scf", "status":"0",
>> "list":[[33774,1],[33775,1],[33776,1]]}}
>>
>> works with cypher 1.9 like a charm. Replacing the ":" characters with
>> pipes in the foreach constructs causes an exception: invalid input.
>>
>> What works wrong?
>>
>> Thanks in advance
>>
>> Frank /aikux
>>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
