Get Grid filtered data

[Edwin]

Hi all,

I would like to use the Grid to enable the user to filter the data and after (serverside) filtering, do something with the filtered data.

How can this be done easily? I know Telerik does this by interpreting the postback query-string and building a WHERE clause for SQL for it, but I don't want to do the heavy lifting of the parsing of the where myself.

So I am looking for a way to get the where as an expression (after a grid postback with filtering applied by the user), or simply the complete list of objects that are the result of the filtering. In the latter case, paging must be ignored.

Is this even possible, or do I have to do trickery stuff like breaking into some private Telerik methods that handle the query-string parsing :-)

Kind regards,

   Edwin.

[Petur Subev]

Hello Edwin,

Basically if you are not using client operation mode the filtering by default will be performed on the server. To perform filtering you can use the filter method which the Grid client object provides. 

Another approach would be to perform an ajaxRequest and pass some variable to the action method which then you can use on the server side to perform your own filtering on the collection before passing it to the GridModel.

$('#Grid').data().tGrid.ajaxRequest({myParam:"myValue"})

Kind Regards,
Petur Subev
the Telerik team

[Edwin]

Hello Petur,

Thanks for your reply, but it seems I didn't make myself clear. Let me give an example.

Suppose the user filters the grid by applying a filter on Name, like the name starts with "Bu".
And furthermore, the user orderd by Age.

The resulting URL will be something like:

...?listing-1-page=1&listing-1-orderBy=Age-asc&listing-1-groupBy=~&listing-1-filter=Name~startswith~'Bu'

When the Telerik grid is generated, the grid knows what to do with these query parameters and is able to build an IQueryable with it.

I want to generate this IQueryable without generating the grid, so the user can apply some sorting and filtering and I can perform a bulk action on the exact same data that the user has filtered/sorted in the grid. (I'm not interested in the paging part here).

I hoop I made myself clear now...

Kind regards,

   Edwin.

[Petur Subev]

Hello Edwin,

I am afraid that this is not possible because the collection is actually filtered/paged after the Action method is executed - the GridAction attributes handled this via the OnActionExecuted overriding. 


Kind regards,
Petur Subev
the Telerik team