Populate PickerfieldCustom from a CDT

Question

I'm fairly new to Appian so any help is greatly appreciated. 
 I found this example on how to populate a PickerfieldCustom with static data but I'm wanting to use a table from a database via a CDT. 
 The table has 2 columns (id, descr). I already created a CDT for it and works fine. 
 The PickerfieldCustom needs to display the descr field and the value needs to be the id. 
 Are there any good examples for this? If not can someone give me some guidance?

Peter Lewis · Accepted Answer

The easiest way to set this up with data from a database is to create a query that returns all of the data from your CDT. Then, just replace the "labels" list with your description and the "abbreviations" list with your id. Keep in mind you might need to also change some of the data types for your supporting rule (for instance, the "identifiers" rule input should be an integer instead of text). If you do this correctly, your final expression could look something like this: 
 a!localVariables(
 local!selection,
 local!data: rule!GetAllReferenceData(),
 a!pickerFieldCustom(
 label: "Label",
 instructions: "Value saved: " & local!selection,
 maxSelections: 1,
 suggestFunction: rule!ucArrayPickerFilter(
 filter:_ , 
 labels: local!data.desc, 
 identifiers: local!data.id
 ),
 selectedLabels: a!forEach(
 items: local!selection,
 expression: index(local!data.desc, wherecontains(fv!item, local!data.id))
 ),
 value: local!selection,
 saveInto: local!selection
 )
)

Shikha · Answer

Hey , please add .data at the end of your query entity (line 25) ADA_lookupadvisors so that it gives you data in dictionary type format ( excluding startIndex, totalcount , batchsize etc) . Alternatively , In the interface, you can define the local variable like this : local!data : rule! ADA_lookupadvisors().data. You can try any of the above two methods. That should work.

sandeepd · Answer

htmoore , 
 
 Below code may help you. 
 
 a!pickerFieldCustom( label: "Select Data" placeholder: "Type Min 3 characters", labelPosition: "JUSTIFIED", required: true(), maxselections: 1, suggestFunction: ##Write Expression rule to get ID & Desc Data from Data base# Use index function to get data index. Also, in Query entity Filter use operator: "includes" ## selectedLabels: index( rule!getDetailsByID( Id_int: local!selectedId ), "Desc", null ), #Here get details from table by passing Id # value: local!selectedId, saveInto: { local!selectedId, ) 
 
 Thanks, Sandeep

Populate PickerfieldCustom from a CDT

Top Replies