Incorrect result of get all items search with searchText

[mykolq]

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

Version

10.0.16

Bug description

I am trying to get result with 'Get all items' method. Steps to reproduce:

• Init session with curl
• Make query with something like that curl 'http://glpitest/apirest.php/Item_OperatingSystem/?searchText[items_id]=853&get_hateoas=false' -H 'Content-Type: application/json' -H "App-Token: app_token_here" -H "Session-Token:d26quhgqp7dmdj3bg3faaa3u9h" -g

In my case result like:

[
    {
        "id": 550,
        "items_id": 2853,
        "itemtype": "Computer",
        "operatingsystems_id": 2,
        "operatingsystemversions_id": 2,
        "operatingsystemservicepacks_id": 0,
        "operatingsystemarchitectures_id": 0,
        "operatingsystemkernelversions_id": 0,
        "license_number": null,
        "licenseid": null,
        "operatingsystemeditions_id": 0,
        "date_mod": "2024-07-31 14:23:59",
        "date_creation": "2024-07-31 14:23:59",
        "is_deleted": 0,
        "is_dynamic": 0,
        "entities_id": 0,
        "is_recursive": 1,
        "install_date": null,
        "company": null,
        "owner": null,
        "hostid": null
    },
    {
        "id": 1487,
        "items_id": 1853,
        "itemtype": "Computer",
        "operatingsystems_id": 6,
        "operatingsystemversions_id": 6,
        "operatingsystemservicepacks_id": 0,
        "operatingsystemarchitectures_id": 0,
        "operatingsystemkernelversions_id": 0,
        "license_number": null,
        "licenseid": null,
        "operatingsystemeditions_id": 0,
        "date_mod": "2024-08-02 12:29:26",
        "date_creation": "2024-08-02 12:29:26",
        "is_deleted": 0,
        "is_dynamic": 0,
        "entities_id": 0,
        "is_recursive": 1,
        "install_date": null,
        "company": null,
        "owner": null,
        "hostid": null
    },
    {
        "id": 1554,
        "items_id": 853,
        "itemtype": "Computer",
        "operatingsystems_id": 2,
        "operatingsystemversions_id": 2,
        "operatingsystemservicepacks_id": 0,
        "operatingsystemarchitectures_id": 0,
        "operatingsystemkernelversions_id": 0,
        "license_number": null,
        "licenseid": null,
        "operatingsystemeditions_id": 0,
        "date_mod": "2024-08-26 17:05:39",
        "date_creation": "2024-08-26 17:05:39",
        "is_deleted": 0,
        "is_dynamic": 0,
        "entities_id": 0,
        "is_recursive": 1,
        "install_date": null,
        "company": null,
        "owner": null,
        "hostid": null
    }
]

But i wanna only 853

Relevant log output

No response

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Информация о системе, установке и конфигурации

GLPI 10.0.16 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:ru_RU

Server

 

Operating system: Linux glpitest 5.15.0-118-generic #​128-Ubuntu SMP Fri Jul 5 09:28:59 UTC 2024 x86_64

PHP 8.1.2-1ubuntu2.18 fpm-fcgi (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bz2, calendar, cgi-fcgi,

ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli,

mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm,

tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)

Setup: max_execution_time="30" memory_limit="256M" post_max_size="8M" safe_mode="" session.save_handler="files"

upload_max_filesize="2M" disable_functions=""

Software: nginx/1.18.0

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36

Server Software: Ubuntu 22.04

Server Version: 10.6.18-MariaDB-0ubuntu0.22.04.1

Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Parameters: glpi@localhost/glpi

Host info: Localhost via UNIX socket

PHP version (8.1.2-1ubuntu2.18) is supported.

Sessions configuration is OK.

Allocated memory is sufficient.

mysqli extension is installed.

Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter.

curl extension is installed.

gd extension is installed.

intl extension is installed.

zlib extension is installed.

The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.

Database engine version (10.6.18) is supported.

No files from previous GLPI version detected.

The log file has been created successfully.

Write access to /var/www/html/glpi/files/_cache has been validated.

Write access to /var/www/html/glpi/files/_cron has been validated.

Write access to /var/www/html/glpi/files has been validated.

Write access to /var/www/html/glpi/files/_dumps has been validated.

Write access to /var/www/html/glpi/files/_graphs has been validated.

Write access to /var/www/html/glpi/files/_lock has been validated.

Write access to /var/www/html/glpi/files/_pictures has been validated.

Write access to /var/www/html/glpi/files/_plugins has been validated.

Write access to /var/www/html/glpi/files/_rss has been validated.

Write access to /var/www/html/glpi/files/_sessions has been validated.

Write access to /var/www/html/glpi/files/_tmp has been validated.

Write access to /var/www/html/glpi/files/_uploads has been validated.
Web server root directory configuration is not safe as it permits access to non-public files. See installation documentation for more details.

The following directories should be placed outside "/var/www/html/glpi":

‣ "/var/www/html/glpi/files" ("GLPI_VAR_DIR")

You can ignore this suggestion if your web server root directory is "/var/www/html/glpi/public".

Sessions configuration is secured.

OS and PHP are relying on 64 bits integers.

exif extension is installed.

ldap extension is installed.

openssl extension is installed.

Following extensions are installed: bz2, Phar, zip.

Zend OPcache extension is installed.

Following extensions are installed: ctype, iconv, mbstring, sodium.

Write access to /var/www/html/glpi/marketplace has been validated.

Timezones seems loaded in database.

GLPI constants

 

GLPI_ROOT: "/var/www/html/glpi"

GLPI_CONFIG_DIR: "/var/www/html/glpi/config"

GLPI_VAR_DIR: "/var/www/html/glpi/files"

GLPI_MARKETPLACE_DIR: "/var/www/html/glpi/marketplace"

GLPI_USE_CSRF_CHECK: "1"

GLPI_CSRF_EXPIRES: "7200"

GLPI_CSRF_MAX_TOKENS: "100"

GLPI_USE_IDOR_CHECK: "1"

GLPI_IDOR_EXPIRES: "7200"

GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false

GLPI_SERVERSIDE_URL_ALLOWLIST: ["/^(https?|feed):\/\/[^@:]+(\/.*)?$/"]

GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"

GLPI_INSTALL_MODE: "TARBALL"

GLPI_NETWORK_MAIL: "glpi@teclib.com"

GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"

GLPI_MARKETPLACE_ALLOW_OVERRIDE: true

GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true

GLPI_USER_AGENT_EXTRA_COMMENTS: ""

GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"

GLPI_AJAX_DASHBOARD: "1"

GLPI_CALDAV_IMPORT_STATE: 0

GLPI_DEMO_MODE: "0"

GLPI_CENTRAL_WARNINGS: "1"

GLPI_TEXT_MAXSIZE: "4000"

GLPI_DOC_DIR: "/var/www/html/glpi/files"

GLPI_CACHE_DIR: "/var/www/html/glpi/files/_cache"

GLPI_CRON_DIR: "/var/www/html/glpi/files/_cron"

GLPI_DUMP_DIR: "/var/www/html/glpi/files/_dumps"

GLPI_GRAPH_DIR: "/var/www/html/glpi/files/_graphs"

GLPI_LOCAL_I18N_DIR: "/var/www/html/glpi/files/_locales"

GLPI_LOCK_DIR: "/var/www/html/glpi/files/_lock"

GLPI_LOG_DIR: "/var/www/html/glpi/files/_log"

GLPI_PICTURE_DIR: "/var/www/html/glpi/files/_pictures"

GLPI_PLUGIN_DOC_DIR: "/var/www/html/glpi/files/_plugins"

GLPI_RSS_DIR: "/var/www/html/glpi/files/_rss"

GLPI_SESSION_DIR: "/var/www/html/glpi/files/_sessions"

GLPI_TMP_DIR: "/var/www/html/glpi/files/_tmp"

GLPI_UPLOAD_DIR: "/var/www/html/glpi/files/_uploads"

GLPI_INVENTORY_DIR: "/var/www/html/glpi/files/_inventories"

GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"

GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"

GLPI_I18N_DIR: "/var/www/html/glpi/locales"

GLPI_VERSION: "10.0.16"

GLPI_SCHEMA_VERSION: "10.0.16@b13256c443dd4fdb27b4a0d3b8fea8caba4dfaa9"

GLPI_MARKETPLACE_PRERELEASES: false

GLPI_MIN_PHP: "7.4.0"

GLPI_MAX_PHP: "8.4.0"

GLPI_YEAR: "2024"

Libraries

 

htmlawed/htmlawed version 1.2.14 in (/var/www/html/glpi/vendor/htmlawed/htmlawed)

phpmailer/phpmailer version 6.8.0 in (/var/www/html/glpi/vendor/phpmailer/phpmailer/src)

simplepie/simplepie version 1.5.8 in (/var/www/html/glpi/vendor/simplepie/simplepie/library)

tecnickcom/tcpdf version 6.7.5 in (/var/www/html/glpi/vendor/tecnickcom/tcpdf)

michelf/php-markdown in (/var/www/html/glpi/vendor/michelf/php-markdown/Michelf)

true/punycode in (/var/www/html/glpi/vendor/true/punycode/src)

iamcal/lib_autolink in (/var/www/html/glpi/vendor/iamcal/lib_autolink)

sabre/dav in (/var/www/html/glpi/vendor/sabre/dav/lib/DAV)

sabre/http in (/var/www/html/glpi/vendor/sabre/http/lib)

sabre/uri in (/var/www/html/glpi/vendor/sabre/uri/lib)

sabre/vobject in (/var/www/html/glpi/vendor/sabre/vobject/lib)

laminas/laminas-i18n in (/var/www/html/glpi/vendor/laminas/laminas-i18n/src)

laminas/laminas-servicemanager in (/var/www/html/glpi/vendor/laminas/laminas-servicemanager/src)

monolog/monolog in (/var/www/html/glpi/vendor/monolog/monolog/src/Monolog)

sebastian/diff in (/var/www/html/glpi/vendor/sebastian/diff/src)

donatj/phpuseragentparser in (/var/www/html/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)

elvanto/litemoji in (/var/www/html/glpi/vendor/elvanto/litemoji/src)

symfony/console in (/var/www/html/glpi/vendor/symfony/console)

scssphp/scssphp in (/var/www/html/glpi/vendor/scssphp/scssphp/src)

laminas/laminas-mail in (/var/www/html/glpi/vendor/laminas/laminas-mail/src/Protocol)

laminas/laminas-mime in (/var/www/html/glpi/vendor/laminas/laminas-mime/src)

rlanvin/php-rrule in (/var/www/html/glpi/vendor/rlanvin/php-rrule/src)

ramsey/uuid in (/var/www/html/glpi/vendor/ramsey/uuid/src)

psr/log in (/var/www/html/glpi/vendor/psr/log/Psr/Log)

psr/simple-cache in (/var/www/html/glpi/vendor/psr/simple-cache/src)

psr/cache in (/var/www/html/glpi/vendor/psr/cache/src)

league/csv in (/var/www/html/glpi/vendor/league/csv/src)

mexitek/phpcolors in (/var/www/html/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)

guzzlehttp/guzzle in (/var/www/html/glpi/vendor/guzzlehttp/guzzle/src)

guzzlehttp/psr7 in (/var/www/html/glpi/vendor/guzzlehttp/psr7/src)

glpi-project/inventory_format in (/var/www/html/glpi/vendor/glpi-project/inventory_format/lib/php)

wapmorgan/unified-archive in (/var/www/html/glpi/vendor/wapmorgan/unified-archive/src)

paragonie/sodium_compat in (/var/www/html/glpi/vendor/paragonie/sodium_compat/src)

symfony/cache in (/var/www/html/glpi/vendor/symfony/cache)

html2text/html2text in (/var/www/html/glpi/vendor/html2text/html2text/src)

symfony/css-selector in (/var/www/html/glpi/vendor/symfony/css-selector)

symfony/dom-crawler in (/var/www/html/glpi/vendor/symfony/dom-crawler)

twig/twig in (/var/www/html/glpi/vendor/twig/twig/src)

twig/string-extra in (/var/www/html/glpi/vendor/twig/string-extra)

symfony/polyfill-ctype not found

symfony/polyfill-iconv not found

symfony/polyfill-mbstring not found

symfony/polyfill-php80 not found

symfony/polyfill-php81 not found

symfony/polyfill-php82 in (/var/www/html/glpi/vendor/symfony/polyfill-php82)

league/oauth2-client in (/var/www/html/glpi/vendor/league/oauth2-client/src/Provider)

league/oauth2-google in (/var/www/html/glpi/vendor/league/oauth2-google/src/Provider)

thenetworg/oauth2-azure in (/var/www/html/glpi/vendor/thenetworg/oauth2-azure/src/Provider)

phpCas version 1.3.8 in (/usr/share/php/CAS/source)

LDAP directories

 

Server: 'ldaps://sd2dc1.sys-msk.kontur-extern.ru', Port: '636', BaseDN:

'OU=Екатеринбург,DC=sys-msk,DC=kontur-extern,DC=ru', Connection filter:

'(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:

'CN=svc_glpi_ldap,OU=Служебные Учетные Записи,DC=SYS-MSK,DC=KONTUR-EXTERN,DC=RU', Use TLS: none

SQL replicas

 

Not active

Notifications

 

Way of sending emails: PHP

Plugins list

 

fields               Name: Additional fields              Version: 1.21.8     State: Enabled

Install Method: Marketplace

barcode              Name: Barcode                        Version: 2.7.1      State: Installed / not activated

Install Method: Marketplace

camerainput          Name: Camera Input                   Version: 2.1.0      State: Installed / not activated

Install Method: Marketplace

datainjection        Name: Data injection                 Version: 2.13.5     State: Installed / not activated

Install Method: Marketplace

glpiinventory        Name: GLPI Inventory                 Version: 1.3.5      State: Installed / not activated

Install Method: Marketplace

singlesignon         Name: Single Sign-on                 Version: 1.3.3      State: Enabled

Install Method: Manual

webhook              Name: Webhooks                       Version: 1.0.18     State: Enabled

Install Method: Marketplace

consumables          Name: Заказ расходных материалов Version: 2.0.1      State: Enabled

Install Method: Marketplace

behaviors            Name: Поведения                      Version: 2.7.2      State: Installed / not activated

Install Method: Marketplace

tag                  Name: Управление тегами        Version: 2.11.7     State: Enabled

Install Method: Marketplace

Anything else?

No response

[cconard96]

Not a bug. searchText filters are always treated like a contains search.
If you need further help, you can get support on the community forum.

[github-actions]

This issue has been closed as we only track bugs here.

You can get community support on forums or you can consider taking a subscription to get professional support.
You can also contact GLPI editor team directly.