[
https://issues.apache.org/jira/browse/OFBIZ-4815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255188#comment-13255188
]
Daniel Riquelme edited comment on OFBIZ-4815 at 4/16/12 11:48 PM:
------------------------------------------------------------------
Only two lines of the file
framework/common/src/org/ofbiz/common/FindServices.java were modified to enable
de NOT-IN operator.
It can be tested with the following code:
{code:xml}
<form name="ListExamples" type="list" list-name="listIt"
paginate-target="FindExample" default-entity-name="Example"
separate-columns="true"
odd-row-style="alternate-row" header-row-style="header-row-2"
default-table-style="basic-table hover-bar">
<actions>
<set field="notExamples[]" value="EX01" />
<set field="notExamples[]" value="EX03"/>
<set field="parameters.exampleId_fld0_op" value="not-in"/>
<set field="parameters.exampleId_fld0_value"
from-field="notExamples" type="List"/>
<service service-name="performFind" result-map="result"
result-map-list="listIt">
<field-map field-name="inputFields" from-field="exampleCtx"/>
<field-map field-name="entityName" value="Example"/>
<field-map field-name="orderBy"
from-field="parameters.sortField"/>
<field-map field-name="viewIndex" from-field="viewIndex"/>
<field-map field-name="viewSize" from-field="viewSize"/>
</service>
</actions>
<alt-row-style use-when=""EXST_APPROVED".equals(statusId)"
style="Validate"/>
<alt-row-style use-when=""EXST_CANCELLED".equals(statusId)"
style="Warn"/>
<field name="exampleId" title="${uiLabelMap.ExampleExampleId}"
widget-style="buttontext">
<hyperlink also-hidden="false" description="${exampleId}"
target="EditExample">
<parameter param-name="exampleId"/>
</hyperlink>
</field>
<field name="exampleName" title="${uiLabelMap.CommonName}"
sort-field="true"><display/></field>
<field name="exampleTypeId"
title="${uiLabelMap.CommonType}"><display-entity
entity-name="ExampleType"/></field>
<field name="statusId"
title="${uiLabelMap.CommonStatus}"><display-entity
entity-name="StatusItem"/></field>
<field name="description" title="${uiLabelMap.CommonDescription}"
sort-field="true"><display/></field>
</form>
{code}
was (Author: driquelme):
Only two lines of the file
framework/common/src/org/ofbiz/common/FindServices.java were modified to enable
de NOT-IN operator.
It can be tested with the following code:
{code:xml}
<form name="ListExamples" type="list" list-name="listIt"
paginate-target="FindExample" default-entity-name="Example"
separate-columns="true"
odd-row-style="alternate-row" header-row-style="header-row-2"
default-table-style="basic-table hover-bar">
<actions>
<set field="notExamples[]" value="EX01" />
<set field="notExamples[]" value="EX03"/>
<set field="parameters.exampleId_fld0_op"
value="not-in"/>
<set field="parameters.exampleId_fld0_value"
from-field="notExamples" type="List"/>
<service service-name="performFind" result-map="result"
result-map-list="listIt">
<field-map field-name="inputFields" from-field="exampleCtx"/>
<field-map field-name="entityName" value="Example"/>
<field-map field-name="orderBy"
from-field="parameters.sortField"/>
<field-map field-name="viewIndex" from-field="viewIndex"/>
<field-map field-name="viewSize" from-field="viewSize"/>
</service>
</actions>
<alt-row-style use-when=""EXST_APPROVED".equals(statusId)"
style="Validate"/>
<alt-row-style use-when=""EXST_CANCELLED".equals(statusId)"
style="Warn"/>
<field name="exampleId" title="${uiLabelMap.ExampleExampleId}"
widget-style="buttontext">
<hyperlink also-hidden="false" description="${exampleId}"
target="EditExample">
<parameter param-name="exampleId"/>
</hyperlink>
</field>
<field name="exampleName" title="${uiLabelMap.CommonName}"
sort-field="true"><display/></field>
<field name="exampleTypeId"
title="${uiLabelMap.CommonType}"><display-entity
entity-name="ExampleType"/></field>
<field name="statusId"
title="${uiLabelMap.CommonStatus}"><display-entity
entity-name="StatusItem"/></field>
<field name="description" title="${uiLabelMap.CommonDescription}"
sort-field="true"><display/></field>
</form>
{code}
> PATCH to enable NOT-IN operator to performFind
> ----------------------------------------------
>
> Key: OFBIZ-4815
> URL: https://issues.apache.org/jira/browse/OFBIZ-4815
> Project: OFBiz
> Issue Type: Improvement
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Daniel Riquelme
> Priority: Minor
> Labels: patch
> Fix For: SVN trunk
>
> Attachments: OFBIZ-FindServices_NOT-IN.patch
>
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> This patch will enable NOT-IN operator to the performFind service.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira