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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Server side filtering

Thread ID:

Created:

Updated:

Platform:

Replies:

147664 Sep 19,2019 06:46 AM UTC Oct 14,2019 12:30 PM UTC Vue 10
loading
Tags: Data Grid
Masoud Moghaddari
Asked On September 19, 2019 06:46 AM UTC

Hi,
I'm using Vue data grid with PHP for backened. I would like to perform server side filtering but the filter data is sent to server in Json rules format.
How can I convert Json rules to sql string? Should I do it serverside?
Thanks.

Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On September 20, 2019 10:21 AM UTC

Hi Customer, 

Thanks for contacting Syncfusion support. 

From your query, we suspect that you want to handle EJ2-Grid actions in back-end (PHP framework). But unfortunately, our EJ2-DataManager does not have support in PHP framework. Also, we would like to inform that we will generate and pass the queryString (based on the Grid actions) from the Grid. So, you need to handle all the Grid actions by yourself based on this queryString in your backend. Please refer the below kb to know more details about how to use EJ2-controls in PHP, 

 
If we misunderstood your query, please share more details about your requirement. This will help us to provide a better suggestion for your requirement as early as possible. 

Regards, 
Seeni Sakthi Kumar S 


Masoud Moghaddari
Replied On September 21, 2019 10:27 AM UTC

Hello,
thanks for your fast reply.

I will create my desired query on the server myself.
Just one more question,
I'm using Query Builder component with Data Grid and DataManager to fill Data Grid server side WebAPI.
Now, I want to send the query from Query Builder alongside the current state of Data Grid to server together so that I'd be able to update the table.
I mean now that I'm filling the data with server side method, every time I do operations like sorting and pagination, is GET request is sent to server. How can I add Query Builder out put to that?

Best Regards
Masoud Moghaddari


Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On September 23, 2019 11:09 AM UTC

Hi Masoud Moghaddar, 

We could see you would like to integrate the Data Grid with the QueryBuilder. We have already discussed about your requirement in the following showcase demo. 


Regards, 
Seeni Sakthi Kumar S

Masoud Moghaddari
Replied On September 23, 2019 12:52 PM UTC

Hi,

Firstly, I couldn't find the server side implementation in the link you sent.
Secondly, please kindly help me with another issue. I have to change background color of some cells in "mounted" event. I have the row index and column name. How can I change the cell background color using these information?
for example, I want something like this: 
cell[0][id].addClass('red');
which '0' is my row number and 'id' is my column name.
Is there any similar approach available?

Best Regards
Masoud Moghaddari

Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On September 24, 2019 11:57 AM UTC

Hi Masoud,  
 
Query #1: Server-end implementation 
 
As we discussed earlier, we cannot handle the PHP server implementation with the dataManager. Would you like to prefer the server-end implementation with the Query Builder component? 
 
Query #2: Customize Grid cells 
 
By default, Grid provides an option to customize cell using its own event queryCellInfo. Refer to the following Help Document.  
 
 
Regards,  
Seeni Sakthi Kumar S 


Masoud Moghaddari
Replied On September 24, 2019 12:10 PM UTC

Hi,

#1 Yes, How can I send QueryBuilder's data to server?
#2 thanks

Best Regards
Masoud

Masoud Moghaddari
Replied On September 26, 2019 09:25 AM UTC

Hi,

I've solved my problem. I've sent the query from Query Builder component to server with an Axios call and the update my table.
Now, I have another problem. I want to place Page Sizes section on the top Data Grid.
How can I achieve this?

Thank you for your efforts!
Masoud Moghaddari

Thavasianand Sankaranarayanan [Syncfusion]
Replied On September 26, 2019 12:51 PM UTC

Hi Masoud, 
 
Based on your update we found that you have resolved your previous query and We could see that you would like to render pager at top of the Grid. we have already discussed about your requirement in our documentation. Please find the below documentation link for more information. 


Regards, 
Thavasianand S. 


Masoud Moghaddari
Replied On October 12, 2019 12:02 PM UTC

Hi,

Thank you so much!
My issue has been resolved.

Best regards
Masoud

Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On October 14, 2019 12:30 PM UTC

Hi Masoud,  
  
Thanks for the update.
 
We are gald to hear that your requirement has been resolve and you are good to go.

Regards,  
Seeni Sakthi Kumar S. 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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

Live Chat Icon For mobile
Live Chat Icon