Question Status

Suggested Answer
Codehunter asked a question on 3 Mar 2015 2:47 PM
Plz somebody tell me how this can be accomplished
Reply
Bilal Issa responded on 3 Mar 2015 2:52 PM

Hi,

can you explain more, do you want to exclude a record in a grid?

Regards,

Bilal

Reply
Suggested Answer
Dominic Lee responded on 3 Mar 2015 9:04 PM

Hi Codehunter,

In the "Init" method of the form, do the following:

dataTable_ds.queryBuildDataSource().addRange(fieldNum(dataTable,filterField)).value(<query value>);

For example, if you have a simpleList form with CustTable as data source. You can filter add filter on the CustGroup column by:

CustTable_ds.queryBuildDataSource().addRange(fieldNum(CustTable,CustGroup)).value(queryValue(30));

kind regards,

Dominic Lee

My blog | PBC

This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

Reply
Codehunter responded on 4 Mar 2015 1:17 AM

Hii Bilal,

All i need to remove item from grid as it is inserted before in the table per row

Reply
Codehunter responded on 4 Mar 2015 1:54 AM

i need to avoid duplications per row in table

Reply
Suggested Answer
Dominic Lee responded on 3 Mar 2015 9:04 PM

Hi Codehunter,

In the "Init" method of the form, do the following:

dataTable_ds.queryBuildDataSource().addRange(fieldNum(dataTable,filterField)).value(<query value>);

For example, if you have a simpleList form with CustTable as data source. You can filter add filter on the CustGroup column by:

CustTable_ds.queryBuildDataSource().addRange(fieldNum(CustTable,CustGroup)).value(queryValue(30));

kind regards,

Dominic Lee

My blog | PBC

This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

Reply