Hi Mike,

If you want to filter a column, the column need to be visible, it's already the default behaviour of the WebGrid itself.

If you still want to preserve with your scenario, you have to do the query manually.

ex: SELECT * FROM abc WHERE def='...'

Have a nice day.

Best regards,

Niven Prasetya

Thanks Niven.

The grid really needs to have a LayoutSet or GridTable property controlling whether to automatically remove hidden columns from the GrouppedColumns and FilteredColumns collections.

I cannot go back and re-query the database based on the user using the filter row.  Additionally, I can't obviously group in SQL and then display a hidden column groupped in the grid with this issue.

Mike

Hello Mike,

We have the property HideColumnsWhenGrouped to automatically remove hidden column for the GrouppedColumns. But for FilteredColumns, as I said in the previous post. It has to be visible.

I apologize, I didn't get the picture of your scenario of filtering.

Please kindly describe me about your filtering scenario? Do you want to use the default filter input on WebGrid or using the other container such as TextBox or etc to filtering?

Have a nice day.

Best regards,

Niven Prasetya