ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Justin Dagostino <jus...@thecools.com>
Subject Re: PerformFind With In Clause ??
Date Tue, 28 Jan 2014 17:17:24 GMT
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
>>
>>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message