Query parameter $search with "and"/"or" adds brackets which causes irregular behaviors

[JimmyDZH]

Describe the Bug

Using the .or() or .and() functions in query parameter function .search() to add multiple search strings automatically creates brackets, which, according to SAP Support, are not allowed in the search request and cause irregular behaviour.

For example:
For a table in SAP with a key type int and some entries with the values (1,2,3,4,5,etc.)

• $search = 1 OR 7: both entries 1 and 7 are found
• $search = (1 OR 7): short dump in ABAP

For a table in SAP with a key type char and some entries with the values (1,2,3,4,5,etc.)

• $search = 1 OR 7: both entries 1 and 7 are found
• $search = (1 OR 7): no entries are found

We also asked the SAP Support why brackets cause such an issue since they seem necessary for the and/or grouping. Here is the answer.

Steps to Reproduce

1. Create a table in SAP with a key type int4 or char and some entries with the values (1,2,3,4,5,etc.)
2. Create a RAP service or expose OData API for the table
3. Use the search function with "or"/"and" in the SDK or manually add the search string to the request url ?$search = (1 OR 7)
4. A dump is raised or no value was found

Expected Behavior

No brackets are added, or the result is the same as if no brackets were added.

Screenshots

Table with integer type as key

Table with character/string type as key

Used Versions

Maven: 3.9.12
Java: 25.0.2
SAP Cloud SDK: 5.29.0
Spring Boot: 4.0.3

dependency tree

[INFO] com.samplecompany:auszahlung-service:jar:1.0.x-SNAPSHOT
[INFO] +- com.sap.cloud.sdk:sdk-core:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:cloudplatform-connectivity:jar:5.29.0:compile
[INFO] |  |  +- com.sap.cloud.sdk.cloudplatform:resilience-api:jar:5.29.0:compile
[INFO] |  |  +- com.sap.cloud.environment.servicebinding.api:java-core-api:jar:0.30.0:compile
[INFO] |  |  +- com.sap.cloud.environment.servicebinding.api:java-access-api:jar:0.30.0:compile
[INFO] |  |  +- com.mikesamuel:json-sanitizer:jar:1.2.3:compile
[INFO] |  |  +- org.apache.commons:commons-lang3:jar:3.19.0:compile
[INFO] |  |  +- com.auth0:java-jwt:jar:4.5.1:compile
[INFO] |  |  +- org.bouncycastle:bcprov-jdk18on:jar:1.84:compile
[INFO] |  |  \- org.bouncycastle:bcpkix-jdk18on:jar:1.84:compile
[INFO] |  |     \- org.bouncycastle:bcutil-jdk18on:jar:1.84:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:connectivity-destination-service:jar:5.29.0:compile
[INFO] |  |  +- com.sap.cloud.sdk.cloudplatform:connectivity-apache-httpclient5:jar:5.29.0:compile
[INFO] |  |  +- com.github.ben-manes.caffeine:caffeine:jar:3.2.3:compile
[INFO] |  |  +- commons-io:commons-io:jar:2.21.0:compile
[INFO] |  |  +- org.apache.httpcomponents.core5:httpcore5:jar:5.3.6:compile
[INFO] |  |  +- org.apache.httpcomponents.client5:httpclient5:jar:5.5.2:compile
[INFO] |  |  |  \- org.apache.httpcomponents.core5:httpcore5-h2:jar:5.3.6:compile
[INFO] |  |  \- com.sap.cloud.environment.servicebinding.api:java-consumption-api:jar:0.30.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:connectivity-oauth:jar:5.29.0:compile
[INFO] |  |  +- com.sap.cloud.security.xsuaa:token-client:jar:4.0.3:compile
[INFO] |  |  +- com.sap.cloud.security:java-api:jar:4.0.3:compile
[INFO] |  |  +- org.json:json:jar:20251224:compile
[INFO] |  |  \- com.sap.cloud.security:java-security:jar:4.0.3:runtime
[INFO] |  |     \- com.sap.cloud.security:env:jar:4.0.3:runtime
[INFO] |  |        +- com.sap.cloud.environment.servicebinding:java-sap-vcap-services:jar:0.30.0:runtime
[INFO] |  |        \- com.sap.cloud.environment.servicebinding:java-sap-service-operator:jar:0.30.0:runtime
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:cloudplatform-core:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:servlet-jakarta:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:tenant:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:security:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:resilience:jar:5.29.0:compile
[INFO] |  |  \- com.sap.cloud.sdk.cloudplatform:resilience4j:jar:5.29.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-core:jar:2.4.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-circuitbreaker:jar:2.4.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-bulkhead:jar:2.4.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-timelimiter:jar:2.4.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-retry:jar:2.4.0:compile
[INFO] |  |     +- io.github.resilience4j:resilience4j-ratelimiter:jar:2.4.0:compile
[INFO] |  |     \- javax.cache:cache-api:jar:1.1.1:compile
[INFO] |  \- com.sap.cloud.sdk.cloudplatform:caching:jar:5.29.0:compile
[INFO] +- com.sap.cloud.sdk.datamodel:odata-v4-core:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.datamodel:odata-client:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.cloudplatform:connectivity-apache-httpclient4:jar:5.29.0:compile
[INFO] |  +- com.sap.cloud.sdk.datamodel:fluent-result:jar:5.29.0:compile
[INFO] |  +- org.slf4j:slf4j-api:jar:2.0.17:compile
[INFO] |  +- org.slf4j:jcl-over-slf4j:jar:2.0.17:runtime
[INFO] |  +- com.google.guava:guava:jar:33.6.0-jre:compile
[INFO] |  |  +- com.google.guava:failureaccess:jar:1.0.3:compile
[INFO] |  |  +- com.google.guava:listenablefuture:jar:9999.0-empty-to-avoid-conflict-with-guava:compile
[INFO] |  |  +- com.google.errorprone:error_prone_annotations:jar:2.48.0:compile
[INFO] |  |  \- com.google.j2objc:j2objc-annotations:jar:3.1:compile
[INFO] |  +- com.google.code.gson:gson:jar:2.13.2:compile
[INFO] |  +- com.fasterxml.jackson.core:jackson-annotations:jar:2.21:compile
[INFO] |  +- com.fasterxml.jackson.core:jackson-core:jar:2.21.2:compile
[INFO] |  +- com.fasterxml.jackson.core:jackson-databind:jar:2.21.2:compile
[INFO] |  +- org.apache.httpcomponents:httpclient:jar:4.5.14:compile
[INFO] |  |  \- commons-codec:commons-codec:jar:1.19.0:compile
[INFO] |  +- io.vavr:vavr:jar:1.0.1:compile
[INFO] |  |  \- io.vavr:vavr-match:jar:1.0.0:compile
[INFO] |  +- org.apache.httpcomponents:httpcore:jar:4.4.16:compile
[INFO] |  \- com.google.code.findbugs:jsr305:jar:3.0.2:compile
[INFO] +- org.springframework.boot:spring-boot-starter-cache:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-starter:jar:4.0.3:compile
[INFO] |  |  +- org.springframework.boot:spring-boot-starter-logging:jar:4.0.3:compile
[INFO] |  |  |  +- org.apache.logging.log4j:log4j-to-slf4j:jar:2.25.3:compile
[INFO] |  |  |  |  \- org.apache.logging.log4j:log4j-api:jar:2.25.3:compile
[INFO] |  |  |  \- org.slf4j:jul-to-slf4j:jar:2.0.17:compile
[INFO] |  |  +- org.springframework.boot:spring-boot-autoconfigure:jar:4.0.3:compile
[INFO] |  |  +- jakarta.annotation:jakarta.annotation-api:jar:3.0.0:compile
[INFO] |  |  \- org.yaml:snakeyaml:jar:2.5:compile
[INFO] |  \- org.springframework.boot:spring-boot-cache:jar:4.0.3:compile
[INFO] |     \- org.springframework:spring-context-support:jar:7.0.5:compile
[INFO] +- org.springframework.boot:spring-boot-starter-webmvc:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-starter-jackson:jar:4.0.3:compile
[INFO] |  |  \- org.springframework.boot:spring-boot-jackson:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-starter-tomcat:jar:4.0.3:compile
[INFO] |  |  +- org.springframework.boot:spring-boot-starter-tomcat-runtime:jar:4.0.3:compile
[INFO] |  |  |  +- org.apache.tomcat.embed:tomcat-embed-core:jar:11.0.18:compile
[INFO] |  |  |  \- org.apache.tomcat.embed:tomcat-embed-websocket:jar:11.0.18:compile
[INFO] |  |  \- org.springframework.boot:spring-boot-tomcat:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-http-converter:jar:4.0.3:compile
[INFO] |  |  \- org.springframework:spring-web:jar:7.0.5:compile
[INFO] |  \- org.springframework.boot:spring-boot-webmvc:jar:4.0.3:compile
[INFO] |     +- org.springframework.boot:spring-boot-servlet:jar:4.0.3:compile
[INFO] |     \- org.springframework:spring-webmvc:jar:7.0.5:compile
[INFO] |        \- org.springframework:spring-expression:jar:7.0.5:compile
[INFO] +- org.springframework.boot:spring-boot-starter-restclient:jar:4.0.3:compile
[INFO] |  \- org.springframework.boot:spring-boot-restclient:jar:4.0.3:compile
[INFO] |     \- org.springframework.boot:spring-boot-http-client:jar:4.0.3:compile
[INFO] +- org.springframework.boot:spring-boot-starter-actuator:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-starter-micrometer-metrics:jar:4.0.3:compile
[INFO] |  |  \- org.springframework.boot:spring-boot-micrometer-metrics:jar:4.0.3:compile
[INFO] |  |     \- org.springframework.boot:spring-boot-micrometer-observation:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-actuator-autoconfigure:jar:4.0.3:compile
[INFO] |  |  \- org.springframework.boot:spring-boot-actuator:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-health:jar:4.0.3:compile
[INFO] |  +- io.micrometer:micrometer-observation:jar:1.16.3:compile
[INFO] |  |  \- io.micrometer:micrometer-commons:jar:1.16.3:compile
[INFO] |  \- io.micrometer:micrometer-jakarta9:jar:1.16.3:compile
[INFO] +- org.springframework.boot:spring-boot-starter-security:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-security:jar:4.0.3:compile
[INFO] |  |  +- org.springframework.security:spring-security-config:jar:7.0.3:compile
[INFO] |  |  \- org.springframework.security:spring-security-web:jar:7.0.3:compile
[INFO] |  \- org.springframework:spring-aop:jar:7.0.5:compile
[INFO] |     +- org.springframework:spring-beans:jar:7.0.5:compile
[INFO] |     \- org.springframework:spring-core:jar:7.0.5:compile
[INFO] +- org.springframework.boot:spring-boot-starter-validation:jar:4.0.3:compile
[INFO] |  \- org.springframework.boot:spring-boot-validation:jar:4.0.3:compile
[INFO] |     +- org.apache.tomcat.embed:tomcat-embed-el:jar:11.0.18:compile
[INFO] |     \- org.hibernate.validator:hibernate-validator:jar:9.0.1.Final:compile
[INFO] |        +- jakarta.validation:jakarta.validation-api:jar:3.1.1:compile
[INFO] |        +- org.jboss.logging:jboss-logging:jar:3.6.2.Final:compile
[INFO] |        \- com.fasterxml:classmate:jar:1.7.3:compile
[INFO] +- org.springframework.boot:spring-boot-starter-security-oauth2-resource-server:jar:4.0.3:compile
[INFO] |  \- org.springframework.boot:spring-boot-security-oauth2-resource-server:jar:4.0.3:compile
[INFO] |     \- org.springframework.security:spring-security-oauth2-resource-server:jar:7.0.3:compile
[INFO] +- org.springframework.boot:spring-boot-starter-security-oauth2-client:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-security-oauth2-client:jar:4.0.3:compile
[INFO] |  |  \- org.springframework.security:spring-security-oauth2-client:jar:7.0.3:compile
[INFO] |  |     \- com.nimbusds:oauth2-oidc-sdk:jar:11.26.1:compile
[INFO] |  |        +- com.github.stephenc.jcip:jcip-annotations:jar:1.0-1:compile
[INFO] |  |        +- com.nimbusds:content-type:jar:2.3:compile
[INFO] |  |        \- com.nimbusds:lang-tag:jar:1.7:compile
[INFO] |  \- org.springframework.security:spring-security-oauth2-jose:jar:7.0.3:compile
[INFO] |     +- org.springframework.security:spring-security-core:jar:7.0.3:compile
[INFO] |     |  \- org.springframework.security:spring-security-crypto:jar:7.0.3:compile
[INFO] |     +- org.springframework.security:spring-security-oauth2-core:jar:7.0.3:compile
[INFO] |     \- com.nimbusds:nimbus-jose-jwt:jar:10.4:compile
[INFO] +- org.springframework.boot:spring-boot-configuration-processor:jar:4.0.3:compile (optional)
[INFO] +- org.springdoc:springdoc-openapi-starter-webmvc-ui:jar:3.0.1:compile
[INFO] |  +- org.springdoc:springdoc-openapi-starter-webmvc-api:jar:3.0.1:compile
[INFO] |  |  +- org.springdoc:springdoc-openapi-starter-common:jar:3.0.1:compile
[INFO] |  |  |  \- io.swagger.core.v3:swagger-core-jakarta:jar:2.2.41:compile
[INFO] |  |  |     +- io.swagger.core.v3:swagger-annotations-jakarta:jar:2.2.41:compile
[INFO] |  |  |     +- io.swagger.core.v3:swagger-models-jakarta:jar:2.2.41:compile
[INFO] |  |  |     \- com.fasterxml.jackson.dataformat:jackson-dataformat-yaml:jar:2.20.2:compile
[INFO] |  |  \- org.springframework.boot:spring-boot-web-server:jar:4.0.3:compile
[INFO] |  +- org.webjars:swagger-ui:jar:5.31.0:compile
[INFO] |  \- org.webjars:webjars-locator-lite:jar:1.1.3:compile
[INFO] +- org.projectlombok:lombok:jar:1.18.42:provided
[INFO] +- org.mapstruct:mapstruct:jar:1.6.3:compile
[INFO] +- org.mapstruct:mapstruct-processor:jar:1.6.3:provided
[INFO] +- org.wiremock.integrations:wiremock-spring-boot:jar:4.1.0:compile
[INFO] |  +- org.wiremock:wiremock-jetty12:jar:3.13.2:compile
[INFO] |  |  \- org.wiremock:wiremock:jar:3.13.2:compile
[INFO] |  |     +- com.fasterxml.jackson.datatype:jackson-datatype-jsr310:jar:2.21.2:compile
[INFO] |  |     +- org.xmlunit:xmlunit-legacy:jar:2.10.4:compile
[INFO] |  |     +- org.xmlunit:xmlunit-placeholders:jar:2.10.4:compile
[INFO] |  |     +- net.javacrumbs.json-unit:json-unit-core:jar:2.40.1:compile
[INFO] |  |     |  \- org.hamcrest:hamcrest-core:jar:3.0:compile
[INFO] |  |     +- net.sf.jopt-simple:jopt-simple:jar:5.0.4:compile
[INFO] |  |     +- com.github.jknack:handlebars:jar:4.3.1:compile
[INFO] |  |     +- com.github.jknack:handlebars-helpers:jar:4.3.1:compile
[INFO] |  |     +- commons-fileupload:commons-fileupload:jar:1.6.0:compile
[INFO] |  |     \- com.networknt:json-schema-validator:jar:1.5.9:compile
[INFO] |  |        \- com.ethlo.time:itu:jar:1.14.0:compile
[INFO] |  +- org.eclipse.jetty:jetty-server:jar:12.1.6:compile
[INFO] |  |  +- org.eclipse.jetty:jetty-http:jar:12.1.6:compile
[INFO] |  |  \- org.eclipse.jetty:jetty-io:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty:jetty-proxy:jar:12.1.6:compile
[INFO] |  |  \- org.eclipse.jetty:jetty-client:jar:12.1.6:compile
[INFO] |  |     \- org.eclipse.jetty.compression:jetty-compression-gzip:jar:12.1.6:compile
[INFO] |  |        \- org.eclipse.jetty.compression:jetty-compression-common:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty:jetty-alpn-server:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty:jetty-alpn-java-server:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty:jetty-alpn-java-client:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty:jetty-alpn-client:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty.ee10:jetty-ee10-servlet:jar:12.1.6:compile
[INFO] |  |  +- org.eclipse.jetty:jetty-security:jar:12.1.6:compile
[INFO] |  |  \- org.eclipse.jetty:jetty-session:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty.ee10:jetty-ee10-servlets:jar:12.1.6:compile
[INFO] |  |  \- org.eclipse.jetty:jetty-util:jar:12.1.6:compile
[INFO] |  +- org.eclipse.jetty.ee10:jetty-ee10-webapp:jar:12.1.6:compile
[INFO] |  |  +- org.eclipse.jetty:jetty-xml:jar:12.1.6:compile
[INFO] |  |  \- org.eclipse.jetty.ee:jetty-ee-webapp:jar:12.1.6:compile
[INFO] |  \- org.eclipse.jetty.http2:jetty-http2-server:jar:12.1.6:compile
[INFO] |     \- org.eclipse.jetty.http2:jetty-http2-common:jar:12.1.6:compile
[INFO] |        \- org.eclipse.jetty.http2:jetty-http2-hpack:jar:12.1.6:compile
[INFO] +- org.springframework.boot:spring-boot-starter-thymeleaf:jar:4.0.3:compile
[INFO] |  \- org.springframework.boot:spring-boot-thymeleaf:jar:4.0.3:compile
[INFO] |     \- org.thymeleaf:thymeleaf-spring6:jar:3.1.3.RELEASE:compile
[INFO] |        \- org.thymeleaf:thymeleaf:jar:3.1.3.RELEASE:compile
[INFO] |           +- org.attoparser:attoparser:jar:2.0.7.RELEASE:compile
[INFO] |           \- org.unbescape:unbescape:jar:1.1.6.RELEASE:compile
[INFO] +- org.xhtmlrenderer:flying-saucer-pdf:jar:10.1.0:compile
[INFO] |  +- org.xhtmlrenderer:flying-saucer-core:jar:10.1.0:compile
[INFO] |  +- com.github.librepdf:openpdf:jar:3.0.2:compile
[INFO] |  \- org.apache.xmlgraphics:batik-codec:jar:1.19:compile
[INFO] |     +- org.apache.xmlgraphics:batik-awt-util:jar:1.19:compile
[INFO] |     |  \- org.apache.xmlgraphics:xmlgraphics-commons:jar:2.11:compile
[INFO] |     +- org.apache.xmlgraphics:batik-bridge:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-anim:jar:1.19:compile
[INFO] |     |  |  \- org.apache.xmlgraphics:batik-ext:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-css:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-dom:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-gvt:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-parser:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-script:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-svg-dom:jar:1.19:compile
[INFO] |     |  +- org.apache.xmlgraphics:batik-xml:jar:1.19:compile
[INFO] |     |  \- xml-apis:xml-apis-ext:jar:1.3.04:compile
[INFO] |     +- org.apache.xmlgraphics:batik-shared-resources:jar:1.19:compile
[INFO] |     +- org.apache.xmlgraphics:batik-transcoder:jar:1.19:compile
[INFO] |     |  \- org.apache.xmlgraphics:batik-svggen:jar:1.19:compile
[INFO] |     \- org.apache.xmlgraphics:batik-util:jar:1.19:compile
[INFO] |        +- org.apache.xmlgraphics:batik-constants:jar:1.19:compile
[INFO] |        \- org.apache.xmlgraphics:batik-i18n:jar:1.19:compile
[INFO] +- org.springframework.boot:spring-boot-starter-data-jpa:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot-starter-jdbc:jar:4.0.3:compile
[INFO] |  |  \- com.zaxxer:HikariCP:jar:7.0.2:compile
[INFO] |  +- org.springframework.boot:spring-boot-data-jpa:jar:4.0.3:compile
[INFO] |  |  +- org.springframework.boot:spring-boot-data-commons:jar:4.0.3:compile
[INFO] |  |  |  +- org.springframework.boot:spring-boot-persistence:jar:4.0.3:compile
[INFO] |  |  |  \- org.springframework.data:spring-data-commons:jar:4.0.3:compile
[INFO] |  |  +- org.springframework.boot:spring-boot-hibernate:jar:4.0.3:compile
[INFO] |  |  |  +- org.springframework.boot:spring-boot-jpa:jar:4.0.3:compile
[INFO] |  |  |  |  \- jakarta.persistence:jakarta.persistence-api:jar:3.2.0:compile
[INFO] |  |  |  +- org.hibernate.orm:hibernate-core:jar:7.2.4.Final:compile
[INFO] |  |  |  |  +- jakarta.transaction:jakarta.transaction-api:jar:2.0.1:compile
[INFO] |  |  |  |  +- org.hibernate.models:hibernate-models:jar:1.0.1:runtime
[INFO] |  |  |  |  +- org.glassfish.jaxb:jaxb-runtime:jar:4.0.6:runtime
[INFO] |  |  |  |  |  \- org.glassfish.jaxb:jaxb-core:jar:4.0.6:runtime
[INFO] |  |  |  |  |     +- org.eclipse.angus:angus-activation:jar:2.0.3:runtime
[INFO] |  |  |  |  |     +- org.glassfish.jaxb:txw2:jar:4.0.6:runtime
[INFO] |  |  |  |  |     \- com.sun.istack:istack-commons-runtime:jar:4.1.2:runtime
[INFO] |  |  |  |  \- jakarta.inject:jakarta.inject-api:jar:2.0.1:runtime
[INFO] |  |  |  \- org.springframework:spring-orm:jar:7.0.5:compile
[INFO] |  |  +- org.springframework.data:spring-data-jpa:jar:4.0.3:compile
[INFO] |  |  |  +- org.springframework:spring-tx:jar:7.0.5:compile
[INFO] |  |  |  \- org.antlr:antlr4-runtime:jar:4.13.2:compile
[INFO] |  |  \- org.springframework:spring-aspects:jar:7.0.5:compile
[INFO] |  |     \- org.aspectj:aspectjweaver:jar:1.9.25.1:compile
[INFO] |  \- org.springframework.boot:spring-boot-jdbc:jar:4.0.3:compile
[INFO] |     +- org.springframework.boot:spring-boot-sql:jar:4.0.3:compile
[INFO] |     +- org.springframework.boot:spring-boot-transaction:jar:4.0.3:compile
[INFO] |     \- org.springframework:spring-jdbc:jar:7.0.5:compile
[INFO] +- org.springframework.boot:spring-boot-starter-liquibase:jar:4.0.3:compile
[INFO] |  \- org.springframework.boot:spring-boot-liquibase:jar:4.0.3:compile
[INFO] |     \- org.liquibase:liquibase-core:jar:5.0.1:compile
[INFO] |        +- com.opencsv:opencsv:jar:5.12.0:compile
[INFO] |        +- org.apache.commons:commons-collections4:jar:4.5.0:compile
[INFO] |        \- org.apache.commons:commons-text:jar:1.14.0:compile
[INFO] +- org.springframework.boot:spring-boot-h2console:jar:4.0.3:compile
[INFO] |  +- org.springframework.boot:spring-boot:jar:4.0.3:compile
[INFO] |  |  \- org.springframework:spring-context:jar:7.0.5:compile
[INFO] |  +- jakarta.servlet:jakarta.servlet-api:jar:6.1.0:compile
[INFO] |  \- com.h2database:h2:jar:2.4.240:compile
[INFO] +- com.oracle.database.jdbc:ojdbc11:jar:23.9.0.25.07:runtime
[INFO] +- io.micrometer:micrometer-registry-prometheus:jar:1.16.3:runtime
[INFO] |  +- org.jspecify:jspecify:jar:1.0.0:compile
[INFO] |  +- io.micrometer:micrometer-core:jar:1.16.3:compile
[INFO] |  |  +- org.hdrhistogram:HdrHistogram:jar:2.2.2:runtime
[INFO] |  |  \- org.latencyutils:LatencyUtils:jar:2.0.3:runtime
[INFO] |  +- io.prometheus:prometheus-metrics-core:jar:1.4.3:runtime
[INFO] |  |  +- io.prometheus:prometheus-metrics-model:jar:1.4.3:runtime
[INFO] |  |  \- io.prometheus:prometheus-metrics-config:jar:1.4.3:runtime
[INFO] |  +- io.prometheus:prometheus-metrics-tracer-common:jar:1.4.3:runtime
[INFO] |  \- io.prometheus:prometheus-metrics-exposition-formats:jar:1.4.3:runtime
[INFO] |     \- io.prometheus:prometheus-metrics-exposition-textformats:jar:1.4.3:runtime
[INFO] +- net.logstash.logback:logstash-logback-encoder:jar:9.0:compile
[INFO] |  \- tools.jackson.core:jackson-databind:jar:3.0.4:compile
[INFO] |     \- tools.jackson.core:jackson-core:jar:3.0.4:compile
[INFO] +- org.codehaus.janino:janino:jar:3.1.12:compile
[INFO] |  \- org.codehaus.janino:commons-compiler:jar:3.1.12:compile
[INFO] +- org.springframework.boot:spring-boot-starter-webmvc-test:jar:4.0.3:test
[INFO] |  +- org.springframework.boot:spring-boot-starter-jackson-test:jar:4.0.3:test
[INFO] |  +- org.springframework.boot:spring-boot-starter-test:jar:4.0.3:test
[INFO] |  |  +- org.springframework.boot:spring-boot-test:jar:4.0.3:test
[INFO] |  |  +- org.springframework.boot:spring-boot-test-autoconfigure:jar:4.0.3:test
[INFO] |  |  +- com.jayway.jsonpath:json-path:jar:2.10.0:compile
[INFO] |  |  +- jakarta.xml.bind:jakarta.xml.bind-api:jar:4.0.4:compile
[INFO] |  |  |  \- jakarta.activation:jakarta.activation-api:jar:2.1.4:compile
[INFO] |  |  +- net.minidev:json-smart:jar:2.6.0:compile
[INFO] |  |  |  \- net.minidev:accessors-smart:jar:2.6.0:compile
[INFO] |  |  |     \- org.ow2.asm:asm:jar:9.7.1:compile
[INFO] |  |  +- org.assertj:assertj-core:jar:3.27.7:test
[INFO] |  |  |  \- net.bytebuddy:byte-buddy:jar:1.17.8:runtime
[INFO] |  |  +- org.awaitility:awaitility:jar:4.3.0:test
[INFO] |  |  +- org.hamcrest:hamcrest:jar:3.0:compile
[INFO] |  |  +- org.junit.jupiter:junit-jupiter:jar:6.0.3:test
[INFO] |  |  |  +- org.junit.jupiter:junit-jupiter-api:jar:6.0.3:test
[INFO] |  |  |  |  +- org.opentest4j:opentest4j:jar:1.3.0:test
[INFO] |  |  |  |  +- org.junit.platform:junit-platform-commons:jar:6.0.3:test
[INFO] |  |  |  |  \- org.apiguardian:apiguardian-api:jar:1.1.2:test
[INFO] |  |  |  +- org.junit.jupiter:junit-jupiter-params:jar:6.0.3:test
[INFO] |  |  |  \- org.junit.jupiter:junit-jupiter-engine:jar:6.0.3:test
[INFO] |  |  |     \- org.junit.platform:junit-platform-engine:jar:6.0.3:test
[INFO] |  |  +- org.mockito:mockito-core:jar:5.20.0:test
[INFO] |  |  |  +- net.bytebuddy:byte-buddy-agent:jar:1.17.8:test
[INFO] |  |  |  \- org.objenesis:objenesis:jar:3.3:test
[INFO] |  |  +- org.mockito:mockito-junit-jupiter:jar:5.20.0:test
[INFO] |  |  +- org.skyscreamer:jsonassert:jar:1.5.3:test
[INFO] |  |  |  \- com.vaadin.external.google:android-json:jar:0.0.20131108.vaadin1:test
[INFO] |  |  +- org.springframework:spring-test:jar:7.0.5:test
[INFO] |  |  \- org.xmlunit:xmlunit-core:jar:2.10.4:compile
[INFO] |  +- org.springframework.boot:spring-boot-webmvc-test:jar:4.0.3:test
[INFO] |  \- org.springframework.boot:spring-boot-resttestclient:jar:4.0.3:test
[INFO] +- org.springframework.boot:spring-boot-starter-restclient-test:jar:4.0.3:test
[INFO] |  \- org.springframework.boot:spring-boot-restclient-test:jar:4.0.3:test
[INFO] +- org.springframework.boot:spring-boot-starter-security-test:jar:4.0.3:test
[INFO] |  \- org.springframework.boot:spring-boot-security-test:jar:4.0.3:test
[INFO] |     \- org.springframework.security:spring-security-test:jar:7.0.3:test
[INFO] +- org.springframework.boot:spring-boot-starter-liquibase-test:jar:4.0.3:test
[INFO] |  \- org.springframework.boot:spring-boot-starter-jdbc-test:jar:4.0.3:test
[INFO] |     \- org.springframework.boot:spring-boot-jdbc-test:jar:4.0.3:test
[INFO] \- de.redsix:pdfcompare:jar:1.2.8:test
[INFO]    +- org.apache.pdfbox:pdfbox:jar:3.0.3:test
[INFO]    |  +- org.apache.pdfbox:pdfbox-io:jar:3.0.3:test
[INFO]    |  +- org.apache.pdfbox:fontbox:jar:3.0.3:test
[INFO]    |  \- commons-logging:commons-logging:jar:1.3.5:compile
[INFO]    +- com.typesafe:config:jar:1.4.3:test
[INFO]    +- ch.qos.logback:logback-classic:jar:1.5.32:compile
[INFO]    |  \- ch.qos.logback:logback-core:jar:1.5.32:compile
[INFO]    \- commons-cli:commons-cli:jar:1.6.0:test

Code Examples

No response

Stack Trace

No response

Log File

No response

Affected Development Phase

Development

Impact

Impaired

Timeline

No response

[rpanackal]

Hi @JimmyDZH

Parentheses for grouping are part of the OData V4 standard. The current behavior is correct as per the specification and not a bug.

We cannot remove this behaviour since this will break important functionality for our users who rely on the grouping.

What you can try instead of using SearchExpression is to construct your search query manually and add it via withQueryParameter. See the example below,

myService.getAllMyEntities().withQueryParameter("$search", "1 OR 7")

[JimmyDZH]

Hi @rpanackal,

thank you for the answer! I expected as much since they normally an issue, but this seems to be an issue when used together with a RAP O4 API service. We will try the suggested answer.

Thank you.

Best regards
Jimmy