Hi,
I do not think that you can search directly in a Join-request-id like
that. Some clients might be able to decipher the entered string though.
If you look at the API, you can retrieve records, and in this case you
supply an array of the three ids in the correct order.
The simplest option, that should work across versions and clients, seems
to be to expose all three core request id field, and do a search in these
instead:
('Request ID1' = "000000000000931" AND
'Request ID2' = "000000000002548" AND
'Request ID3' = "000000000001520")
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi. Wouldn't you use the 'LIKE' instead of '=' in this case? Seems like
> Equal is not the correct operator if there are multiple Request ID's
> within
> the field.
> And why would there be multiple values within the Request ID anyway? It
> seems to be an incorrect assumption given the error message you are
> getting
> anyway.
> If you were to look at the data of your new join form, via say
> ARUtilities'
> SQL function (which I just love now) maybe you would see what the field
> data looks like.
>
> use a SQL like this (if your database is MS SQL Server)
>
> SELECT Request_ID,someotherfield, another_field FROM My_Join_Form
>
> and see what it looks like. I'm not online right now so I can't test it
> on
> a join form for you. plus I'm not on the same version...
> Hope this helps anyway. :)
>
>
> On Mon, Jun 4, 2012 at 5:53 PM, Warren R. Baltimore II <
> warrenbaltim...@gmail.com> wrote:
>
>> **
>> ARS 6.3 patch 23 running on Solaris (SunOS 5.1)
>>
>> I have a join form that joins another join to AP:Signature.
>>
>> When I try to search against the Request ID using the following search:
>> 'Request ID' = "000000000000931|000000000002548|000000000001520"
>> I get no matching requests
>>
>> If I try searching directly in the field, I get: "ARERR [101] Entry ID
>> parameter value is longer than the maximum allowed length"
>>
>> I've submitted a ticket to BMC, but I thought I'd see who was faster!
>>
>> Any help would be most appreciated.
>>
>> --
>> Warren R. Baltimore II
>> Remedy Developer
>> 410-533-5367
>> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
>
>
> --
> *Nancy Tietz*
> Application Systems Analyst Programmer
> AIS - FIN / ITSM
> Information Technology Services
> University of Michigan
> x30515
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
