Empty Returned Value

(0) Share

Report

Posted on by Community Member

Hi everyone,

How can I test if there is no returned value when executeQuery method in dataSource is running? there is any way to count the number of returned records?

Code:

 itemQbr = InventTable_ds.query().dataSourceName('InventTable').addRange(fieldnum(InventTable,ItemId)); 
 itemQbr.value(queryvalue(X));
                if(InventTable_ds.getNext()== null) //
                    {
                        info("not found!");    
                    }
                else
                    {
                        InventTable_ds.executeQuery();
                    }

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report
Hi Ennasri Ameni,

I think you can try to do something like this:

InventTable_ds.query().dataSourceName('InventTable').addRange(fieldnum(InventTable,ItemId)).value(queryvalue(X)); if (SysQuery::countTotal(InventTable_ds.queryRun())) { InventTable_ds.executeQuery(); } else { info("not found!"); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen Miroshikov,

Thank you,

The method countPrim is declared private and may only be called from methods in class SysQuery.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Sorry i did not have access to ax :) Please use SysQuery::countTotal() instead

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes i have tested it, but i get the following error: Argument '_queryRun' is incompatible with the required type.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

again my bad

if (SysQuery::countTotal(InventTable_ds.queryRun()))

but if you are doing this when queryRun does not exist yet you probably will have to write

if (SysQuery::countTotal(new QueryRun(InventTable_ds.query())))

Also if you have multiply datasources joined to inventTable you may want to use SysQuery::countLoops()

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
If you just want to check whether a record exists or not, you could do this in the datasource executeQuery:

public void executeQuery() { super(); info(strFmt('%1', this.cursor() ? true : false)); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ievgen Miroshnikov,

I have tested SysQuery::countTotal and it works fine, but with SysQuery::countLoops(), i have get a SysClientPolymorphicCreateSelector prompted, any suggestion please?

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Then use countTotal(), in your case it does not really meter. Main difference between them is the way how count is done, but here you need to know if at least 1 records exists so countTotal() could be used without any doubts.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I have tried both countTotal() and countLoops() and i got a SysClientPolymorphicCreateSelector FORM prompted.. here is my query: I have 2 dataources Inventable and BOM Table in my form:

qbds1 = InventTable_ds.query().DataSourceTable(tableNum(InventTable)); qbds2 = qbds1.addDataSource(tableNum(BOM)); qbds2.relations(true); quantityFilter = qbds2.addRange(fieldnum(BOM,BOMQty)); quantityFilter.value(queryvalue(search.text())); if (SysQuery::countTotal(new QueryRun(InventTable_ds.query())) == 0) { quantityFilter.value(SysQuery::valueUnlimited()); info('notfound'); }

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (1)

Report

Hi Ennasri Ameni,

I don't think tat it is connected to this code at all. You can get SysClientPolymorphicCreateSelector form only when you have table that is part of inheritance hierarchy on the form and data source has property insert if empty = Yes.

If you will remove this code you should get same form.

Was this reply helpful? Yes No