The bug using IN operator with FindServices.java
------------------------------------------------

                 Key: OFBIZ-2108
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2108
             Project: OFBiz
          Issue Type: Bug
          Components: framework
    Affects Versions: SVN trunk
            Reporter: WeizhanGuo


I want search all the OrganId is  0001 or 0002, and use the performFindList 
service.
So I set the value like this:pfInput.inputFields.OrganId_fld0_op=in and 
pfInput.inputFields.OrganId_fld0_value=0001,0002 and invoke the service, the 
generate where SQL is "OrganId in ('0001,0002') "  but what I want is "OrganId 
in ('0001','0002')."
if I pass the list value to the pfInput.inputFields.OrganId_fld0_value, the 
createCondtion don't support value as list type. and the method of 
convertFieldValue will convert the list to String, that's more complex.

I created a patch, let the value accept the list and if the operator is in 
ignore the convertFieldValue.
Please let me know if there is any problem

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to