pluginsGLPI
Dropdownitem source = SQL query
Hello!
Is your feature request related to a problem? Please describe. It is necessary to display a list consisting of elements stored in a database that is not related to GLPI
Describe the solution you'd like An element (drop-down list, for example), where you can specify the database address and sql query (or just sql query). Something like this https://wiki.processmaker.com/3.2/DynaForm_Field_Properties#SQL
Thank you for your time!
@btry Good afternoon! Are there any plans for such a feature? Drop-down list by SQL query from the current database (arbitrary table) or from another SQL database.
Hi
There is no plan to allow to design a drop-down from a SQL query.
In Formcreator 2.14 a new feature will allow you to set criterias to filter items, using the search engine you find anywhere in glpi. This should solve your problem.
@btry Hi Will it be possible to search by objects created, for example, in a plugin https://github.com/pluginsGLPI/genericobject ? Because there is a need to make a catalog with new objects and make a drop-down list with it in the form?
Hi
Generic Objects is already supported. The filter by criterias is available for any object. Here is a quick screenshot of the search criterias editor. It is identical to the search engine found everywhere in GLPI.