Field with type number no longer searchable

[nightstorm2]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

GLPI Version

10.0.17

Plugin version

1.21.17

Bug description

After the update to version 1.21.17, fields with the type number are displayed as comma numbers and are no longer searchable.

Relevant log output

No response

Page URL

No response

Steps To reproduce

1. create a field with the type number
2. enter an integer
3. search for the number

Your GLPI setup information

No response

Anything else?

No response

[stonebuzz]

Hi @nightstorm2

I don't reproduce with the latest version of plguin

Can you clear GLPI's cache and run another test?

php bin/console cache:clear

Can you also post a screenshot of the related fields?

Best regards

[nightstorm2]

Hi @stonebuzz

Thank you for your reply.
I have cleared the cache and restarted the server. Unfortunately, this has not led to any improvement.
The screenshots of the created issue are therefore still valid. I see that you have dots as separators and I have commas. Could this be the cause of the error?

Best regards

[stonebuzz]

Hi @nightstorm2

Can you show me values in database?

[nightstorm2]

Hello @stonebuzz

I'm not familiar with database queries, but if you can tell me the command for in the Linux environment, then I can run it and report the result.

[stonebuzz]

Hi @nightstorm2

SELECT * FROM glpi_plugins_fields_fields;
SELECT * FROM glpi_plugins_fields_fcontainers;

Best regards

[nightstorm2]

Hi @stonebuzz

MariaDB [glpi]> SELECT * FROM glpi_plugin_fields_fields;
+----+------------------------------------------+----------------------------------------+----------+-----------------------------+---------+---------------+-----------+-------------+-----------+----------+----------------+
| id | name                                     | label                                  | type     | plugin_fields_containers_id | ranking | default_value | is_active | is_readonly | mandatory | multiple | allowed_values |
+----+------------------------------------------+----------------------------------------+----------+-----------------------------+---------+---------------+-----------+-------------+-----------+----------+----------------+
|  1 | farbefield                               | Farbe                                  | dropdown |                           1 |       1 | 0             |         1 |           0 |         1 |        0 | NULL           |
|  6 | nrfield                                  | Nr                                     | number   |                           1 |       2 |               |         1 |           0 |         0 |        0 | NULL           |
| 10 | dienstantrittfield                       | Dienstantritt                          | date     |                           7 |       1 |               |         1 |           0 |         0 |        0 | NULL           |
| 11 | dienstaustrittfield                      | Dienstaustritt                         | date     |                           7 |       2 |               |         1 |           0 |         0 |        0 | NULL           |
| 12 | bitlockerwiederherstellungsschlsselfield | Bitlocker Wiederherstellungsschlüssel  | text     |                           6 |       3 |               |         1 |           0 |         0 |        0 | NULL           |
| 13 | windowsupdateseingerichtetfield          | Windows Updates eingerichtet           | yesno    |                           6 |       2 | Yes           |         1 |           0 |         0 |        0 | NULL           |
| 15 | automatischerneustarteingerichtetfield   | Automatischer Neustart eingerichtet    | textarea |                           6 |       4 |               |         1 |           0 |         0 |        0 | NULL           |
| 16 | stilleralarmfield                        | Stiller Alarm                          | dropdown |                           6 |       1 | 2             |         1 |           0 |         0 |        0 | NULL           |
| 17 | matrixfourtwostatusfield                 | Matrix42 Status                        | dropdown |                           6 |       5 | 1             |         1 |           0 |         0 |        0 | NULL           |
| 18 | ticketidfield                            | Ticket ID                              | number   |                           8 |       1 |               |         1 |           0 |         0 |        0 | NULL           |
| 24 | computerfield                            | Computer                               | dropdown |                           9 |       1 | NULL          |         1 |           0 |         0 |        0 | NULL           |
| 26 | notebookfield                            | Notebook                               | dropdown |                           9 |       2 | NULL          |         1 |           0 |         0 |        0 | NULL           |
| 27 | toughbookfield                           | Toughbook                              | dropdown |                           9 |       3 | NULL          |         1 |           0 |         0 |        0 | NULL           |
| 28 | kommentarfield                           | Kommentar                              | textarea |                           9 |       4 |               |         1 |           0 |         0 |        0 | NULL           |
| 29 | bestellidfield                           | Bestell ID                             | number   |                           8 |       2 |               |         1 |           0 |         0 |        0 | NULL           |
| 30 | eanfield                                 | EAN                                    | number   |                           1 |       3 |               |         0 |           0 |         0 |        0 | NULL           |
| 31 | barcodefield                             | Barcode                                | text     |                           1 |       4 |               |         1 |           0 |         0 |        0 | NULL           |
+----+------------------------------------------+----------------------------------------+----------+-----------------------------+---------+---------------+-----------+-------------+-----------+----------+----------------+
17 rows in set (0,001 sec

MariaDB [glpi]> SELECT * FROM glpi_plugin_fields_containers;
+----+---------------+----------------+---------------------+------+---------+-------------+--------------+-----------+
| id | name          | label          | itemtypes           | type | subtype | entities_id | is_recursive | is_active |
+----+---------------+----------------+---------------------+------+---------+-------------+--------------+-----------+
|  1 | farbetyp      | KT             | ["CartridgeItem"]   | dom  | NULL    |           0 |            0 |         1 |
|  6 | iukverwaltung | IUK Verwaltung | ["Computer"]        | tab  | NULL    |           0 |            0 |         1 |
|  7 | benutzer      | Benutzer       | ["User"]            | dom  | NULL    |           0 |            0 |         1 |
|  8 | itamt         | IT-Amt         | ["Ticket"]          | tab  | NULL    |           0 |            0 |         1 |
|  9 | gertetausch   | Gerätetausch   | ["Computer","User"] | tab  | NULL    |           0 |            0 |         1 |
+----+---------------+----------------+---------------------+------+---------+-------------+--------------+-----------+
5 rows in set (0,000 sec)

Best regards

[stonebuzz]

Strange
Even if commas are used, I don't reproduce.

[tguichard25]

I have the same problem with version 1.21.19

[stonebuzz]

can you try this -> #926

[stonebuzz]

Hello,

This issue hasn't seen any activity for a while. To keep the tracker clean, we're closing it for now.

Please consider testing again with the latest version of the plugin. If the problem persists, feel free to reopen the issue or open a new one with updated details.

Thanks for your understanding!