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

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.

Thanks will try this..

Thanks will try it!!