Currently, I have a table lookup data reference that pulls quality sampling data with a characteristic that matches the attributes from the respective table for each production material. It works, but it also includes data that I don't want to visualize in PI Vision.
I'd like to filter the all the data contained in "U400 Baghopper Composites" table out using the inspection point from "U400 Baghopper Composites", but I cannot figure out how to write the query. I tried this, but encountered syntax errors:
Apologies if this is a silly question. I don't understand SQL well. Is it even possible to filter the contents of a different table from a table lookup data reference? Thanks all.
