Branch: refs/heads/stable-17.4.x Home: https://github.com/xwiki/xwiki-platform Commit: d55e19ccec792e4a5393868a487b0a5d88992baa https://github.com/xwiki/xwiki-platform/commit/d55e19ccec792e4a5393868a487b0... Author: Michael Hamann <[email protected]> Date: 2025-12-10 (Wed, 10 Dec 2025) Changed paths: M xwiki-platform-core/xwiki-platform-livedata/xwiki-platform-livedata-test/xwiki-platform-livedata-test-docker/src/test/it/org/xwiki/livedata/test/ui/LiveDataIT.java M xwiki-platform-core/xwiki-platform-livetable/xwiki-platform-livetable-ui/src/main/resources/XWiki/LiveTableResultsMacros.xml M xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/internal/objects/classes/UsedValuesListQueryBuilder.java M xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/objects/classes/GroupsClass.java M xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/objects/classes/LevelsClass.java M xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/objects/classes/ListClass.java M xwiki-platform-core/xwiki-platform-oldcore/src/main/java/com/xpn/xwiki/objects/classes/UsersClass.java M xwiki-platform-core/xwiki-platform-oldcore/src/test/java/com/xpn/xwiki/internal/objects/classes/UsedValuesListQueryBuilderTest.java M xwiki-platform-core/xwiki-platform-query/xwiki-platform-query-manager/src/main/java/org/xwiki/query/internal/TextQueryFilter.java M xwiki-platform-core/xwiki-platform-query/xwiki-platform-query-manager/src/test/java/org/xwiki/query/internal/TextQueryFilterTest.java Log Message: ----------- XWIKI-23781: No used values suggested for list fields on Oracle (#4912) * Select the property type in UsedValuesListQueryBuilder based on the actual property type. This fixes the used value suggestions for User and Group properties. * Don't use special queries for Oracle unless we're actually using CLOB. * Use a min-query on the object ID for Oracle CLOB values to filter duplicates and use a dummy value to support the code that expects the count value. * Remove the `str()` conversion from `TextQueryFilter` for all columns we use here as it causes problems with long CLOB columns - while `lower()` alone surprisingly works. * Support filtering on list properties with large storage in LiveTableResultsMacros.xml. * Add integration tests in LiveDataIT that hopefully cover all cases of list values. * Use a private record to store the select and from statements to make the code clearer. * Add comments to explain the used aliases. * Add comments about the logic from ListClass and property choices of other list classes being duplicated. Backport note: kept the test about relational storage but removed the empty filter check as it's not supported before XWiki 17.10.1, see also XWIKI-23727. (cherry picked from commit cff3976202faff1656bb3487599d92d81fd0a79c) To unsubscribe from these emails, change your notification settings at https://github.com/xwiki/xwiki-platform/settings/notifications