Completed

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

Related products:Windows GUIUniversal UI

Forum|Forum|6 years ago
March 23, 2020
8 replies
322 views

+16

Freddy
Thinkwise Local Partner Brasil

We have a table with quite some expression fields, that normally do not give a lot of performance loss because they are usually always shown as a detail of an order.

However, we've created a variant on this table that breaks with this and although I've hidden the majority of the fields, the select that is generated in the end product will still contain all these expression fields that really make things slow. Wouldn't it be a nice idea to not add expression fields to the select of a variant when they are hidden?

I know I can make a seperate view, but I would like to not do that. It would be great if the selects for view/tables (based on variants) could only contain the data-elements that will be shown (non-hidden).

Jasper
Forum|Forum|6 years ago
March 24, 2020

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.

Like

A

+14

Andre te Raa
Captain
Forum|Forum|5 years ago
April 21, 2021

Hi Jasper,

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

Like

Jasper
Forum|Forum|5 years ago
April 28, 2021

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.

Like

+16

Freddy
Author
Thinkwise Local Partner Brasil
Forum|Forum|4 years ago
May 11, 2022

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?

LEF — Lift. Empower. Fulfill. [lef.digital]

Like

Jasper
Forum|Forum|4 years ago
May 13, 2022

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.)