如何从gfsh中的数组中检索元素值

Question

我在gfsh DB中有以下数据：

gfsh>query --query="select * from /siteinfo"
Result : true
Limit  : 100
Rows   : 4
Result
----------------------------------------------------------------------------------------------------------
{"id":"9347292b-cad8-4837-92b0-df34b8083901","lastUpdateTime":"1646376430201","fqdn":"test03.east.net","weight":1,"administrativeState":"unlocked","distributedSystemId":"3","lastSeenPeerUpdateTime":["4:1646376427321","1:1646376427321","2:1646376427321","3:1646376427321"],"siteLeader":false}
{"id":"1493a604-1ea2-44fa-9fe4-3cb99ed8d71b","lastUpdateTime":"1646376431751","fqdn":"test01.east.net","weight":1,"administrativeState":"unlocked","distributedSystemId":"1","lastSeenPeerUpdateTime":["2:1646376431235","4:1646376431235","3:1646376431235","1:1646376431235"],"siteLeader":true}
{"id":"73ddaee1-e586-42ce-8a78-c5c3ad324bba","lastUpdateTime":"1646376430995","fqdn":"test02.east.net","weight":1,"administrativeState":"unlocked","distributedSystemId":"2","lastSeenPeerUpdateTime":["2:1646376429276","4:1646376429276","1:1646376429276","3:1646376429276"],"siteLeader":false}
{"id":"150f58b5-e43e-40ef-a25d-2c5f2a69c06b","lastUpdateTime":"1646376430783","fqdn":"test04.east.net","weight":1,"administrativeState":"unlocked","distributedSystemId":"4","lastSeenPeerUpdateTime":["1:test","2:test","3:test","4:test"],"siteLeader":false}

您可能会看到结果中没有特定的标题。("结果"字由gfsh返回(

gfsh>query --query="select e.value.Result from /siteinfo.entries e"
Result : true
Limit  : 100
Rows   : 4
Value
---------
UNDEFINED
UNDEFINED
UNDEFINED
UNDEFINED

如果"siteLeader"为"true"，我如何检索"qdn"only？

Answer 1

我不确定这里的问题是什么，因为这直接在查询常见问题解答和示例中：我能看到按查询类型列出的查询字符串示例吗？页面，与常规SQL:没有太大区别

select s.fqdn from /siteinfo s where s.siteLeader = true