Autocompletion does not work

[worldwidehigh]

Hello, for me the function of automatic completion does not work. My GLPI version is 9.4. Browser is Chrome. Firefox there is the same problem. Do any settings need to be set? Thanks for your help, Bill

[ericferon]

Which autocompletion do you talk about ? The one in the main form or the one in a GLPI asset of the drawing pane ? The first one is standard GLPI : if it works for other screens, it will work for this plugin too. The 2nd one is specific to this plugin and linked to the data existing in GLPI database for the class of items (computers, dataflows, databases, ...). The corresponding plugins must be installed, activated and data must be entered. Only the symbols of the "GLPI Assets" tab are linked to GLPI data. Best regards,

[worldwidehigh]

I'm talking about the autocompletion of the plugin. Here's an example + Browser Console. The function seems to work but it does not pop up. It works in GLPI. I have 4 assets named "Test". I have tested this with several browsers.

[slopez31]

Hi ! Same problem for me. Autocompletion only works for Location.

[ericferon]

Sorry for the long delay : I was very busy these last weeks. Do you have error messages in the files/_log/sql-errors.log ? Have your assets a type and a status ? F.i for a computer, the following query is performed : SELECT glpi_computers.id , glpi_computers.name as name,glpi_computertypes.name as type,glpi_states.name as state,glpi_operatingsystems.name as operatingsystem from glpi_computers left join glpi_computers_sas on glpi_computers_sas.id = glpi_computers.id left join glpi_states on glpi_computers_sas.states_id = glpi_states.id left join glpi_computertypes on glpi_computers_sas.computertypes_id = glpi_computertypes.id left join glpi_items_operatingsystems on glpi_items_operatingsystems.items_id = glpi_computers.id left join glpi_operatingsystems on glpi_operatingsystems.id = glpi_items_operatingsystems.operatingsystems_id where (glpi_computers.name like '%your searchstring%' ). If you perform it in an SQL shell, do you get responses ? Best regards,

[lynch4fr]

Hi ! GLPI 9.4.2 | archimap | 2.1.0 For me autocompletion only works for Location and Network device. Thanks

[ericferon]

New release should solve your issue. Can you check ? If not, for which assets do you complain ? Best regards,

[lynch4fr]

Hi, It is good for objects : Location, Network and Computer :- ) Just now Appli have not autocompletion. Thanks

[ericferon]

I released a new version. Can you check with this one ? Applications must have a non-empty "status" field to appear in the autocompletion list. Best regards,

[lynch4fr]

I test it, thanks :-) and ... "Appli" have no autocompletion, sorry but... "System SW" have autocompletion of applications Best regards

[ericferon]

"Appli" autocompletion executes this query : SELECT glpi_plugin_archisw_swcomponents.id , glpi_plugin_archisw_swcomponents.name as name,glpi_plugin_archisw_swcomponents.description as description,glpi_plugin_archisw_swcomponenttypes.name as type,glpi_plugin_archisw_swcomponentstates.name as state, glpi_plugin_archisw_swcomponents.level as level, glpi_plugin_archisw_swcomponents.completename as structure_path, glpi_manufacturers.name as manufacturer, glpi_suppliers.name as supplier, glpi_plugin_archisw_swcomponentdbs.name as db, glpi_plugin_archisw_swcomponenttechnics.name as dev_technology from glpi_plugin_archisw_swcomponents left join glpi_plugin_archisw_swcomponenttypes on glpi_plugin_archisw_swcomponenttypes.id = glpi_plugin_archisw_swcomponents.plugin_archisw_swcomponenttypes_id join glpi_plugin_archisw_swcomponentstates on glpi_plugin_archisw_swcomponents.plugin_archisw_swcomponentstates_id = glpi_plugin_archisw_swcomponentstates.id left join glpi_manufacturers on glpi_plugin_archisw_swcomponents.manufacturers_id = glpi_manufacturers.id left join glpi_suppliers on glpi_plugin_archisw_swcomponents.suppliers_id = glpi_suppliers.id left join glpi_plugin_archisw_swcomponentdbs on glpi_plugin_archisw_swcomponentdbs.id = glpi_plugin_archisw_swcomponents.plugin_archisw_swcomponentdbs_id left join glpi_plugin_archisw_swcomponenttechnics on glpi_plugin_archisw_swcomponenttechnics.id = glpi_plugin_archisw_swcomponents.plugin_archisw_swcomponenttechnics_id where (glpi_plugin_archisw_swcomponents.name like '%sa%' OR glpi_plugin_archisw_swcomponents.description like '%sa%' OR glpi_manufacturers.name like '%sa%' ) order by glpi_plugin_archisw_swcomponents.name "System SW" autocompletion executes this one : SELECT glpi_softwares.id , glpi_softwares.name as name, glpi_softwarecategories.name as category from glpi_softwares left join glpi_softwarecategories on glpi_softwarecategories.id = glpi_softwares.softwarecategories_id where (glpi_softwares.name like '%se%' ) order by glpi_softwares.name. Can you check whether these queries give results in your environment ? Best regards,

[lynch4fr]

Hi ! Sorry for the delay

• The first mysql request = ERROR 1146 (42S02): Table 'glpi.glpi_plugin_archisw_swcomponents' doesn't exist. Exact the plugin table has the form glpi_plugin_archimap_xxx and not glpi_plugin_archisw_xxx

• The second mysql request : OK i have a list of 4471 rows in set ( applications )

Best regards,

[fabriceverkor]

I'm on 10.0.10 wit last version 3.3.2. No autocompletion is working for me. Where an I find the SQL requests executed by auto-completion ? I have more o 2000 assets of different type.

[ericferon]

Hi, You can find it at the end of the screen used to link a graphical object to a GLPI table : https://github.com/ericferon/glpi-archimap/wiki/How-to-link-a-library-element-to-a-GLPI-table K.r,

[fabriceverkor]

OK. Thx. Not sure to understand why but it working fine now. Tx.