Filtering data in a Tanstack (Mantine) React Table
I want to filter the data on two fields which are not in one of the columns, the fields are called isActive and isArchived. When the isActive button is pressed in the table header I want the data to only show the active employees otherwise all employees should be shown, if the isArchived button is pressed I want the data to only show the archived employees otherwise I only want to show the unarchived employees. Is it best to use the select option inside the useQuery or are there better solutions?
