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