You can't get it by doing it that way because the entries do not exist in the database. The only way you can do it is by a set fields to a display only field of the records that did not show up.
Here is how I would do it: 1. Copy the String to a display only temp field ztmpISBNLIST = $ISBN List$ Using a table loop: While $ztmpISBNLIST$ != $NULL$ AND $ztmpISBNLIST$ != ' ' 2. I would parse the entry and set a temporary field: ztmpField1 = SUBSTR($ztmpISBNLIST$,0,STRSTR($ztmpISBNLIST$,' ')) 3. I would then reduce the list by 1 value: SUBSTR($ztmpISBNLIST$, STRSTR($ztmpISBNLIST$,' '),LENGTH($ztmpISBNLIST$)) 4. I would then check to see if the value exists in the results list: If $ztmpField1$ != 'column1' where column1 is the ISBN value in your results table. Set Fields to your Results field (Display-only text field) $Results Field$ = $ztmpField1$ + '|' + $Results Field$ By the way you can use a similar loop to create the qual. When you loop through set a field to create your qualification. You can use the "EXTERN" feature to create the query externally. Your query would be much faster because it would look like: 1111='ISBN NUMBER' OR 2223 = 'ISBN NUMBER' etc. Hope that helps. Thanks, Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, September 08, 2006 3:33 PM To: [email protected] Subject: Re: How to perform a single search of multiple items and return all the matching records??? Hi David, Thanks for the quick response. This is giving the same results I was getting. If I enter 12345 for the ISBN number and this does not match my database, it is returning every record from your xBookDetails table. What I need to accomplish is to paste a list of ISBNs into a character field, click on a button and populate 2 tables. Table 1 shows all the matches. This works now. Table 2 will show only those ISBNs that I was searching for and did not find. So for example if your xBookDetails table had records for the following ISBNs: 11111 22222 33333 44444 And I searched for the following: 22222 44444 55555 66666 My results should look like this: Table 1 (matches): 22222 44444 Table 2 (non-matches): 55555 66666 What I currently get for a non-match is: 11111 33333 Hope this explains this better. Thanks Brian -----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: [email protected] 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
