sisense.com

Metadata Item Type

Metadata Items are objects found across the Sisense application. They are the individual items within various Metadata Panels, which can be found in widgets (for example a Widget's "Categories" panel) as well as Dashboard filters.

All Metadata Items contain a jaql property defining the query-able part of the item.
Not all possible properties of this object are required or allowed in every situation - The contents will differ for widget dimensions, widget aggregations, widget filters or dashboard filters.
See JAQL documentation for more information about the syntax of the .jaql object.

Additional properties of the Metadata Item type also change based on use.
For example, only a dashboard filter item will contain the property isCascading.

Properties

NameTypeReadonlyDescriptionExample
jaql.dimstringNoDimension ID"[Patients.Gender]"
jaql.datatypestringNoDimension datatype"text"
jaql.titlestringNoItem title"GENDER"
jaql.collapsedbooleanNoTrue to display in collapsed modetrue
jaql.filterObjectNoJAQL filter - See JAQL Documentation
jaql.aggstringNoAggregation name - in simple aggregations'count'
jaql.mergedbooleanYes
jaql.indexedbooleanYes
jaql.tablestringNoDimension's Data model table name"Admissions"
jaql.columnstringNoDimension's Data model column name"Patient_ID"
jaql.formulastringNoString formula - for formula type objects. Combined with context
jaql.contextobjectNoObject describing the context for formula tokens. Combined with formula
isCascadingbooleanNoTrue for cascading (dependant) filtersfalse

Example

{
    jaql: {
        dim: "[Patients.Gender]",
        datatype: "text",
        title: "GENDER",
        collapsed: true,
        filter: {explicit: false, userMultiSelect: undefined, multiSelection: true, all: true}
    },
    isCascading: false
}
Last Updated: