Hi,

I have a question about how to write a cypher query...

Here's the query that comes close to working ;-)

Konsole output
START ip=node:IPaddrNode('*:*')
OPTIONAL MATCH host-[:nicowner]->nic-[:ipowner]->ip
WITH ip, nic, host
WHERE host IS NULL
RETURN ip, nic
ORDER BY ip.ipaddr

This always returns ip, NULL. :-(

It returns the right ips, but I would like the nic for the case that a
nic exists in an ipowner relationship to an IP address.

Sometimes there's just a standalone IP (with no associated NIC)
Sometimes there's an IP, NIC pair
and sometimes there's a host, IP, MAC triple.

I want to return the IP, NIC pair if it exists, and the IP and NULL if
there is no related NIC. But I want the NIC if it exists.

How should I do this?

    Thanks!

    -- Alan Robertson
       [email protected]




-- 

Alan Robertson / CTO
[email protected] <mailto:[email protected]>/ +1
303.947.7999

Assimilation Systems Limited
http://AssimilationSystems.com

Twitter <https://twitter.com/ossalanr> Linkedin
<https://www.linkedin.com/in/alanr> skype
<https://htmlsig.com/skype?username=alanr_unix.sh>

-- 
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.

Reply via email to