Integrating the views list controller with a custom JS / jQuery grid
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, and thought we'd post out to the wider comm to see if anyone could help.
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.
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?
Feel free to hit me with your phone number (or skype) in an e-mail and I'll chat w/ you about it. I think you can get what you want, but It's easier to discuss. Best, Steve.
Feel free to hit me with your phone number (or skype) in an e-mail and I'll chat w/ you about it. I think you can get what you want, but It's easier to discuss. Best, Steve.