You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2008/12/29 22:32:46 UTC
[jira] Closed: (OFBIZ-2108) The bug using IN operator with
FindServices.java
[ 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.