How to get database column values in a field dropdown in a interface.

shubhamy0001 over 2 years ago

Hi Everyone,

Can anyone please explain me how can I get values from database in a dropdown field in a grid layout.

Thank You

Discussion posts and replies are publicly visible

Top Replies

Harshit Bumb (Appyzie) over 2 years ago in reply to shubhamy0001 +1
Certified Lead Developer

Hi there, The above solution provided looks perfect to me. However, if you're still not able to populate the values, can you please copy-paste your code snippet below so I can understand the problem…

0 Malathi
Certified Lead Developer
over 2 years ago

Hi,

Call a query entity to pull the required data from the database table and load it to the local variable. Then, use that same local variable to the grid dropdown column. Just make sure that choice values of the dropdown doesn't hold duplicate values(use table unique column)

Query Recipes: docs.appian.com/.../Query_Recipes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shubhamy0001 over 2 years ago in reply to Malathi

Thank you for your reply, I used the same logic but the dropdown field is unable to pull down to display the dropdown values.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Harshit Bumb (Appyzie)
Certified Lead Developer
over 2 years ago in reply to shubhamy0001

Hi there,

The above solution provided looks perfect to me. However, if you're still not able to populate the values, can you please copy-paste your code snippet below so I can understand the problem more on your level?
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel