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
BedrockMission!

Learn More

View all

Sign in to view all badges

User specific drop list

Avatar

Avatar
Validate 1
Level 1
nareshp9284939
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
nareshp9284939
Level 1

Likes

0 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
nareshp9284939
Level 1

05-07-2017

Hi All,

I have a dynamic PDF form. I can launch it from workspace, I can fill the data and submit for approval. All works good. In the form I have couple of drop list fields. Can I restrict values in the drop list based on the user id? The drop list values will come from Oracle database, overall values for this field are more than 1000 but a particular user can see limited (lets say 3, 6 or 14) values based on the security restrictions. I know how JDBC connection and SQL statements work in workbench but I don't know how it works in designer. Any help will be greatly appreciated.

Thanks

Naresh

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Level 2
user2062153
Level 2

Likes

2 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 1
Affirm 1
View profile

Avatar
Give Back 5
Level 2
user2062153
Level 2

Likes

2 likes

Total Posts

18 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 1
Affirm 1
View profile
user2062153
Level 2

13-07-2017

Hi Naresh,

For Dynamically populating items please use article Dynamically populate a drop-down list or list box​  for connecting to data sources. Not sure about JDBC but designer provide the connection to OLE database, web service etc. Please check Create a data connection to an OLE database article.

Answers (0)