Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Dropdown form data from database

sakadam88098052
Level 1
Level 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.

1 Accepted Solution
Jean-Serge_Biro
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

2 Replies
Jean-Serge_Biro
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

sakadam88098052
Level 1
Level 1

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.