Return except specific property

[ri8ika]

Is there no way to return every property except one?

For eg. the following will return all properties:

MATCH (n:Node)
RETURN n

Now, what I want/suggest to provide feature something like below if there's no way to achieve as far as current system:

MATCH (n:Node)
RETURN n {.*, !except:specific} // exclamation, otherwise it seems to be included property

[andrew_bowman]

This is something we'd love to include later, but in the meantime you can use some map functions from APOC Procedures for a workaround:

MATCH (n:Node)
RETURN apoc.map.removeKey(n {.*}, 'specific') as propsWithoutKey

[ri8ika]

Sadly, I am not using APOC.

[andrew_bowman]

In that case I don't believe there are any workarounds here for the time being, unless you want to write the equivalent as your own stored procedure and deploy it.

[stefan_armbrust]

This is very close to what you need, except it returns an array and not a map:

MATCH (n:Node)
RETURN [x in keys(n) WHERE not x in ["bad1"]| [x, n[x] ] ]

Cypher doesn't have a way to create maps with dynamic keys, so either APOC or array as workarounds.

[ri8ika]

This is something we'd love to include later...

Please reply here whenever Cypher itself will include the feature. I'll be waiting for long to get this feature...

[andrew_bowman]

We have the request in our backlog, but keep in mind this is subject to prioritization, and there is a lot on our plates for 4.0. We can't offer any guarantees on when this may make it into the product.

[ri8ika]

I hope it will be done at least in 1 year.

[theresa_temple]

Just wondering if there was any update on this topic? Would love to see this feature