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
