• Dynamic Workflow Select field

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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.
 #50122  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 1.JPG (15.81 KiB) Viewed 1095 times
attachment 2.jpg
attachment 2.jpg (10.25 KiB) Viewed 1095 times
 #50144  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 ).

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.