I'm trying to submit this query to my neo4j-community database:
MATCH (n1:Hashtag{name:'animal'})
CALL apoc.path.subgraphNodes(n1,{}) YIELD node
WHERE node.postsCount > 1000 AND node.postsCount < 200000
RETURN node LIMIT 50
Neo4j Browser returns this error message:
**ERROR Neo.DatabaseError.General.UnknownError**
Failed rewriting AndedPropertyInequalities(Variable(node),CachedProperty(node,Variable(node),PropertyKeyName(postsCount),NODE_TYPE),LessThan(CachedProperty(node,Variable(node),PropertyKeyName(postsCount),NODE_TYPE),ParameterFromSlot(0, AUTOINT2,Integer)), GreaterThan(CachedProperty(node,Variable(node),PropertyKeyName(postsCount),NODE_TYPE),ParameterFromSlot(1, AUTOINT1,Integer)))
Tried using children: ReferenceFromSlot(0,node),NullCheckReference(0,SlottedCachedPropertyWithPropertyToken(node,PropertyKeyName(postsCount),0,false,1,1,NODE_TYPE,true)),LessThan(NullCheckReference(0,SlottedCachedPropertyWithPropertyToken(node,PropertyKeyName(postsCount),0,false,1,1,NODE_TYPE,true)),ParameterFromSlot(0, AUTOINT2,Integer)), GreaterThan(NullCheckReference(0,SlottedCachedPropertyWithPropertyToken(node,PropertyKeyName(postsCount),0,false,1,1,NODE_TYPE,true)),ParameterFromSlot(1, AUTOINT1,Integer))
I've tryied another similar query:
MATCH (n1:Hashtag{name:'animal'})
CALL apoc.path.subgraphNodes(n1,{}) YIELD node
WHERE node.postsCount > 1000
WITH node
WHERE node.postsCount < 200000
RETURN node LIMIT 50
With the same result. Could someone help me? Thank you!