Ok. I want to show an overview of huge storage, which location is occupied with a product which is empty. As 4000 objects are too much for one view (can’t work) I am using the Ignition table to show it. Each cell in the table is a location in the storage. Close to this table I am showing devices as moving and how they picking up or lowering data in storage. And observer of the screen expects that location in the table, that represents storage also changes. Data about storage are in SQL table, but it’s a huge amount of data and data are not changing fast at all. I don’t want to read all that data in every 1, 2 s, but I want to change, update location in table when device lowering product within 3s. What I am doing, on start-up of the Ignition I am reading that huge amount of data after data I am changing in data set only data that are changed (tracking devices and actions). As each location and product have some set of the property I made a function for filtering data in the storage according to selecting properties (filtering: only locations cells that satisfy condition will be with color). I can do filtering by SQL Query, but as I want to show reliable data I will need to send the query on every 3 s, but why do that when I already have dataSet in the ignition that is updating on the event of the change. I want to filter mu local dataSet.
Main challenge (problem) is because I have SQL data for something that is not proper to be from SQL (for this data I need events) and because I am showing it in table, but is not proper for table
Thank you very much for help!