Dropdown form data from database

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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.