Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: pass (nike.apache.org: local policy includes SPF record at
 spf.trusted-forwarder.org)
MIME-Version: 1.0
In-Reply-To: <52E7DEAB.90709@sandglass-software.com>
References: 
 <CALTe27KRLU7YdL=Vbkw5M70Ps=L5DbZgBaVSKq2tbOpRbfRDQA@mail.gmail.com>
	<52E7DEAB.90709@sandglass-software.com>
Date: Tue, 28 Jan 2014 12:17:24 -0500
Message-ID: 
 <CALTe27JGij_3CotnY30LzfUp_kmy+Eb1mtDTmikFULm1NBx66g@mail.gmail.com>
Subject: Re: PerformFind With In Clause ??
From: Justin Dagostino <justin@thecools.com>
To: user@ofbiz.apache.org
Content-Type: multipart/alternative; boundary=e89a8ff1c6b276868804f10aff5d

--e89a8ff1c6b276868804f10aff5d
Content-Type: text/plain; charset=ISO-8859-1

Thanks Adrian.

How about the first part to this question?  :)

Can performFind be used to find based on an 'or' set of criteria?  If so,
how?
Again, I tried suffixing the param name with "_in", but that didn't seem to
do anything.


Any ideas?


---
*Justin Dagostino*
Director Of Engineering
TheCools.com


On Tue, Jan 28, 2014 at 11:45 AM, Adrian Crum <
adrian.crum@sandglass-software.com> wrote:

> The noConditionFind parameter controls if results are returned when there
> are no query parameters. The purpose is to prevent large result sets being
> returned accidentally.
>
> So, if you invoke the service with no constraints:
>
> 1. noConditionFind = "Y" returns all records
> 2. noConditionFind = "N" returns no records
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>
>
> On 1/27/2014 6:11 PM, Justin Dagostino wrote:
>
>> If I wanted to use perform find to query for a list of criteria as an 'or'
>> or 'in', how do we do this in "inputFields"?
>>
>> Also, I don't really know what noConditionFind means..seems to only come
>> into play for filter by date.
>>
>> I tried suffixing the field with '_in', but that didn't seem to work.
>>
>> For example:
>> Perform Find for product IDs: 101, 102, and 103
>>
>>  From Webtools 'run service':
>> inputFields={productId_in = 101, productId_in = 102, productId_in = 103}
>> noConditionFind=Y
>> Returns 932 items
>>
>> inputFields={productId = 100}
>> noConditionFind=Y
>> Returns 932 item
>>
>> inputFields={productId = 100}
>> noConditionFind=N
>> Returns 0 items
>>
>> FYI... The performFind service seems to behave differently than however
>> the
>> FindGeneric Webtools feature works as expected:
>> /webtools/control/FindGeneric?entityName=Product
>> Specify productId = 101
>> Returns 1 item
>>
>>
>> Any insight would be very helpful.  Thanks.
>>
>>
>> ---
>> Justin
>>
>>

--e89a8ff1c6b276868804f10aff5d--