David this worked out great so thanks. One new wrinkle that was
introduced the other day. Not only do they want to see every ISBN that
matches, they want to see every ISBN that does not match. Any ideas?
-Original Message-
From: Action Request System discussion list(ARSList)
For anyone interested who had the attachment blocked, here is a link to the
sample def.
http://www.westoverconsulting.co.uk/downloads/sampleISBNSearch.zip
Regards
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==
ARS List Award Winner 2005
Best
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
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
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
Thanks David, you're totally right! Sorry, I was thinking too complicated.
On 7/25/06, David Sanders [EMAIL PROTECTED] wrote:
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
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
I tend to think that in Remedy, anything is possible, just some things
are more difficult than others.
Would your users be ok with entering the ISBNs individually (i.e. in a
dialog), clicking a button to send it to another form, and displaying
the currently entered ISBNs in a table field? Then
Brian,
Well... I see an option here
How about you walk the string?
If you can tell your users that every ISBN number must be on their own
line (hard return separated) then you could use a guide to loop over a
character field and fix up all the sub strings and at the same time
produce a nice
Yeah, EXTERNAL would work, too. Regardless of the solution used, the
most difficult part is going to be delimiting and validating the data
string. The users are going to have to do some of that themselves, as
you can't practically screen every potential problem type out with
workflow.
Rick
Cary/Rick,
The way it works now is a user sends a request for x# of ISBN records
listed in a spreadsheet. Staff here copy and paste the ISBN column from
the spreadsheet into a single field. They then search for all the hits
from the single field against our database. The spreadsheet could have
11 matches
Mail list logo