Dropdown form data from database | Community
Skip to main content
September 25, 2017
Solved

Dropdown form data from database

  • September 25, 2017
  • 2 replies
  • 2026 views

Hi,

In a form. Is there any way to link data from the database with a dropdown list ?

It would be like an enum but with all data schema from the database.

Here in my workflow schema :

<element label="Countries" name="listCountry" target="nms:country" type="link" />

And then in workflow form :

<input xpath="listCountry" />

In theses exemples it works as editing text. I don't want it to to be editable, I would like to change the country only by clicking just as enumeration.

Thank you in advance for help.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jean-Serge_Biro

Hello Sakadam,

You should use input element with type="linkList" attribute, for sophisticated list display (it allows multiple columns, buttons to show or hide, etc).
Otherwise, for simple enumeration list, you can use type="list".

Details of all attributes are given in JSAPI documentation.

Regards.
J-Serge

2 replies

Jean-Serge_Biro
Jean-Serge_BiroAccepted solution
Level 10
September 25, 2017

Hello Sakadam,

You should use input element with type="linkList" attribute, for sophisticated list display (it allows multiple columns, buttons to show or hide, etc).
Otherwise, for simple enumeration list, you can use type="list".

Details of all attributes are given in JSAPI documentation.

Regards.
J-Serge

September 26, 2017

Thank you for your reply.

My bad, I didn't know that we could get theses informations in the JSAPI doc.

LinkList is too much sophisticated for the purpose of my form.

I did the trick with :

<input xpath="listCountry" noZoom="true" noTransaction="true" noEdition="true" choiceButton="true" computeStringExpr="[@isoA2]"/>

Thank you again, it really helped me.