I want to use webdatarocks free version to display server response based on selected row/columns is that possible to let the server do the analyst
Sorry for the delayed response.
To display only selected rows/columns from your data source you can use a server-side script. This allows you to write a query to your database which returns only required data. Then convert these data to CSV or JSON format and return to the component.
Does it help?