To not include expression fields in select when they are hidden in a variant.

Hi Freddy,

We’re actually aready working on this feature to only select visible columns, and expect it to be released in a couple of months.

Hi Jasper,

Would this also work for columns that are hidden in the grid and only shown in the form?

Hi Andre,

Due to circumstances, this project has come to a standstill for some time. However, we plan on working on this again as part of the separate API endpoints for variants.

Initially, the GUI fetches all fields that may be visible, but in the future we want to make further optimizations by looking at the visible columns per component.

Hi @Jasper  what is the status of this idea/improvement?

Hi Freddy,

We continued the implementation of this feature with the Variant API project as part of the 2022.2 release. The first step, to make each variant have its own API endpoint, will be available with the release in June.

The next step is to allow the GUI to only select the available columns per variant, by providing the required metadata to do so. This is expected to be available with the 2022.3 release later this year.

(The challenge here is that we need to calculate the effective column permissions and dependencies for all columns in all variants. We'll have to do this upfront and persist this information to guarantee performance, so it has quite an impact.)

This idea has been delivered with the Variant effective rights feature of the 2023.2 release.