get view from query

(0) Share

Report

Posted on by botten

320

How can I check what TreeNode object I have found?

static void GetViewFromQuery(Args _args)
{
#AOT
#define.QueryName(MainQuery)
#define.viewName('mainView')

TreeNode treeNode;
str tmp;
;
tmp = strFmt(#QueryPath + #AOTDelimiter + #ApplicationDataSourcesPath, identifierStr(#QueryName));
treeNode = TreeNode::findNode(tmp);
if (treeNode)
{
treeNode = treeNode.AOTfirstChild(); // Get the first data source -> view (as table)
if (treeNode)
{
tmp = treeNode.treeNodeName();

if (tmp == #viewName)
{
info(strFmt("View %1 found", tmp));
}
}
}
}

The code above can be used to find the data source offset within a query. And yes it is possible to compare the name of the datasource to a name I already know....but I find that a erroneous way.

My question is how can I check if the found treenode is of type 'view'?

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Martin Dráb 240,275 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
First of all, let me add line indention to your code and use Insert > Code. Please do it by yourself next time. I also improved your code a little bit.

static void GetViewFromQuery(Args _args) { #AOT #define.QueryName(MainQuery) #define.viewName('mainView') str queryNodePath = strFmt(#QueryPath #AOTDelimiter #ApplicationDataSourcesPath, identifierStr(#QueryName)); TreeNode treeNode = TreeNode::findNode(queryNodePath); str nodeName; if (treeNode) { treeNode = treeNode.AOTfirstChild(); // Get the first data source -> view (as table) if (treeNode) { nodeName = treeNode.treeNodeName(); if (nodeName == #viewName) { info(strFmt("View %1 found", nodeName)); } } } }

To get what you need, get the table from the Table property of the node. Then you use SysDictTable to find whether this table is actually a view:

SysDictTable::newName(tableName).isView();

By the way, I wouldn't use TreeNode at all. Consider this approach instead:

Query query = new Query(queryStr(mainView)); QueryBuildDataSource firstDs = query.dataSource(1); SysDictTable::newTableId(firstDs.table()).isView();

Was this reply helpful? Yes No
botten 320 on at

Like (0)

Report
Copy link

Link copied!

Thanks Mister Dráb. The isView() did it.

Was this reply helpful? Yes No