Microsoft Dynamics AX (Archived)

Remove Filter from List Page

(0) Share

Report

Posted on by Community Member

Dear Expert

How to remove filter from List Page

as per below coding

public void executeQuery()
{
QueryBuildRange QcustomerFilter;

this.Query().datasourceNo(1).clearRanges();

QcustomerFilter = SysQuery::findOrCreateRange(vendtrans_q.datasourceTable(tableNum(VendTrans)),fieldNum(VendTrans,AccountNum));

if (txtvendorcode.text()!="")
{
QcustomerFilter.value(queryValue(txtvendorcode.text()));
}
else
{
QcustomerFilter.value(SysQuery::valueUnlimited());
}

super();

}

image is attached

Thanks

2843.grid.png

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Dick Wenning 8,705 Moderator on at

Like (0)

Report

is this a question or the solution?

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report
Your line of code

this.Query().datasourceNo(1).clearRanges();

really should be

this.queryBuildDataSource().clearRanges();

or

this.queryRunQueryBuildDataSource().clearRanges();

The problem with datasourceNo(1) is that it just assumed the correct data source will be found. It might work today, but it's a poor practice. It's the kind of thing that breaks later and leaves you scratching your head, where better practices continue to work through upgrades and changes.

There's also an important different between the queryBuildDataSource (the source query) and the queryRunQueryBuildDataSource (the running query). It shouldn't matter in your specific case.

In your findOrCreateRange statement, you use vendtrans_q instead of this.query(), and venttrans_q is not initialized anywhere in your code block, so we have no idea where that comes from. That could all by itself be responsible for your code not working.

Again, consider

SysQuery::findOrCreateRange(this.queryBuildDataSource(),

instead of

SysQuery::findOrCreateRange(vendtrans_q.datasourceTable(tableNum(VendTrans)),

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Dick

This is problem i am having

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Brandon i try below but issue not resolved

this.queryBuildDataSource().clearRanges();

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Hi,

give a try to below statement

VendTrans_ds.queryBuildDataSource().clearRanges();

//DataSourceName_DS.queryBuildDataSource().clearRanges();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Sohaib i try but not working. My data source is bind to query.

On another form my data source bind to "SalesLine" table and it is working fine.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

are you sure that 'Vendor Account' is coming from VendTrans...??

what is field name if you right click on it and click personalize

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

executequery works for first time next time i have to remove search from list page because last searches remain on list page

i have created other form from salesline table same functionality working fine

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Looking for support for below code can not clear the filter....Thanks

public void executeQuery()

{

if (txtvendorcode.text()!="")

{

SysQuery::findOrCreateRange(VendTable_ds.query().dataSourceTable( tableNum(VendTable)),fieldNum(VendTable,AccountNum)).value(SysQuery::value(txtvendorcode.valueStr()));

}

else

{

Vendtable_ds.queryBuildDataSource().clearRanges(); //Not Working

SysQuery::findOrCreateRange(VendTable_ds.query().dataSourceTable(tableNum(VendTable)),fieldNum(VendTable,AccountNum)).value(SysQuery::valueUnlimited());

}

super();

}

Was this reply helpful? Yes No