Query compound field in VDATA
A compound field is a class that includes multiple grid fields. All grids share a same set of categorical elements that are stored in the compound field. You cannot query a compound field such as SELECT plans FROM VDATA. Compound fields are not columns in VDATA.
You can use compoundName.gridName[{elementName}].gridSubFieldName to obtain a sub field’s value.
Summary
VDATA is a flat view; all columns can be obtained via the getColumns method. The negative aspects of using VDATA are:
▪Bound array fields and grid fields are presented in expanded mode.
▪You cannot query unbound array data.
See also