How to set Two Filter controls

(0) Share

Report

Posted on by Ram Kumar

456

Hi,

In my Form there is grid which has the columns as shown below. I have filter controls for From....ToDate. and Site and Warehouse. My requirement is when i apply site and warehouse the grid should be filtered based on the site and warehouse. The From and To Date filter works fine.

How to achieve this.

Thanks & Regards,

Ram.

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

axk 925 on at

Like (0)

Report
Copy link

Link copied!

There are a lot of forms, which are working this way, so you can take a look at how it is done, for example, Forms\WMSTransportHandling and it's "OptionGroup". Basically, you should look at this group's control's "DataMethods" and WMSTransport_ds.executeQuery().

Was this reply helpful? Yes No
Verified answer

Peter John 288 on at

Like (0)

Report
Copy link

Link copied!

Field modified()

{

this.executequery();

}

executequery()

{

this.query().dataSourceTable(tableNum(%TableName%)).addRange(fieldNum(%TableName%, %FieldName%)).value(queryValue(%FieldValue%)); --> site value

this.query().dataSourceTable(tableNum(%TableName%)).addRange(fieldNum(%TableName%, %FieldName%)).value(queryValue(%FieldValue%)); --> warehouse value

super();

}

Before the call to super(), add the filter (range) you need to the query.

Try this and let me know

Was this reply helpful? Yes No