How to compile a complete list of properties and their expressions from a dataset

If you need to extract a list of all the property names in a dataset, together with the other properties of the properties, then this can be done with the following script: 

view.properties.map(pr => {
return {
name:pr.name,
key:pr.key,
expression:pr.value.defaultValue,
type:pr.type,
defaultValue:pr.value,
tags:pr.tags,
lookupType:pr.lookupType,
lookupViewId:pr.value.lookupViewId,
isGenerated:pr.isGenerated
}})

You can simply enter this script into the Expression panel and then click on the 'Copy' icon which is located top right of the panel.

From here you can then paste it into Excel and it will be exported as a table of properties with their keys, names, type and default expression, etc.

 

Have more questions? Submit a request

Comments