Filtering the data of a DropdownGrid in the fiter does not apply

[SvenG]

Hello all,
we have a grid with some fiter fields. One of the filter field is defined as a Dropdown-Grid.
Now we want to show only some data in the dropdown-Grid. The filtering of the data is done by an additional filter with an app variable.

Grid with the filter:
image.png


Widgets which is used as Dropdown grid:
Name: Werkstattuebersicht_Plaetze_Liste_Selektion
FieldNames for filter: FILIALE + STATUSBELEGUNG
?


Variable which is used for filtering the dropdown grid:
image.png

?
?set the app variabl as additional Filter:
image.png?

?
Data in app variable "verfuegbarePlaetze":
image.png?



executed sql statement when opening the dropdown grid:
image.png?

The Grid is not filtered with an WHERE -clause.


We have used this method to filter a dropdown grid alread within a "Form". In this case it works as expected and the data in dropdown grid is filtered with a sql where clause.

?


Valence Version: 6.3.20260421.0


Thank you for your help

[SvenG]

Is there any news regarding this problem?

[Johnny Major]

This will be fixed in the next update