Hi All,
I'm trying to fetch data form one of the column of database to the drop down component on UI.
Column has redundant data e.g india,india,india, in 100 rows let say.
I'm using index(local!variable,"columnname" {}) function, but it is throwing error.. Duplicate items are not allowed in the choice Values array.
Please guide on this ..
TIA,
Nalini
Discussion posts and replies are publicly visible
what is i have record type not entity
My requirement is to fetch unique values from DB column with the help of record type to populate in dropdown values. I have used this code
a!localVariables( local!projectManager: a!queryRecordType( recordType:XYZ Record type, fields: a!aggregationFields( groupings: { a!grouping( field: XYZ Record type.field, alias: "projectManager" ) } ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5000) ), a!recordFilterList( name: "projectManager", options: a!forEach( items: local!projectManager.data, expression: a!recordFilterListOption( id: fv!index, name: fv!item.projectManager, filter: a!queryFilter( field: XYZ Record type.field, operator: "=", value: fv!item.projectManager ) ) ) ),)
But this returns a Facet type object which has many fields and i want to access some specific field which contains unique values
Niharika said:My requirement is to fetch unique values from DB column with the help of record type
FWIW, you have posted this follow-up question to an extremely old thread (from before RecordType data was even usable for your use case). It'd usually be better to either find a newer thread on the subject or start your own.