I am developing an app that is using displaying a priority list to work orders that are being stored in a separate table. The priority value and additional specific information in stored in a separate table that is tied with a linked record to the work order.
This all functions smoothly in the interactive table as I am able to display the desired fields from the priority table combined with the linked fields containing work order information in a singular table.
The issue that comes up is that I would like to include filters to the interactive table. Currently the filter options are only for the fields of the data source table and there is no ability to filter on field of a linked table.
The ability to filter and sort by these linked fields would improve the current functionality of displaying linked records in tables by having greater control over data display/manipulation while reducing the need to store redundant duplicate data across tables.
