Yup.. that was my next step.

Thanks again.

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


On Tue, Jan 28, 2014 at 12:21 PM, Adrian Crum <
[email protected]> wrote:

> Unfortunately, the performFind service is poorly documented. The best
> approach would be to reverse-engineer one of the "Find" screens in the OOTB
> back office applications. Locate a screen that does something similar to
> what you are trying to do, then trace the HTML FORM action to the
> controller, then to the event, etc. Look at how the HTML FORM is composing
> the request parameters for the SQL IN behavior.
>
>
> Adrian Crum
> Sandglass Software
> www.sandglass-software.com
>
> On 1/28/2014 12:17 PM, Justin Dagostino wrote:
>
>> 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 <
>> [email protected]> 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
>>>>
>>>>
>>>>
>>

Reply via email to