select_result_rows
The select_result_rows function is used to get rows in multilevel reports.
svc=report/select_result_rows¶ms={"tableIndex":<int>,
"config":{
"type":"<text>",
"data":{}
}}
Parameters
| Name | Description |
|---|---|
| tableIndex | Table index. |
| config | Configuration. |
| type | The request type:
|
| data | The data for the configuration. |
If the type parameter is range, the data parameter has the following format:
"data":{
"from":<uint>,
"to":<uint>,
"level":<uint>,
"flat":<uint>,
"rawValues":<uint>,
"unitInfo":<uint>
}
| Option | Description |
|---|---|
| from | The index of the first row. |
| to | The index of the last row. |
| level | Nesting level. |
| flat | Show the nesting level on the same level with the parent row:
The parameter is optional. The default value is 0. |
| rawValues | Show the parameters v, vt:
The parameter is optional. The default value is 0. |
| unitInfo | Show uid:
The parameter is optional. The default value is 0. |
If the type parameter is row, the data parameter has the following format:
"data":{
"rows":[<int>],
"level":<uint>,
"flat":<int>,
"rawValues":<uint>,
"unitInfo":<uint>,
"from":<int>,
"to":<int>
}
| Option | Description |
|---|---|
| rows | The index of the row. You can indicate the index of a nested row to up to next-to-last nesting level. |
| level | Nesting level. |
| flat | Show the nesting level on the same level with the parent row:
The parameter is optional. The default value is 0. |
| from | The index of the first nested row (optional). |
| to | The index of the last nested row (optional). |
| rawValues | Show the raw values data:
The parameter is optional. The default value is 0. |
| unitInfo | Show uid:
The parameter is optional. The default value is 0. |
Returned result
[
{
"n":<uint>, /* row index (from 0) */
"i1":<uint>, /* the number of the first message in the specified interval */
"i2":<uint>, /* the number of the last message in the specified interval */
"t1":<uint>, /* the time of the first message in the specified interval */
"t2":<uint>, /* the time of the last message in the specified interval */
"d":<int>, /* the quantity of the rows with the next nesting level */
"uid":<long>, /* unit ID; only if unitInfo is set to 1 */
"c":[ /* the array of cells */
{ /* common cell type */
"t":"<text>", /* formatted cell value */
"v":<double>, /* original cell value */
"vt":<double>, /* value type */
"pi": { /* property items */
"t":"<text>", /* property items type */
"ids": [ /* the array of property item IDs */
]
},
"y":<double>, /* latitude */
"x":<double>, /* longitude */
"c":"<text>" /* cell colour (only if cell has a colour) in "RRGGBB" format */
},
{ /* cell type: video or image */
"t":"<text>", /* cell value text */
"j":<JSON>, /* cell value in JSON format */
"v":<double>, /* cell value */
"vt":<int> /* cell value type */
},
],
"r":[ /* holds the subrows which correspond to the requested nesting level */
{ /* the set of fields of the row will be the same as that of the parent row */
"n":<uint>,
"i1":<uint>,
"i2":<uint>,
...
}
]
}
]
The value types are described here.
Possible error codes:
| Code | Description |
|---|---|
| 7 | Failed to fetch the report library. |
| 6 | Failed to fetch the user. |
| 5 | Report file reading/writing error. |
| 4 | Wrong input parameters. |