Can I call 2 apoc procedures and combine the result sets in cypher?

Question

I would like to call 2 different procedures and combine the output for further matches in one cypher query. Is it possible?

So, to make it more clear:

I have created a manual index which I use in my queries with call apoc.index.search("myindex","searchterm")
I also have some own procedure, which I would like to use together with the apoc.index.search from above.

So I would with something like that

call 
apoc.index.search("myindex","searchterm") and my.own.procedure("searchterm") 
yield both resultsets

Are there any ways to do this?

Yes, you can make multiple calls to procedures from the same Cypher. And results of all procedures can be "combined" in various ways as well. Your question is currently too unspecific to say much more. Also, the query syntax you used in your question is obviously not legal Cypher. If you update your question to be more specific about my.own.procedure -- including what it returns, and how you want to "combine" the results, then we can be more helpful. — cybersam, Aug 04 '17 at 22:03

score 1 · Accepted Answer · answered Aug 08 '17 at 08:52

1

Thank you @cybersam for your comment. I've found out how to use two procedure calls. In my case it was:

```
CALL my.own.procedure(params) YIELD node as molecule, score as score 
CALL apoc.index.search('search-index',{keyword}) YIELD node as finding 
    MATCH (molecule)<-[:CONTAINS]-(d:Document) 
    MATCH (finding)--(d) 
    RETURN d
```

answered Aug 08 '17 at 08:52

Ira Re

730
3
9
25

This results in a combinatorial explosion and is only usable at (very) small scales. – HappyFace Aug 23 '19 at 19:57

Can I call 2 apoc procedures and combine the result sets in cypher?

1 Answers1