Can we add filters on Mongoose Grid or Grid Columns so we can filter the rows
That looks like the Soho DataGrid not a Mongoose grid.
You can filter the collection bound to a Mongoose grid using the Permanent Filter expression in design mode.
Does the Soho DataGrid work? Do you have any instructions on using a SoHo DataGrid? I've been unable to get the SoHo DataGrid to work.
Try passing it an init string expression in this format.
{"columns":[{ "id": "location", "name": "location", "field": "location", "reorderable": true, "formatter": "Text", "filterType": "text", "width": "130"}, { "id": "owner", "name": "owner", "field": "owner", "reorderable": true, "formatter": "Text", "filterType": "text", "width": "120"}, { "id": "lot", "name": "lot", "field": "lot", "reorderable": true, "formatter": "Text", "filterType": "text"}], "dataset": [{"location":"a1201", "owner":"DS1", "lot":"1"}, {"location":"a1202", "owner":"DS1", "lot":"2"}, {"location":"a1203", "owner":"DS2", "lot":"3"}]}
https://gyazo.com/a769205c8dc52bb5a832c0f0ace9cb64
Has somebody found a way to do this? It's kind of disappointing that the app builder has more features than the grid in mongoose.
Yao's suggestion from a while ago works just fine. Assuming the grid is bound to an IDO collection, add a variable to the collections permanent filter, i.e. V(varFilterExpression). Then set the variable based on the selection of other controls on the form. For example add combo box where the user can select a location with a data change event that sets the filter expression variable.
Yeah that's the problem with my case I have an API that provides me the data so I am not using any IDO or collection
So filter the API call or the code that populates the grid
