It's true
'ISBNinRemoteForm' LIKE (( "%" + $ISBNtoSearch$) + "%")
won't work, but it will if you reverse the fields:
$ISBNtoSearch$bLIKE (( "%" + 'ISBNinRemoteForm') + "%")
HTH,
Joel
*************************
Joel D. Sender
Director of Western Operations
QMX Support Services, Inc.
www.QMXS.com
[EMAIL PROTECTED]
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of David Sanders
Sent: Tuesday, July 25, 2006 7:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: How to perform a single search of multiple items and return all
the matching records???
It does work George. Here's a small def file and data in a zip file to
demonstrate. Rename the attachment to .zip extension.
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of George Barsan
Sent: Tuesday, July 25, 2006 2:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: How to perform a single search of multiple items and return all
the matching records???
Hi Brian,
Yep, if you have several ISBN's in one field and try to run search for
'ISBNinRemoteForm' LIKE (( "%" + $ISBNtoSearch$) + "%")
it won't work. I would do it differently:
1) Create a transaction form ("Book Search"), in which one record is
created per Query
2) Behind that form, build a work flow that:
* assigns a unique ID to each search
* walk through the ISBNtoSearch field and generate one record per
ISBN-number in a second form (i.e. "Book Search Request" storing the
unique search ID there as key)
3) Generate a join form between the "Book Search Request" form and the
one where all known ISBN's are stored
4) Create a table and using the join form created in step 3 to present
only records which exist in both forms for that specific search
5) Create i.e. an escalation which cleans up and removed searches &
search requests older then 24h
George
On 7/25/06, Sokol, Brian <[EMAIL PROTECTED]> wrote:
> Hi David,
>
> I tried this and it would not return anything if I put the ISBN List
> field first in the qualification. If I reverse the order it will return
> an answer but only if there is a single entry in the ISBN List field. If
> I enter more than 1 value it does not return any records.
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of David Sanders
> Sent: Monday, July 24, 2006 4:39 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: How to perform a single search of multiple items and return
> all the matching records???
>
> Hi Brian
>
> I think you should be able to do this with a simple table field
> qualification. Say you have a form with a field containing the string
> of
> ISBN values in a field called ISBN List, and a table field pointing to
> your
> book records which have an ISBN data field.
>
> Normally for a table field you would have a qualification like (
> 'DataTableField' LIKE ( $CurrentFormField$ + "%" )). In this case you
> need
> to turn the qualification round, like
>
> $ISBN List$ LIKE (( "%" + 'ISBN') + "%" )
>
> To allow the search to ignore the dashes, you would need a 'shadow'
> field on
> your book asset record (set by a filter) containg a stripped version of
> the
> ISBN. Then you could change the table field qualification to
>
> ($ISBN List$ LIKE (( "%" + 'ISBN') + "%" )) OR ($ISBN List$ LIKE ((
> "%" +
> 'ISBNStripped') + "%" ))
>
> It won't be the most efficient query, but it should work
>
> HTH
>
>
> David Sanders
> Remedy Solution Architect
> Enterprise Service Suite @ Work
> ==========================
> ARS List Award Winner 2005
> Best 3rd party Remedy Application
>
> tel +44 1494 468980
> mobile +44 7710 377761
> email [EMAIL PROTECTED]
>
> web http://www.westoverconsulting.co.uk
>
>
>
> On 7/24/06, Sokol, Brian <[EMAIL PROTECTED]> wrote:
> > I have been asked to replace a Filemaker Pro database with a Remedy
> > application. We are a book publisher and this application is used to
> > request digital assets by their ISBN number. Each asset has their own
> > unique ISBN number. In Filemaker they can cut and paste a long list of
> > ISBN numbers and search using that list. The results will show every
> > match made against a table of about 60K records. Additionally the ISBN
> > list may be formatted with dashes or unformatted with just the number.
> >
> > Is something like this possible?
> >
> > Brian Sokol
> > Manager, Desktop Services
> > Scholastic Inc.
> > 212-343-7698
> > [EMAIL PROTECTED]
> > <http://www.scholastic.com>
> >
> >
> ________________________________________________________________________
> ____
> ___
> > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
> >
>
> ________________________________________________________________________
> ____
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
>
____________________________________________________________________________
___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
