Filters not working on Form

(0) Share

Report

Posted on by Faqruddin

1,883

Dears,

I develop one Form with multiple data sources. I have data source called CustInvoiceTrans on my Form. I'm trying to filter the data with InvoiceDate(FromDate and ToDate). For that I use executeQuery() method with below logic and once filter values passed the button Clicked have following code. But My gird is not filtering. Please advice.

public void executeQuery() //on custinvoiceTran datasoucre
{
  QueryBuildRange qbr1;
qbr1 = SysQuery::findOrCreateRange(this.query().dataSourceTable(tableNum(CustInvoiceTrans)), fieldNum(CustInvoiceTrans, InvoiceDate));

    if (FromDateCtrl.dateValue() !=systemDateGet() && ToDateCtrl.dateValue() !=systemDateGet())

   {
    qbr1.value(SysQuery::range(FromDateCtrl.dateValue(),ToDateCtrl.dateValue()));

    }

    else

{

       qbr1.value(SysQuery::valueUnlimited());

}
 super();  
}

void clicked()

{
 super();
CustInvoiceTrans_1_DS.executeQuery();


}

Thanks

Faqru

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Martin Dráb 238,127 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your code looks fine to me. Is CustInvoiceTrans a root data source, or is it joined to another one? Is the grid bound to CustInvoiceTrans?

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report
Copy link

Link copied!

CustInvoiceTrans not root data source. Its linked with SalesTable. The values in grid From SalesTable, CustInvoiceTrans etc..

Was this reply helpful? Yes No
Verified answer

Martin Dráb 238,127 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If they're joined, you should be working with executeQuery() of the root datasource, shouldn't you?

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin. Now I can filter the grid. And I replace the && symbol in If condition. if (FromDateCtrl.dateValue() !=systemDateGet() || ToDateCtrl.dateValue() !=systemDateGet()).

Was this reply helpful? Yes No
Suggested answer

startax 1,845 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use qbr.value(strfmt(‘(FromDate<=%1)&& (ToDate>=%2)’,Date2StrXpp(d),Date2StrXpp(d)));

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

Like (1)

Report
Copy link

Link copied!

Dinkar, don't use this syntax unless absolutely necessary. It's difficult to read and write and compiler can't check your code inside the string; using SysQuery::range() is much better.

Was this reply helpful? Yes No