You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@olingo.apache.org by "Grigorii Mirsaitov (Jira)" <ji...@apache.org> on 2021/07/08 08:34:00 UTC

[jira] [Created] (OLINGO-1533) Invalid behavior of toupper function

Grigorii Mirsaitov created OLINGO-1533:
------------------------------------------

             Summary: Invalid behavior of toupper function
                 Key: OLINGO-1533
                 URL: https://issues.apache.org/jira/browse/OLINGO-1533
             Project: Olingo
          Issue Type: Bug
          Components: odata2-core
    Affects Versions: V2 2.0.11
            Reporter: Grigorii Mirsaitov


Entity LearningJournals has field IndividualProgramReason (enum __ type)

*URL Request:*

Unsuccessful:
{code:java}
/LearningJournals?$top=5&$filter=toupper(IndividualProgramReason) eq 'EDUCATION'{code}
doesn't work 

"OData - JPA Runtime: JPA query syntax is not correct"

 

Successful:
{code:java}
/LearningJournals?$top=5&$filter=startswith(toupper(IndividualProgramReason),'EDUCATION')
{code}
{code:java}
/LearningJournals?$top=5&$filter=startswith(IndividualProgramReason, 'ED')
{code}
After research of problem I found:
{code:java}
?$filter=toupper(IndividualProgramReason) eq 'EDUCATION'
{code}
parameter EDUCATION has type String. It is conflict of type of field (enun type) and parameter (string)

 
{code:java}
?$filter=IndividualProgramReason eq 'EDUCATION'
{code}
parameter EDUCATION has type Enum. No conflict.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)