edit a query in a list page form but the filter is not use

(0) Share

Report

Posted on by Community Member

Hi all,

I need to add a few criteria to a query in the listpageform, and prompt the user for criteria and then send that input to the datasource to executing my query. I have override the initializeQuery() like following:

public void initializeQuery(Query _query)

{

QueryRun qr;

SMAAgreementLine smaAgreementLine;

FormDataSource formDataSource = new FormDataSource();

_query.dataSourceNo(1).addRange(fieldNum(smaAgreementLine, Suspended)).value(SysQuery::valueUnlimited());

qr = new QueryRun(_query);

if(qr.prompt())

{

_query = qr.query();

}

super(_query);

}

After that open the form and change the filter to Service agreement "00001", click ok. But the result is not applied the new filter( the result is still SysQuery::valueUnlimited() filter).

We cannot send the user's input to datasource and execute the new filter.

After debugging, I found the query has been actually changed but not execute. Could you please help me? Thank you very much.

Query Repro_ServiceAgreementLineQuery object 1cbda3d0: SELECT * FROM SMAAgreementLine(SMAAgreementLine_1) WHERE ((AgreementId = N'00001')) JOIN * FROM SMAAgreementTable(SMAAgreementTable_1) ON SMAAgreementLine.AgreementId = SMAAgreementTable.AgreementId JOIN * FROM ProjTable(ProjTable_1) ON SMAAgreementTable.ProjId = ProjTable.ProjId JOIN * FROM ProjInvoiceTable(ProjInvoiceTable_1) ON ProjTable.ProjInvoiceProjId = ProjInvoiceTable.ProjInvoiceProjId JOIN * FROM ProjFundingSource(ProjFundingSource_1) ON ProjInvoiceTable.ProjInvoiceProjId = ProjFundingSource.ContractId OUTER JOIN Person, Person FROM HcmWorker(Ref_HcmWorker_HcmWorker) ON SMAAgreementLine.Worker = HcmWorker.RecId OUTER JOIN Name, RecId FROM DirPerson(Ref_DirPerson_HcmWorker_DirPerson_FK) ON HcmWorker.Person = DirPerson.RecId

*This post is locked for comments

All responses (6)

Answers (1)

Sort by

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Ben_Liu!

Where you've created the initializeQuery() method?
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Rustem,

Not the method in SMAAgreementTableListPageInteraction class, Actually I created a custom ListPage and use SMAAgreementList table as the example. I want the users to be prompted initially before loading the form with a query filter so I can enter in a value and get a filtered list initially. I used the initializeQuery class on the list page class.
Rati Sharabidze 612 on at

Like (0)

Report
Copy link

Link copied!

Hello,

For simplicity, you can check how it work on Voucher transactions form in GL.

Just put a break point in the init method of the form SysQueryForm to get the stack trace.

BR
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Try the following:

1. Remove initializeQuery() method.

2. Add range to your query datasource table.

3. In run() method of your form add the code which call prompt. (as example take a look at InventOnHandItemListPage form and InventOnHandDim query).
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!
I found the answer to my issue, It should let the formdatasource in SMAListPage to execute the new query rather
than only update the value of _query. I forget to let the FormDataSource to run with the new filter. Here is the update code:

public void initializeQuery(Query _query) { QueryRun qr; SMAAgreementLine smaAgreementLine; FormDataSource formDataSource; Form smaListPage = new Form(FormStr(SMAListPage)); //_query.dataSourceNo(1).addRange(fieldNum(smaAgreementLine, Suspended)).value('1'); //working _query.dataSourceNo(1).addRange(fieldNum(smaAgreementLine, Suspended)).value(SysQuery::valueUnlimited()); qr = new QueryRun(_query); if(qr.prompt()) { _query = qr.query(); formDataSource = this.listPage().activeRecord(smaListPage.dataSource(1).name()).dataSource(); formDataSource.query(_query); } super(_query); }

Thanks to everyone who pitched on this problem.
Suggested answer

startax 1,845 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Suspended field is NOYES enum that always have value in table 0 or 1. So give range either No or Yes or both

Community site session details