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)

Verified answer

Martin Dráb 237,963 Most Valuable Professional on at

Like (2)

Report
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

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

get view from query

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

get view from query

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates