[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (COEL-161) Schema for Query Response
[ https://issues.oasis-open.org/browse/COEL-161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67097#comment-67097 ] Paul Bruton commented on COEL-161: ---------------------------------- The QueryResult example we have in the document is not valid JSON. We have : {"QueryResult": { "Table": [ "Row": [ {"ColName": "WHEN_DURATION", "Aggregator": "SUM","Value": 127.3}, {"ColName": "HOW_RELIABILITY","Aggregator": "AVG","Value": 83}, {"ColName": "WHAT_CLUSTER", "Value": 12}, {"ColName": "WHAT_CLASS", "Value": 23}, {"ColName": "WHAT_ELEMENT", "Value": 2031}, {"ColName": "WHAT_SUBCLASS", "Value": 1256} ], "Row": [ {"ColName": "WHEN_DURATION", "Aggregator": "SUM","Value": 993}, {"ColName": "HOW_RELIABILITY","Aggregator": "AVG","Value": 12}, {"ColName": "WHAT_CLUSTER", "Value": 12}, {"ColName": "WHAT_CLASS", "Value": 23}, {"ColName": "WHAT_ELEMENT", "Value": 2037}, {"ColName": "WHAT_SUBCLASS", "Value": 1334} ] ] }} .... but the "Row:" text is superflous. It should look like .... {"QueryResult": { "Table": [ [ {"ColName": "WHEN_DURATION", "Aggregator": "SUM","Value": 127.3}, {"ColName": "HOW_RELIABILITY","Aggregator": "AVG","Value": 83}, {"ColName": "WHAT_CLUSTER", "Value": 12}, {"ColName": "WHAT_CLASS", "Value": 23}, {"ColName": "WHAT_ELEMENT", "Value": 2031}, {"ColName": "WHAT_SUBCLASS", "Value": 1256} ], [ {"ColName": "WHEN_DURATION", "Aggregator": "SUM","Value": 993}, {"ColName": "HOW_RELIABILITY","Aggregator": "AVG","Value": 12}, {"ColName": "WHAT_CLUSTER", "Value": 12}, {"ColName": "WHAT_CLASS", "Value": 23}, {"ColName": "WHAT_ELEMENT", "Value": 2037}, {"ColName": "WHAT_SUBCLASS", "Value": 1334} ] ] }} ...where Table is simply and array of arrays. I will correct the text and build the schema based on the corrected version. > Schema for Query Response > ------------------------- > > Key: COEL-161 > URL: https://issues.oasis-open.org/browse/COEL-161 > Project: OASIS Classification of Everyday Living (COEL) TC > Issue Type: Bug > Reporter: David Snelling > Assignee: Paul Bruton > > We should include a schema for Query Response. -- This message was sent by Atlassian JIRA (v6.2.2#6258)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]