JSON数组中如何从报表中获取有一定规则的值

{"d":[{"tag":"运行时间","value":18825.00},{"tag":"当前收线长度","value":0.00},{"tag":"实际长度","value":0.00},{"tag":"实际速度","value":0.00},{"tag":"主速设定","value":5.00},{"tag":"长度设定","value":207100.00},{"tag":"U1故障","value":0},{"tag":"U2故障","value":0},{"tag":"乳化液温度","value":0.00},{"tag":"线径不在范围内","value":0},{"tag":"U3故障报警","value":0},{"tag":"电源故障","value":0},{"tag":"放线断丝故障","value":0},{"tag":"校准故障报警","value":1},{"tag":"设定长度大于剩余长度","value":0},{"tag":"上限位故障","value":0},{"tag":"下限位故障","value":1},{"tag":"收线断丝故障","value":1},{"tag":"快停报警","value":0},{"tag":"收线未制动","value":1},{"tag":"急停报警","value":0},{"tag":"排距","value":0.60},{"tag":"线径","value":0.05},{"tag":"记米到定长","value":256.00},{"tag":"当前收线长度2","value":0.00},{"tag":"设备开机","value":0},{"tag":"设备关机","value":1},{"tag":"#DEVICE_ERROR_C600000211","value":0.00}],"sn":"C600000211","ts":"2020-10-13T03:54:23+0000"}




怎么获取value值为1的所有tag?  拼接到一个字符串里

https://bbs.fanruan.com/wenda/question/57553.html接上一贴


@zsh331召唤大佬!~

FineReport 用户p0010424 发布于 2020-10-13 17:31 (编辑于 2020-10-13 17:39)
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
2
zsh331Lv8专家互助
发布于2020-10-13 18:08

JSONPathFinder(A1, "$.d[?(@.value == 1)].tag")


WorkBook251.cpt


  • yzmrARPR3975851 yzmrARPR3975851 https://bbs.fanruan.com/wenda/question/120343.html大佬有时间看看我这个问题吗,我这边直接从数组中取值,但是取值条件本身也是JSONPathFinder获取的值,公式提示错误
    2022-06-02 10:03 
  • 2关注人数
  • 782浏览人数
  • 最后回答于:2020-10-13 18:08
    请选择关闭问题的原因
    确定 取消
    返回顶部