Filter Multiple Grid Columns Using StringEdit Control

(0) Share

Report

Posted on by Community Member

Hi all ,

Please let me know how to filter multiple grid columns using a single stringEdit control .

I mean when we enter any text into the field then it should get compared with all the grid columns and if exists should get filtered accordingly .

Please provide me samples

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

reachnaidu 890 on at

Like (0)

Report

Hi,

There is no direct way to do this. Since you want to Query all the fields from the grid , We need to add ranges to the datasource that is pointing to the Grid. In the modified field method of string control, call datasource.ExecuteQuery() function

where we need to add ranges to all the fields of the Grid by using the wild card to make sure that Text appears in any of the fields

For ex:

qbds = query.addDataSource(tableNum(Inventtable));

qbr = qbds.addRange(fieldNum(Inventtable,ItemID));

qbr.value(strFmt('*%1*',TextFieldValue);

qr = new QueryRun(query);

Similarly you need to add the same for rest of the fields .. Hope this helps. If you really need a sample i could send you later.

Mean while look in SalesQuotation form where we can filter the Quotations based on Employee Id and look the executeQuery method of SalesQuotationTable datasource.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot for your Sree. I am having glance at SalesQuotation Form and Table.

Please if you find time , Send me a sample. It would be a great help to me . Please

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sree ,

Can you please let me know , how to filter a grid field if it is holding numbers as its contents.

And also please send the sample

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

Refer into this link for filtering records dynamicsaxhari.blogspot.in/.../filtering-records_15.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Hariharan ,

Thanks a lot. I have already done the filtering.

Only thing with which I am getting stucked is that in my grid there is a field called PRICE which holds only numerical values and am not able to filter using that field alone.

Rest for two other fields it is getting filtered . And am using a string edit control to filter records.

Please let me know why it is not getting filtered when am using the third field

Thanks :)

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

It should work. There may be a problem in your code. Share your code.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

public void executeQuery()

{

str s;

// queryBuildRange = QueryBuildDataSource.addRange(fieldNum(PurchTable,DeliveryName));

//fieldNum(PurchTable,URL));

F_queryBuildRange.value(strFmt('((%1 LIKE "%2")) || (%3 LIKE "%2")) || (%4 LIKE "%2"))',

fieldStr(MFilter, CustName),

"*"+ txtFilter.valueStr()+"*",

fieldStr(MFilter,ItemName),"*"+ txtFilter.valueStr()+"*",

fieldStr(MFilter,Price), System.String::Format("{#:##.####}", sysDouble)));

// fieldStr(MFilter,Price),"*"+ txtFilter.valueStr()+"*"));

super();

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am getting this error message

"Null could not be obtained."

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report
There is a problem I found in the strFmt parameters. You are referring the wrong parameters. I have changed the parameter orders. Try with my updated code and let me know.

F_queryBuildRange.value(strFmt('((%1 LIKE "%2")) || (%3 LIKE "%2")) || (%4 LIKE "%5"))', fieldStr(MFilter, CustName), "*"+ txtFilter.valueStr()+"*", fieldStr(MFilter,ItemName), fieldStr(MFilter,Price), System.String::Format("{#:##.####}", sysDouble) ));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

still am getting the same Error ( NULL Could not be Obtained ) .

Was this reply helpful? Yes No