代码之家  ›  专栏  ›  技术社区  ›  Damien MATHIEU

使用开始键、结束键和数组键搜索

  •  3
  • Damien MATHIEU  · 技术社区  · 14 年前

    我有一个视图,它返回几个带有数组键的元素。
    例子:

    {"total_rows":4,"offset":0,"rows":[
        {"id":"","key":[15,"2"],"value":1,"doc":{},
        {"id":"","key":[20,"2"],"value":1,"doc":{},
        {"id":"","key":[20,"3"],"value":1,"doc":{},
        {"id":"","key":[20,"4"],"value":1,"doc":{}
    ]}
    

    /database/_design/element/_view/all/?
      startkey=[15, "2"]&
      endkey=[20, "3"]&
      include_docs=true&reduce=false
    

    实例: http://jchris.couchone.com/keyhuh/_design/Record/_view/by_CreationDate_and_BoreholeName?startkey=[1267686720,%22sp4%22]&endkey=[1267686725,%22sp4

    这个不行。它返回所有的记录,即使是最后一条,它不符合数组的第二个元素。

    奇怪的是,它只适用于字符串。
    例子:

    {"total_rows":4,"offset":0,"rows":[
        {"id":"","key":["15","2"],"value":1,"doc":{},
        {"id":"","key":["20","2"],"value":1,"doc":{},
        {"id":"","key":["20","3"],"value":1,"doc":{},
        {"id":"","key":["20","4"],"value":1,"doc":{}
    ]}
    

    /database/_design/element/_view/all/?
      startkey=["15", "2"]&
      endkey=["20", "3"]&
      include_docs=true&
      reduce=false
    

    实例: http://jchris.couchone.com/keyhuh/_design/Record/_view/by_Client_and_BoreholeName?startkey=[%22Test1%22,%22sp4%22]&endkey=[%22Test1%22,%22sp4 \u9999%22]&include\u docs=true&reduce=假

    在这里,它可以很好地工作,只返回前三个元素。

    couchdb搜索带有整数和字符串的数组时,我遗漏了什么吗?还是我掉进虫子里了?

    1 回复  |  直到 12 年前
        1
  •  3
  •   J Chris A    14 年前

    这看起来是错的,可能有一些事情。你能和我们分享你的代码吗?如果数据不是专有的,您可以将数据库复制到 http://jchris.couchone.com/keyhuh

    ...

    感谢您发布实时数据。这就是被破坏的查询?

    http://jchris.couchone.com/keyhuh/_design/Record/_view/by_Client_and_BoreholeName?startkey=[%22Test1%22,%22sp4%22]&endkey=[%22Test1%22,%22sp4 \u9999%22]&reduce=假

    因为我觉得那很好。我错过了什么?