Dynamic Workflow Select field

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules
Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
Post Reply
tauhubasah
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: Fri Jan 17, 2020 1:37 am

Dynamic Workflow Select field

Post by tauhubasah »

Hello there,

I've managed to retrieve value using the Select field as shown in "attachment 1.jpg" as it pulls from "okmdb"
I have a db called "okmdbcustom" installed in the same server with "okmdb" as shown in "attachment 2.jpg".
How do I retrieve the value from a table in "okmdbcustom" into the workflow form select field as "attachment 1.jpg" or is there any other for me to make this happen?

I am using openkm CE ver 6.3.10 (build: 6ac9576)

Thanks
Attachments
attachment 1.JPG
attachment 2.jpg
attachment 2.jpg (10.25 KiB) Viewed 181 times

jllort
Moderator
Moderator
Posts: 11151
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Dynamic Workflow Select field

Post by jllort »

Option values based in SQL script are only allowed in professional edition. In community edition currently the nearest aproach is https://docs.openkm.com/kcenter/view/ok ... adatatable

We still have not included this feature in the community edition. If you consider interesting the feature, please add an issue an as soon as possible we will add ( https://github.com/openkm/document-mana ... tem/issues ).

Post Reply