如何使用try.zorba.io从JSON运行JSONiq

问题描述

我需要编写一个JSONiq表达式，该表达式仅列出价格至少为3的产品名称.这是我在 XQuery 部分中键入的JSON文件:

I need to write a JSONiq expression that lists only the name of the products that cost at least 3. This is my JSON file which i had typed in the XQuery section:

{ "supermarket_visit":{
        "date":"08032019",
        "bought":[
            "item",{
                "type":"confectionary",
                "item_name":"Kit_Kat",
                "number": 3,
                "individual_price": 3.5
                },
            "item",{
                "type":"drinks",
                "item_name":"Coca_Cola",
                "number": 2,
                "individual_price": 3
                },
            "item",{
                "type":"fruits",
                "item_name":"apples",
                "number": "some"
                }
            ], 
"next_visit":[
            "item",{
                "type":"stationary",
                "item_name":"A4_paper",
                "number": 1
                },
            "item",{
                "type":"stationary",
                "item_name":"pen",
                "number": 2
                }
            ]
        }
}

这是我的JSONiq Xquery JSONiq命令，我真的不知道在哪里键入 try.zorba.io :

and this is my JSONiq Xquery JSONiq command, which i dont really know where to type in try.zorba.io:

let $x := find("supermarket_visit")
for $x in $supermarket.bought let $i := $x.item
where $i.individual_price <=3
return $i.item_name

我在try.zorba.io中遇到了很多错误，并且对JSONiq和JSON来说真的很新.我的JSON或JSONiq部分出问题了吗?

I am getting many errors in try.zorba.io and im really new to JSONiq and JSON. Is something wrong with my JSON or JSONiq part?

推荐答案

以下选择在您链接到的网站上对我有用:

The following selection works for me at the site you linked to:

jsoniq version "1.0";
{ "supermarket_visit":{
        "date":"08032019",
        "bought":[
            "item",{
                "type":"confectionary",
                "item_name":"Kit_Kat",
                "number": 3,
                "individual_price": 3.5
                },
            "item",{
                "type":"drinks",
                "item_name":"Coca_Cola",
                "number": 2,
                "individual_price": 3
                },
            "item",{
                "type":"fruits",
                "item_name":"apples",
                "number": "some"
                }
            ],
"next_visit":[
            "item",{
                "type":"stationary",
                "item_name":"A4_paper",
                "number": 1
                },
            "item",{
                "type":"stationary",
                "item_name":"pen",
                "number": 2
                }
            ]
        }
}.supermarket_visit.bought()[$$ instance of object and $$.individual_price le 3].item_name

这篇关于如何使用try.zorba.io从JSON运行JSONiq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！