dpcnm2132 2014-08-17 14:34
浏览 368
已采纳

从cypher查询运行多个return语句时出错

I'm using neo4j graph db and Is this syntax error or wrong procedure I'm getting some error like this: array(4) { ["message"]=> string(108093) "Don't know how to treat that as a predicate: my query is

       "query" => "match (u : UserProfile {token:{Token}})-[:HAS_SUBSCRIBED]->(upd)-   [:POSTED_UPDATE|PREV*0..]->(sel)
                    return (upd.image OR upd.logo),upd.firstName,upd.uId,sel.content,sel.created skip 0 limit 15",
    "params" => array (
            "Token" => "$token" 
    ) 

I want to return image or logo what ever key users have because same node I'm using for company that has logo and user has image.

  • 写回答

1条回答 默认 最新

  • drgweamoi473182981 2014-08-17 15:23
    关注

    The OR operator applies to boolean expressions. I guess you want to use the COALESCE function which returns the first non-null argument in it's parameter list:

    ...
    return coalesce(upd.image, upd.logo), ...
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 delta降尺度方法,未来数据怎么降尺度
  • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
  • ¥15 高德地图点聚合中Marker的位置无法实时更新
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错