Server side filtering

[Masoud Moghaddari]

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]

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, 

https://www.syncfusion.com/kb/10280/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]

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]

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. 

Sample: https://ej2.syncfusion.com/vue/demos/#/material/query-builder/grid.html 

Regards, 

Seeni Sakthi Kumar S

[Masoud Moghaddari]

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]

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.  

 

https://ej2.syncfusion.com/vue/documentation/grid/cell/#customize-cell-styles 

 

Regards,  

Seeni Sakthi Kumar S 

[Masoud Moghaddari]

Hi,

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

Best Regards

Masoud

[Masoud Moghaddari]

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]

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. 

Documentation: https://ej2.syncfusion.com/vue/documentation/grid/paging/#how-to-render-pager-at-the-top-of-the-grid 

Regards, 

Thavasianand S. 

[Masoud Moghaddari]

Hi,

Thank you so much!
My issue has been resolved.

Best regards

Masoud

[Seeni Sakthi Kumar Seeni Raj]

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.