CFGRID - replace data store or filter on more than one column

Posted by Casuzen on Stack Overflow See other posts from Stack Overflow or by Casuzen
Published on 2010-05-12T01:09:23Z Indexed on 2010/05/12 1:14 UTC
Read the original article Hit count: 327

Filed under:

ColdFusion 8

I have a cfgrid that that is based on a query. It is not bound to a cfc function because I want a scrolling grid, not a paged grid (you must supply the page number and page size if you use BIND).. I can figure out how to make it filter on one column by using the following code, but I really need to filter on three columns...

grid.getDataSource().filter("OT_MILESTONE",t1);

Adding more to the filter string does not do the trick...it ignores anything more than the first pair of values..

so..I thought if I called a function that passes the three values and returned the query results to me, I could replace the Data Store for the grid..but I cannot figure out the syntax to get it to replace.

The returned variable for the query has the following format:

{"COLUMNS":["SEQ_KEY","ID","OT_MILESTONE"],"DATA":[[63677,"x","y"]]} 

Any ideas?

© Stack Overflow or respective owner

Related posts about coldfusion