GitHub user wgmayer0 added a comment to the discussion: Simplify this query and
remove redundancy
Closest I've gotten to simplifying my solution is this:
```
SELECT json_object_agg(k, v)
FROM cypher('hermech', $$
MATCH (a:contact_name)
WHERE id(a) = 10133099161583644
OPTIONAL MATCH (a)-[:DIRECT_EMAIL_ADDRESS]->(b:direct_email_address)
OPTIONAL MATCH (a)<-[:CONTACT_NAME]-(c:account_name)
OPTIONAL MATCH (c)-[:MAIN_PHONE_NUMBER]->(d:main_phone_number)
OPTIONAL MATCH (c)-[:MAIN_STREET_ADDRESS]->(e:main_street_address)
OPTIONAL MATCH (c)-[:MAIN_DOMAIN]->(f:main_domain)
WITH [a,b,c,d,e,f] AS nodes
UNWIND nodes AS n
RETURN label(n) AS k, n.value AS v
$$) AS (k text, v text);
```
But `f` and therefore `label(f)` doesn't exist so I am not sure how I can
filter that out.
GitHub link:
https://github.com/apache/age/discussions/2226#discussioncomment-14569067
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
