[OASIS Issue Tracker] (COEL-161) Schema for Query Response

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ 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)