[ 
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="&quot;EXST_APPROVED&quot;.equals(statusId)" 
style="Validate"/>
        <alt-row-style use-when="&quot;EXST_CANCELLED&quot;.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="&quot;EXST_APPROVED&quot;.equals(statusId)" 
style="Validate"/>
        <alt-row-style use-when="&quot;EXST_CANCELLED&quot;.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

        

Reply via email to