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)

Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

Hi Manish I use below code

public void executeQuery()
{
QueryBuildRange qbrName;
qbrName = SysQuery::findOrCreateRange(this.queryBuildDatasource(),fieldNum(MainAccount,Name));

qbrName.value(FilterName.text() ?'*'+queryValue(FilterName.text())+'*' :SysQuery::valueUnlimited());
super();

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

Afridi, Please share with us what was the solution? how did you fix it?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

Thanks every who replied and helped me finally problem is resolved.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

Hi Afridi

You can try QueryBuildDataSource.clearRange Method - msdn.microsoft.com/.../aa652635(v=ax.50).aspx

for e.g.: qbds.clearRange(fieldNum(VendTrans,AccountNum));

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

RE: Remove Filter from List Page

Try

this.query().clearQueryFilters();

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

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
Community Member on at

Like (0)

Report

RE: Remove Filter from List Page

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

RE: Remove Filter from List Page

Was this reply helpful? Yes No
Sohaib Cheema 48,656 User Group Leader on at

Like (0)

Report

RE: Remove Filter from List Page

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

RE: Remove Filter from List Page

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