Hi everyone, we’re scratching our heads a bit on integrating a custom JQuery grid into our VF pages, and are looking or some help.

We are trying to integrate a jQuery grid in a Visualforce page, but  also want to be able to place on it, the ‘view’ drop down, so users can access the custom list views that they have built, and have the data and columns returned and bound to the grid. Were doing it this way (btw) so we can leverage some of the more powerful sorting features of the jQuery grid.

Thus far we have been having an assortment of issues.

We have been able to build a custom drop down and make a request for a list of available views on an object, to populate it, but we can’t find a way to draw on the SOQL query that is behind each view, so we are unable to run anything to produce the array of data that can be bound to the grid.

We’ve been pointed towards integrating the standard list controller as outlined here (http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_sosc_list_views.htm) , but this outputs html and can’t be bound to the grid without being heavily re-engineered to get into a bind-able form, so this doesn’t seem like a practical or efficient solution.

What would really solve the problem for us, is to be able to do either of the following

A)     Find a way to request the SOQL statement that is executed by the view, so we can run it when the corresponding view is selected in our custom list controller drop down. This will allow us to return an array of data that we can program against to bind to the grid

Or

B)      Get the standard list controller to return a format that we can program against efficiently.

Does anyone out there have any experience of these issues.

I welcome your responses