Get child nodes of a specific node from a tree cube with getHyperCubeTreeData

Andrey_Kosarev — Sat, 28 Jan 2023 18:03:18 GMT

Hi Everybody,

I am trying to implement a hierarchical drop down menu in the mashup using enigma js. To get the data I am using a session object of type 'tree' and 'getHyperCubeTreeData' method.

The whole tree is quite large so I decided to extract it one level at a time (qDepth = 1) based on user's clicks (without selection). E.g. I only extract the children of the node that the user clicked.

The problem I have is I can't quite get how do I specify the qArea to extract only a specific node's children. I was trying to get qArea limits from a selected parent but apparently something is wrong there, the function returns random (as it seems) parts of the cube, the whole field or an empty array.

Could you please help me to specify the qArea parameter to get a specific node's children?

const hierarchyObject= { qInfo: {"qType": "tree-list"}, qTreeDataDef: { qDimensions: [ { qDef: { qFieldDefs: ['=[Field1]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field2]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field3]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field4]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field5]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field6]'], qNullSuppression : true} }, { qDef: { qFieldDefs: ['=[Field7]'], qNullSuppression : true} }, ], qInitialDataFetch: [{ //qMaxNbrOfNodes: 100, qTreeLevels: { qDepth: 1, qLeft: 0}, qTreeNodes: [{qArea: {qLeft: 1, qTop: 0, qWidth: 100, qHeight: 100}, }] }], qMode: 'DATA_MODE_TREE', qOpenFullyExpanded: true, qSuppressMissing: true, qAlwaysFullyExpanded:true } }

async function drillDown(node) { console.log(node) let leftOffset = node.qTreePath.length+1; let topOffset = node.qGroupPos; let batchHeight = node.qGroupSize ; console.log(leftOffset, topOffset, batchHeight) let obj = await hierarchyObject; let treeData = await obj.getHyperCubeTreeData({ qPath: `/qTreeDataDef`, qNodeOptions: { qMaxNbrOfNodes: 100000, qTreeLevels: { qDepth: 1, qLeft: leftOffset}, qTreeNodes: [ {qArea: {qLeft: 1, qTop: topOffset, qHeight: 1, qWidth: 1}}], }, }); console.log(treeData) }

topic Get child nodes of a specific node from a tree cube with getHyperCubeTreeData in Integration, Extension & APIs

Get child nodes of a specific node from a tree cube with getHyperCubeTreeData