[GitHub] [incubator-age] afidegnum commented on issue #153: Collect returns an empty result.

[GitBox]

afidegnum commented on issue #153:
URL: https://github.com/apache/incubator-age/issues/153#issuecomment-986621487


   I just discovered the correct query later on, what I needed to do is not to 
filter any field out, the rest could be done from python
   
   ```
             SELECT * from cypher('text_test', $$
             MATCH (V:node)-[connect]->(V2:node)
                        WITH V as parent, COLLECT(V2) as children
             RETURN parent, children
   $$) as (parent agtype, children agtype);
   ```
   
   
   
{"id":844424930131987,"label":"node","properties":{"tag":"div","attrib":"{\"id\":
 \"second\", \"class\": \"below\"}"}} | 
[{"id":844424930131988,"label":"node","properties":{"tag":"div","attrib":"{\"class\":
 \"inner\"}"}}]
   -- | --
     |  
   ```
   
{"id":844424930131973,"label":"node","properties":{"tag":"body","attrib":"null"}}
 | 
[{"id":844424930131987,"label":"node","properties":{"tag":"div","attrib":"{\"id\":
 \"second\", \"class\": \"below\"}"}},
   
   
{"id":844424930131978,"label":"node","properties":{"tag":"div","attrib":"{\"id\":
 \"idone\", \"class\": 
\"classone\"}"}},{"id":844424930131974,"label":"node","properties":{"tag":"ul","attrib":"{\"class\":
 \"menu\"}"}}]
   
   
{"id":844424930131970,"label":"node","properties":{"tag":"head","attrib":"null"}}
 | 
[{"id":844424930131972,"label":"node","properties":{"tag":"title","attrib":"null"}},
   
{"id":844424930131971,"label":"node","properties":{"tag":"meta","attrib":"{\"charset\":
 \"UTF-8\"}"}}]
   
{"id":844424930131985,"label":"node","properties":{"tag":"div","attrib":"{\"id\":
 \"innertwo\"}"}} | 
[{"id":844424930131986,"label":"node","properties":{"tag":"h2","attrib":"null"}}]
   
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org