The pivot table component was designed quite some time ago with a specific focus: allowing users to easily compare the status of parameters across multiple elements. Once it achieved its initial goals, development on this component slowed down as the broader framework evolved. During that time, new features like the Generic Query Interface (GQI) and the trigger component were introduced, which shifted the focus towards more flexible and dynamic solutions.

To address your questions:

1. Why doesn't the pivot table update automatically?

The pivot table was originally intended to capture and display snapshots of parameter statuses, rather than providing real-time updates. It was not designed with real-time data refresh in mind, which is why it doesn't update automatically.

2. Is this a bug?

This behavior is not a bug but rather a limitation or missing feature. The pivot table was never intended to support real-time updates. However, similar functionality can be achieved using a regular table with GQI, which does offer partial support for real-time updates.

3. Why can't you assign a trigger to the pivot table?

The trigger component was introduced after the pivot table and was primarily designed to re-trigger queries, not specific components. While theoretically possible, integrating trigger functionality into the pivot table was never prioritized due to the shift towards more dynamic and versatile components like those built with GQI.

While it might seem like these are just technical limitations, the main reason the pivot table doesn't support these features is due to a shift in the product's vision and priorities. If GQI had been available earlier, the pivot table might not have been developed at all.

My question for you is: Are there specific features or aspects of the pivot table that are critical to your use case and that you find difficult to replicate with GQI? Our goal is to ensure you have the functionality you need, and we'd prefer to enhance GQI to meet those needs rather than extending the pivot table.

It's possible, but could take some effort to achieve a pivot table through GQI where the indices are the columns. It would require for you to create your own custom ad hoc data source.

What's easy to accomplish though is to have the indices as rows, grouped by element. Here's a quick example of a pivot-like table created through GQI and the regular table visualization:

As you can see, using the regular table comes with a lot of benefits out of the box (filtering, grouping, sorting on multiple columns, resizing + moving colums, copying cells or rows, multi row selection, ...)

You can even customize how every cell should appear. Instead of OK you could for example have a checkmark:

Would this suffice for your use case?

Ideally we would want something that looks like this, yet updates in real time or every X amount of seconds.

I cannot replicate this within GQI but I am no expert, do you think something like this is possible within the GQI?

Second Edit: