Microsoft Dynamics AX (Archived)

How to find if a datasource exists in an x++ query

(0) Share

Report

Posted on by Community Member

Hi Friends,

I have an x++ query which comes from some form at run time.

How to find if that query has a particular table as datasource.

Query qr;

qr = new Query(_parmquery);

// I have issue here, the below line always skips as if datasource is not there event when its there

if(qr.dataSourceTable(tableNum(CustTable).existsMeanOrExists())

then add some range

else

something

query.datasource().? what to write here.

I tried enabled and it works only if that tables exists and will through a stack trace error if its not available

query.datasource().enabled()

Please help.

Thanks,

Praveen

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

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

Like (0)

Report

I don't think your code can even compile and I don't see what useful it would do anyway, so let's rather forgot code for a sec and focus on your requirements.

As I understand, you want to find a datasource for a particular table inside a query. Do you know at which level it is? Most importantly, do you want to look only at the root level, or also at joined datasources?

Also, what if the table is used by more than one datasource? Are you fine with simply taking the first one?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for replying Martin.

I did not think through all the points you mentioned.

In my requirement I'm not concerned about the tables position whether it is at the root level or at child level or the number of times it occurs. But if you can provide me the solution for simply finding the table from the query using query classed, that would meet my need. If you can give a brief solution on how to get it from root level or child level and number of occurrences, that will be awesome.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
You can use something like this:

QueryBuildDataSource findFirstDsForTable(Query _q, TableId _tableId) { QueryBuildDataSource ds; int i; for (i = 1; i <= _q.dataSourceCount(); i++) { ds = _q.dataSourceNo(i); if (ds.table() == _tableId) { return ds; } } return null; }

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,648 on at

Like (0)

Report
Hi Praveen,

You can below code:

boolean dsExist() { Query query; QueryRun queryRun; QueryBuildDatasource datasource; boolean result; ; result = false; query = new Query(); datasource = query.addDataSource(tableNum(CustTable)); queryRun = new QueryRun(query); if(SysQuery::countLoops(queryRun) > 0); { return true; } }

Was this reply helpful? Yes No
Hossein.K 6,648 on at

Like (0)

Report

Hi Praveen,

Your problem is solved?right?

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

countLoops() counts how many records a query returns; it's not going to help with finding whether a query uses a particular table.

Was this reply helpful? Yes No
Suggested answer

Osama Omer 10 on at

Like (0)

Report
Hi,

You can try something like this:

if (qr.dataSourceTable(tableNum(CustTable))) { // CustTable datasource is found, do something. // e.g add some range } if (qr.dataSourceTable(tableNum(VendTable))) { // VendTable datasource is found, do something. }

Thanks.

Syed Osama Bin Omer.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

QueryRun.get() is used to fetch data after executing the query (and making a request to database).

Also, if you don't get anything, it doesn't necessarily mean that the table isn't used in the query. It might simply happen that there isn't any record meeting conditions specified in the query.

Was this reply helpful? Yes No
Osama Omer 10 on at

Like (0)

Report

Hi Martin,

I have updated my answer.

Thanks.

Syed Osama Bin Omer.

Was this reply helpful? Yes No