【报Bug】uniCloud where 查询不到数据

分类：uniCloud

bug反馈

产品分类： uniCloud/App

示例代码：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

操作步骤：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

预期结果：

{"code":"","message":"","systemInfo":[],"affectedDocs":1,"data":[{"_id":"60efa8f9827eca0001efcfd8","taskCode":1409333795300638700,"taskId":3,"totalScore":98,"scaleAnswerRespList":"[{\"number\":1,\"result\":\"0\"},{\"number\":2,\"result\":\"2\"},{\"number\":3,\"result\":\"3\"},{\"number\":4,\"result\":\"0\"},{\"number\":5,\"result\":\"0\"},{\"number\":6,\"result\":\"0\"},{\"number\":7,\"result\":\"0\"},{\"number\":8,\"result\":\"2\"},{\"number\":9,\"result\":\"1\"},{\"number\":10,\"result\":\"0\"},{\"number\":11,\"result\":\"3\"},{\"number\":12,\"result\":\"0\"},{\"number\":13,\"result\":\"0\"},{\"number\":14,\"result\":\"2\"},{\"number\":15,\"result\":\"3\"},{\"number\":16,\"result\":\"0\"},{\"number\":17,\"result\":\"0\"},{\"number\":18,\"result\":\"1\"},{\"number\":19,\"result\":\"0\"},{\"number\":20,\"result\":\"4\"},{\"number\":21,\"result\":\"1\"},{\"number\":22,\"result\":\"1\"},{\"number\":23,\"result\":\"0\"},{\"number\":24,\"result\":\"1\"},{\"number\":25,\"result\":\"0\"},{\"number\":26,\"result\":\"3\"},{\"number\":27,\"result\":\"0\"},{\"number\":28,\"result\":\"1\"},{\"number\":29,\"result\":\"4\"},{\"number\":30,\"result\":\"3\"},{\"number\":31,\"result\":\"2\"},{\"number\":32,\"result\":\"2\"},{\"number\":33,\"result\":\"1\"},{\"number\":34,\"result\":\"4\"},{\"number\":35,\"result\":\"0\"},{\"number\":36,\"result\":\"1\"},{\"number\":37,\"result\":\"1\"},{\"number\":38,\"result\":\"0\"},{\"number\":39,\"result\":\"1\"},{\"number\":40,\"result\":\"0\"},{\"number\":41,\"result\":\"3\"},{\"number\":42,\"result\":\"0\"},{\"number\":43,\"result\":\"0\"},{\"number\":44,\"result\":\"3\"},{\"number\":45,\"result\":\"0\"},{\"number\":46,\"result\":\"4\"},{\"number\":47,\"result\":\"0\"},{\"number\":48,\"result\":\"0\"},{\"number\":49,\"result\":\"0\"},{\"number\":50,\"result\":\"4\"},{\"number\":51,\"result\":\"0\"},{\"number\":52,\"result\":\"0\"},{\"number\":53,\"result\":\"0\"},{\"number\":54,\"result\":\"3\"},{\"number\":55,\"result\":\"2\"},{\"number\":56,\"result\":\"0\"},{\"number\":57,\"result\":\"2\"},{\"number\":58,\"result\":\"0\"},{\"number\":59,\"result\":\"3\"},{\"number\":60,\"result\":\"0\"},{\"number\":61,\"result\":\"0\"},{\"number\":62,\"result\":\"0\"},{\"number\":63,\"result\":\"1\"},{\"number\":64,\"result\":\"2\"},{\"number\":65,\"result\":\"0\"},{\"number\":66,\"result\":\"3\"},{\"number\":67,\"result\":\"1\"},{\"number\":68,\"result\":\"1\"},{\"number\":69,\"result\":\"3\"},{\"number\":70,\"result\":\"0\"},{\"number\":71,\"result\":\"1\"},{\"number\":72,\"result\":\"0\"},{\"number\":73,\"result\":\"0\"},{\"number\":74,\"result\":\"0\"},{\"number\":75,\"result\":\"0\"},{\"number\":76,\"result\":\"0\"},{\"number\":77,\"result\":\"2\"},{\"number\":78,\"result\":\"1\"},{\"number\":79,\"result\":\"3\"},{\"number\":80,\"result\":\"1\"},{\"number\":81,\"result\":\"0\"},{\"number\":82,\"result\":\"0\"},{\"number\":83,\"result\":\"0\"},{\"number\":84,\"result\":\"2\"},{\"number\":85,\"result\":\"2\"},{\"number\":86,\"result\":\"0\"},{\"number\":87,\"result\":\"0\"},{\"number\":88,\"result\":\"1\"},{\"number\":89,\"result\":\"2\"},{\"number\":90,\"result\":\"1\"}]","entryResultList":"[{\"name\":\"躯体化\",\"totalScore\":0,\"entryScore\":0,\"result\":null,\"levelText\":null,\"norm\":\"1.37±0.48\"},{\"name\":\"强迫症状\",\"totalScore\":11,\"entryScore\":1.1,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.62±0.58\"},{\"name\":\"人际关系\",\"totalScore\":13,\"entryScore\":1.44,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.65±0.51\"},{\"name\":\"抑郁\",\"totalScore\":31,\"entryScore\":2.38,\"result\":null,\"levelText\":\"中\",\"norm\":\"1.50±0.59\"},{\"name\":\"焦虑\",\"totalScore\":8,\"entryScore\":0.8,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.39±0.43\"},{\"name\":\"敌对\",\"totalScore\":6,\"entryScore\":1,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.48±0.56\"},{\"name\":\"恐怖\",\"totalScore\":4,\"entryScore\":0.57,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.23±0.41\"},{\"name\":\"偏执\",\"totalScore\":4,\"entryScore\":0.66,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.43±0.57\"},{\"name\":\"精神病性\",\"totalScore\":8,\"entryScore\":0.8,\"result\":null,\"levelText\":\"轻\",\"norm\":\"1.29±0.42\"},{\"name\":\"其他\",\"totalScore\":13,\"entryScore\":1.85,\"result\":null,\"levelText\":\"轻\",\"norm\":\"\"}]"}],"timeCost":207}

实际结果：

{"code":"","message":"","systemInfo":[],"affectedDocs":0,"data":[],"timeCost":324}

bug描述：

下面那段代码查询不到，直接到云数据库后台也查询不出。用doc 方法 _id 可以查询出数据

2021-07-15 14:40 负责人:无分享

2 个回复

DCloud_uniCloud_WYQ

我用你上面贴出来的数据没能复现你的问题，你这是腾讯还是阿里？在云函数云端运行时执行这个查询能查到数据吗？

leeistrue (作者)

解决问题了，是我后台 taskCode 多了个空格

2021-07-15 15:49
DCloud_uniCloud_WYQ

回复 leeistrue: 你这个taskCode不是数字吗？怎么会多个空格呢

2021-07-15 21:06
leeistrue (作者)

回复 DCloud_uniCloud_WYQ: 可能是复制数据到后台，添加数据的时候，复制多了

2021-07-20 13:58
hzbgg

你好我这样同样有这样的问题

表名字填的是正确的。字段名也是正确的，通过type where 可以查到 father_id 就是查不到数据

图在下一个评论里

2023-04-07 14:11

hzbgg - 没有介绍

你好我这样同样有这样的问题

表名字填的是正确的。字段名也是正确的，通过type where 可以查到 father_id 就是查不到数据

DCloud_uniCloud_WYQ

参考此文档：https://uniapp.dcloud.net.cn/uniCloud/hellodb.html#import

2023-04-07 16:03
hzbgg

回复 DCloud_uniCloud_WYQ: 你好我并不是在导入数据库。我也是在查询数据库时遇到的问题。用where 后查不到对应的数据。你看图。。或者看我在大厅发的帖子里的图 ==

2023-04-07 16:52
hzbgg

回复 DCloud_uniCloud_WYQ: where( father_id: ... ). 查不到数据。｜｜｜｜｜。换成 where( type: ... ) 就可以查到数据

字段名没用写错，表名也没有写错。唯一区别是 type 是普通string。father_id 是同表其他的_id. ( schme里没有配置外键)

2023-04-07 16:55
DCloud_uniCloud_WYQ

回复 3***@qq.com: 你的数据是自己导入json文件或者csv的数据还是插入的数据？上面发的地址是为了让你检查下这个字段的实际数据类型

2023-04-07 18:18
DCloud_uniCloud_WYQ

你可以通过导出数据看下这个字段有没有$oid

2023-04-07 18:18
hzbgg

回复 DCloud_uniCloud_WYQ: 刚刚导出试了一下是有$oid 的。我确实使用json 导入的可是这对我查询别的字段还有的影响吗

2023-04-07 20:26
hzbgg

回复 DCloud_uniCloud_WYQ: 我通过 father_id 这个字段where 的时候查不到数据。这个字段刚刚导出也看了。是字符串类型的

2023-04-07 20:29
DCloud_uniCloud_WYQ

回复 hzbgg: 上面两个回复我看迷糊了，你贴一条出来看看

2023-04-10 11:14
hzbgg

回复 DCloud_uniCloud_WYQ: 具体可以看一下这个帖子。也是我发的。https://ask.dcloud.net.cn/question/167105?notification_id-1240640rf-falseitem_id-235293__answer_id-235293__single-TRUE#!answer_235293

2023-04-11 08:29

要回复问题请先登录或注册

【报Bug】uniCloud where 查询不到数据

示例代码：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

操作步骤：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

实际结果：

{"code":"","message":"","systemInfo":[],"affectedDocs":0,"data":[],"timeCost":324}

bug描述：

2 个回复

公告

相关问题

【报Bug】uniCloud where 查询不到数据

示例代码： let data = {"taskCode": 1409333795300638700}; db.collection('scale').where(data).get()

操作步骤： let data = {"taskCode": 1409333795300638700}; db.collection('scale').where(data).get()

实际结果： {"code":"","message":"","systemInfo":[],"affectedDocs":0,"data":[],"timeCost":324}

bug描述：

与内容相关的链接

2 个回复

公告

相关问题

示例代码：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

操作步骤：

let data = {"taskCode": 1409333795300638700};
db.collection('scale').where(data).get()

实际结果：

{"code":"","message":"","systemInfo":[],"affectedDocs":0,"data":[],"timeCost":324}