Remote Filtering & Sorting?

[JoeD101]

Is there no way with react-table to remote filter or sort your columns ASC or DESC?
I have search bars at the top of each column (filtering) and you can sort ASC/DESC by that column as well, but when remote pagination is being used, this will only search based on the current result set that is loaded in, not the entire result set which obviously makes sense.

However, this also isn't very useful. I am assuming there could be a way to send the e.target.value from the filter to the server to query that way for the fetchData.
It would be like this (react-bootstrap-table2):
https://react-bootstrap-table.github.io/react-bootstrap-table2/docs/basic-remote.html#remote-pagination
I can't find anything with react-table asked or in docs on this. Thanks.

[JoeD101]

I found a way to implement this. For the react-table side of things, I needed to use the filters and sortBy (arrays of key value pair objects which the key is the column name, and value is your filtering/descending or not value) that you can pass into state: in your createTable() function:

state: { pageIndex, pageSize, filters, sortBy }

From there, when you call your fetchData within the component of react-table with useEffect (just like documentation: https://react-table-v7.tanstack.com/docs/examples/pagination-controlled) you can add filters and sortBy to the dependency array of the useEffect call. It seems I have to have filter and sortBy states outside in the component where the fetchData function is written as well and share with props.

// within component with react-table:
useEffect(() => {
        if((filters.length != 0 || sortBy.length != 0)) {
            props.fetchData({pageSize, pageIndex, filters, sortBy});
        }
}, [filters, sortBy]);
// there is another useEffect for just [pageSize, pageIndex] in my code

Backend will depend on language probably, but in .NET Core/C#, I had to use reflection to match against string key column names passed from filters/sortBy array to DB column names where table data comes from and build my queries with the values.

Just general ideas here, wasn't all that trivial and would be nice if there were some info in the documentation.