Metadata objects define the inherent structure of all data objects using a common metadata structure for each object type:

• Hierarchic objects - define the root data storage objects that form the basis for all hierarchically organised information, and as collectors for the full stack of subtype objects.

• Subtype objects - define information subsets of Hierarchic objects and how these are nested.

• Associative objects - define the data storage objects that contain information about the relationship between two other storage objects

• Global Associatives - a special case of Associative objects

Metadata objects can be accessed and exposed in a spreadsheet.

Accessing Metadata Objects

monjoObjectList()

This function extracts the full set of metadata objects used in a workspace and presents the information in four columns.

monjoObject(string)

This function returns single named metadata definition JSON format.

Exposing Metadata Objects

Two functions are currently available to expose information within the JSON formatted meta data objects.

objectProperty(json, key)

attributeParameters(json, parameter, asColumns)

'parameter' may be any of: name, type, label, sequence, expression, controlSettings, list, listType or description. These attribute parameters are used to define attributes of data storage objects.

arrayAttribute(objectName, attributeName)

Gets the JSON representation of an Attribute Array meta data object for the named object.

Here is a typical JSON.

{

"id": "1547",

"name": "My Grid Test",

"monjoType": "growthWareTemplate",

"type": "ListType",

"showOnly": "",

"attributes": {

"Instance list": {

"sequence": "3",

"type": "instanceList",

"width": "200",

"params": "{\"source\":\"workflowUser\"}",

"show": "true",

"preset": "[\"\",\"\",\"\",\"\"]",

"formula": ""

},

"Parent attribute list": {

"sequence": "4",

"type": "attributeList",

"width": "200",

"params": "{\"ref\":\"parent\",\"linkTo\":\"selectedObject\",\"allowed\":[\"dateBox\",\"test\",\"textArea\"],\"type\":\"supertype\"}",

"show": "true",

"formula": "",

"preset": "[\"\",\"\",\"\",\"\"]"

},

"Local attribute list": {

"type": "attributeList",

"sequence": "5",

"width": "200",

"params": "{\"ref\":\"local\",\"linkTo\":\"selectedObject\",\"allowed\":[\"dateBox\",\"text\",\"textArea\"],\"type\":\"supertype\"}",

"show": "true",

"formula": "",

"preset": "[\"\",\"\",\"\",\"\"]"

},

"A caption": {

"sequence": "1",

"type": "caption",

"width": "150",

"params": "",

"show": "true",

"preset": "[\"First\",\"Second\",\"Fourth\",\"Last\"]",

"formula": ""

},

"A list type option": {

"sequence": "2",

"type": "listBox",

"width": "120",

"params": "{\"options\":[\"Cheese\",\"Biltong\",\"Crackers\",\"Beer\"]}",

"show": "true",

"preset": "[\"Cheese\",\"Cheese\",\"Beer\",\"Beer\"]",

"formula": ""

}

},

"label": "HeADING ",

"canAdd": "true",

"description": "",

"virtual": "false",

"canEdit": "true",

"isForm": "false",

"noDelete": "false",

"noButton": "false"

}

Data Storage Objects

Accessing Storage Objects

These functions return either of a single JSON or arrays (lists) of JSON objects. When referring to an object, data object or meta data object, the JSON representation of these objects is implied.

Always check an objects JSON in a JSON editor to make sure you've selected the appropriate expression.

itemJson(id)

Gets the identified data object without replacing the references.

viewsBundle(id, asObject)

Gets a collection of objects consisting of the identified object (by ID) and its dependent or related objects.

childList(id, name)

Gets a named collection or list of child data objects of the identified data object.

idList(names)

Gets a list of data object IDs of types in the range.

dataList(names)

Gets the set of data objects listed in the range, without replacing referenced IDs.

rootViews(names)

Gets the set of data objects listed in the range, with referenced IDs replaced by labels. Subtype data objects are displayed with the comprehensive root data.

viewList(names)

Gets the set of data objects listed in the range, with referenced IDs replaced by labels. Subtype data object attributes are displayed with data specified by its meta data object.

itemView(id)

Gets the identified data object with labels replacing references.

Exposing Storage Objects

Data objects stored in cells of the spreadsheet can be converted to usable lists with the following functions:

itemValue(json, att)

Exposes the value of a single data object attribute.

itemProperty(json, property)

Exposes the value of a single data object property

itemValues(jsons, columns)

This displays, in a range, the values of the attributes named in the horizontal column range, for each data object in a vertical object (JSON) range

itemArrayAttribute(jsons, columnRange, attr)

This displays the array attribute values for the set of data objects in a range offset (after) the specified column range. The 'attribute' paramater is the name of the attribute that contains the values to be displayed.

itemProperties(jsons, columns)

This displays, in a range, the properties listed in the columns range, for each data object listed in the jsons range.

partyProp(jsons, columns)

This displays the values of the 'party' property in columns for the data objects in the jsons range.

snapshotList()

List the snapshots available in a workspace

snapshot(id)

Display all data objects of a snapshot.

totalOrderValues(jsons)

Specific.

orderTotal(array)

Specific.