Skip to main content
S
shubhamy0001
September 12, 2021
Question

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

  • September 12, 2021
  • 3 replies
  • 0 views

Hi Everyone,

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

Thank You

    3 replies

    malathik
    malathik
    September 13, 2021
    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
    S
    shubhamy0001Author
    September 13, 2021

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

    harshitb6843
    harshitb6843
    September 13, 2021

    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?

      Terms & ConditionsAccessibility statement