I'm trying to find a solution for the following problems: We have multiple machines producing different products. Each product produces different measurements. I'm getting plenty of requests to display different measurements.
We have enough meta data to know which measurement is stored in which table, however they are way too large to store all measurements in memory.
I'm thinking about a solution where the user is able to select the assembly line, date and measurement and based on that I want to use direct discovery to load data.
F.E So with the user selection of Product A Measurement X I'd know that this would be stored in table 10,
while Product B Measurement K would be stored in table 12.
Is it possible to pass the selected table to direct discovery to use as a preselection for the query?