We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Rebind a saved ejGrid query before datarequest

Thread ID:

Created:

Updated:

Platform:

Replies:

124264 May 27,2016 10:00 AM UTC May 30,2016 03:55 PM UTC JavaScript 2
loading
Tags: ejGrid
GW Consultancy
Asked On May 27, 2016 10:00 AM UTC

We have a solution where the user would like to save each grid filter and sort and reuse the saved settings when they reload the page, or visit from a different computer (which rules out enablePersistance)

Currently, I am serialising the query and saving it via a web service call. This is working correctly. However when I attempt re bind the retrieved query to the grid model using the following code an error is thrown:

actionBegin: function (args) {
    args.model.query = getGridQuery(args.model.query);   // the original query object is passed in to be saved and returned on error
}

Error: DataManager - executeQuery() : A query is required to execute
    at u (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:81803)
    at Object.t.DataManager.executeQuery (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:26102)
    at Object.t.widget._initDataSource (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:1997222)
    at Object.t.widget._checkDataBinding (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:1987116)
    at Object.t.widget._init (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:1983485)
    at Object.<anonymous> (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:16506)
    at n.fn.(anonymous function) [as ejGrid] (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:17592)
    at Object.createDetailView (http://localhost:51142/Scripts/prototypes/enquiry.routing.js:267:17)
    at Object.t.widgetBase._trigger (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:10945)
    at Object.t.gridFeatures.common.expandCollapse (http://localhost:51142/Scripts/ej/13.3.0.7/ej.web.all.min.js:10:1712386)

When inspecting the query object in debug mode it looks correct and is set correctly, but the grid always throws the error. 

Does anyone have an example which shows the best way to save and reuse a query?

Thanks in advance.



Prasanna Kumar Viswanathan [Syncfusion]
Replied On May 30, 2016 01:55 PM UTC

Hi Grant, 

Thanks for using Syncfusion products. 
 
We created a sample and in this sample we used two buttons and a dropDownlist. One button is to store the state and another one is to retrieve the stored state.  
 
When we click the “Save State” button, using AJAX post will send the filterSettings and SortSettings property to server side and that will be stored into SQL data base.  
  
When we click on “Previous State” button, get the filterSettings and sortSettings Grid model from SQL data base and send it to client side using AJAX, then will update the Grid model using model values got from server-side. 
 
If the above sample does not meet your requirement or if you still want to restore Grid state using Grid Query property, then please provide us the following details. 
 
1.       In the actionBegin event you used getGridQuery method to rebind the query. So, we need the code example of an getGridQuery method. 
 
2.       Provide code example of an grid and server-side code example of how you return Query data. 
 
3.       Reproduce the issue in the attached sample. 
 
Regards, 
Prasanna Kumar N.S.V 
 


Prasanna Kumar Viswanathan [Syncfusion]
Replied On May 30, 2016 03:55 PM UTC

Hi Grant,  
 
Please ignore the previous update. 
  
We created a sample and in this sample we used two buttons and a dropDownlist. One button is to store the state and another one is to retrieve the stored state.   
  
When we click the “Save State” button, using AJAX post will send the filterSettings and SortSettings property to server side and that will be stored into SQL data base.   
   
When we click on “Previous State” button, get the filterSettings and sortSettings Grid model from SQL data base and send it to client side using AJAX, then will update the Grid model using model values got from server-side.  
  
If the above sample does not meet your requirement or if you still want to restore Grid state using Grid Query property, then please provide us the following details.  
  
1.    In the actionBegin event you used getGridQuery method to rebind the query. So, we need the code example of an getGridQuery method.  
  
2.    Provide code example of an grid and server-side code example of how you return Query data.  
  
3.   Reproduce the issue in the attached sample.  
\ 
 
Regards,  
Prasanna Kumar N.S.V  


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;