[ https://issues.apache.org/jira/browse/OFBIZ-2108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-2108. ---------------------------------- Resolution: Fixed Fix Version/s: SVN trunk Assignee: Jacques Le Roux Not sure how/when to use this in real life, but it works. Tested using {code} <simple-method method-name="isSubscribed" short-description="check if a party has a subscription"> <set field="map.invoiceId_fld0_op" value="in"/> <call-bsh><![CDATA[ list = new ArrayList(); list.add("demo10000"); list.add("demo11000"); parameters.put("listValues", list); ]]></call-bsh> <set field="map.invoiceId_fld0_value" from-field="parameters.listValues"/> <set field="pfInput.inputFields" from-field="map"/> <set field="pfInput.entityName" value="Invoice"/> <set field="pfInput.filterByDate" from-field="parameters.filterByDate" default-value="N"/> {code} This is the kind of stuff I'd like to have when testing a patch :/ Anyway, thanks Jack, Your slightly modified (tabs -> 4 spaces, {} around blocks, some other minor formatting issues) patch is in trunk revision: 730001 > 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.