Dropdown form data from database

Avatar

Avatar
Validate 1
Level 1
sakadam88098052
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
sakadam88098052
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
sakadam88098052
Level 1

25-09-2017

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

25-09-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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
sakadam88098052
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
sakadam88098052
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
sakadam88098052
Level 1

26-09-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.