fetch Data from a db column to drop down component

Hi Nalini ,

For choice values it won't allow duplicate values for ignoring that
can you try the bellow

load(

local!data:index(local!variable,"columnname" {})
-------
-------
------..etc,
a!dropdownField(

label: " ",
placeholderLabel: "--select --",
choiceLabels: union(
local!data,
local!data
),
choiceValues: union(
local!data,
local!data
),
value: {},
saveInto:{}
)

may it helps you.....

Thanks

The values must be unique. As mentioned in the response, union will remove duplicates. However, the better approach may be to create a lookup table of values. That table should have and ID (pk) and text. The ID can be a number (sequence) for normalization or the text value.
If you are querying a table that just continues to grow and have more and more records, the union will start to slow and may degrade performance.

The values must be unique. As mentioned in the response, union will remove duplicates. However, the better approach may be to create a lookup table of values. That table should have and ID (pk) and text. The ID can be a number (sequence) for normalization or the text value.
If you are querying a table that just continues to grow and have more and more records, the union will start to slow and may degrade performance.

Thanks will try it!!