[jira] Commented: (OFBIZ-2108) The bug using IN operator with FindServices.java

["WeizhanGuo (JIRA)" <ji...@apache.org>]

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

WeizhanGuo commented on OFBIZ-2108:
-----------------------------------

Thank you for your testing. 

We use it in our project for the restriction of recorders; the people can only read the recorders that under his organizations. Such as organizations id are 0001 and 0002, and we show the recorder in 0001, 0002.

I know what your mean {} around blocks, but I do set the tabs to 4 spaces, any wrong about this?

> 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
>            Assignee: Jacques Le Roux
>             Fix For: SVN trunk
>
>         Attachments: FindServices_IN.patch
>
>
> 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.