Can't find computers having 2 softwares

[FrenchHope]

Code of Conduct

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

Is there an existing issue for this?

• [x] I have searched the existing issues

Version

GLPI 10.0.14

Bug description

I can't find computers having 2 software like Firefox AND Chrome with global rules on software name. There is no result. It seems to work for a query like Firefox OR Chrome.

Relevant log output

No response

Page URL

No response

Steps To reproduce

Go to computers, create 2 global rules criteria search on software : name One with software 1 The other with software 2 using AND operator

Your GLPI setup information

No response

Anything else?

No response

[keguira]

Did some tests.

UC1 : your use-case

• 'Software' 'Characteristics - Name' 'contains' 'firefox'
• AND 'Software' 'Characteristics - Name' 'contains' 'chrome'

Returns : nothing

UC2 : your second use-case with OR

• 'Software' 'Characteristics - Name' 'contains' 'firefox'
• OR 'Software' 'Characteristics - Name' 'contains' 'chrome'

Returns : computers with one or the other or both

UC3 : trying to figure the AND behavior

• 'Software' 'Characteristics - Name' 'contains' 'firefox'
• AND 'Software' 'Characteristics - Name' 'contains' 'ESR'

Returns : computers with any variation of firefox ESR

The search query aggregate the search query for a same entry. Also confirmed by another test where I use an other attribute of the software (editor or version).

UC4 : trying to confirm assertion made in UC3 with the AND NOT behavior

• 'Software' 'Characteristics - Name' 'contains' 'firefox'
• AND NOT 'Software' 'Characteristics - Name' 'contains' 'chrome'

Returns : computers with firefox. Does not exclude computers having chrome

UC5 : trying to use the grouping system to force to look for multiple software entries on same computer

• Group
  • 'Software' 'Characteristics - Name' 'contains' 'firefox'
• AND Group
  • 'Software' 'Characteristics - Name' 'contains' 'chrome'

Returns : nothing.

[FrenchHope]

Thanks. I tried grouping system too, without success. Even with SQL I had to use an IN operator. AND didn't work.

[github-actions[bot]]

There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.

If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue. If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.