webCOMAND Docs
Language Reference
cQL
Results (Objects & Rows)cQL Results
When a cQL query is performed, the results can be returned in two different ways:
- Collections - A list of objects, which retain their structure, including fields, sub-fields and so-on.
- Row Sets - A flat list of column values, which do not retain their structure, so any structured fields in the results are converted to data (a number, text string, etc).
Collections
SELECT statements result in a collection of matching objects. Each object and all of its fields can be accessed by traversing the object's fields.
Row Sets
In some cases, it is useful to get results as a set of rows, where each row contains a value for each selected field. Row sets are similar to SQL systems typically return for results. A key difference from collections is that multiple rows will be returned to represent "to many" relationships from one object.