You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacques Le Roux (Jira)" <ji...@apache.org> on 2024/02/22 16:35:00 UTC

[jira] [Comment Edited] (OFBIZ-12879) Issue with EntityOperator.LIKE

    [ https://issues.apache.org/jira/browse/OFBIZ-12879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17819717#comment-17819717 ] 

Jacques Le Roux edited comment on OFBIZ-12879 at 2/22/24 4:34 PM:
------------------------------------------------------------------

Hi Mo,

There are 138 occurrences of EntityOperator.LIKE use in trunk OOTB code. Those are working perfectly until proven otherwise. So we need more context. You issue could be related to it.

For instance you say
bq. The same code used to work with previous OFBIZ versions 16.  I have tested both with 17.12 and 18.12.11, it does not work.
with this context it could be easier to identify the issue.

Also, you should try with Derby which is still the OOTB DBMS.


was (Author: jacques.le.roux):
Hi Mo,

There are 138 occurrences of EntityOperator.LIKE use in trunk OOTB code. Those are working perfectly until proven otherwise. So we need more context. You issue could be related to it.

For instance you say
bq. The same code used to work with previous OFBIZ versions 16.  I have tested both with 17.12 and 18.12.11, it does not work.
with this context it could be easier to identify the issue.


> Issue with EntityOperator.LIKE
> ------------------------------
>
>                 Key: OFBIZ-12879
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-12879
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework/entity
>    Affects Versions: 17.12.09, 18.12.11
>         Environment: Windows
>            Reporter: Mo Fadili
>            Priority: Major
>
> {color:#000000}Search with EntityOperator.LIKE does not return any result:{color}
> Examples
> EntityFunction.{color:#000000}upper{color}{color:#000000}({color}{color:#2a00ff}"partyId"{color}{color:#000000}), EntityOperator.{color}{color:#0000c0}LIKE{color}{color:#000000}, EntityFunction.{color}{color:#000000}upper{color}{color:#000000}({color}{color:#2a00ff}"%"{color}{color:#000000} + {color}{color:#6a3e3e}searchTerm{color}{color:#000000} + {color}{color:#2a00ff}"%"{color}{color:#000000}){color}
> or
> EntityFunction.upper("partyId"), EntityOperator.LIKE , "%" + searchTerm.toUpperCase() + "%")
>  
> The same code used to work with previous OFBIZ versions 16.  
> I have tested both with 17.12 and 18.12.11, it does not work.
>  
> The dabase used is postgresql 14 and jdbc driver {color:#000000}{color:#3f7f5f}pluginLibsCompile 'org.postgresql:postgresql:42.6.0'{color}{color}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)