Gary hit the nail on the head. If you are going to combine those, you will also want to add an " AND " appending to the already existing external qual prior to adding more to it. I would put that as the first set fields in each active link that Gary described.
Regards, YHK On Tue, Mar 3, 2009 at 12:06 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH < [email protected]> wrote: > Easy: > > For ease of discussion, let's say your parameter fields are called p1, > p2, p3, p4, p5. > Now, you need to create a display only field called tmpQual. > > First, create an active link or filter that calls a guide to set the > tmpQual field. The guide will contain the following active links or > filters. > > Active Link 1: > Run If p1 is not $NULL$ > Sets tmpQual = "'Serial Number' = " + $p1$ > > Active Link 2: > Run If p2 is not $NULL$ and tmpQual is not $NULL$ > Sets tmpQual = $tmpQual$ + " AND 'ci name' = " + $p2$ > > Active Link 3: > Run if p2 is not $NULL$ AND tmpQual is $NULL$ > Sets tmpQual = "'ci name' = " + $p2$ > > Active Link 4: > Run if p3 is not $NULL$ and tmpQual is not $NULL$ > Sets tmpQual = $tmpQual$ + " AND 'company name' = " + $p3$ > > Active Link 5: > Run if p3 is not $NULL$ and tmpQual is $NULL$ > Sets tmpQual = "'company name' = " + $p3$ > > And so on, you'll need to create a few more to get each field taken care > of. > > The last thing you want to do is perform a table refresh. Basically, > your criteria on your table will just be EXTERNAL($tmpQual$) > > Make sure to clear tmpQual and re-run the guide if the user makes a > change to any of the five fields. > > You also might have to do some special escaping because of the single > quote within the double quote. Sometimes I do and sometimes I don't. > > Hope this helps. > > > Thanks, > > Gary Opela, Jr. > Sr. Remedy Engineer > Avaya Phone Admin > RSP Cert, Sec+ > 405 739 7006 x30043 > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of lakhes > Sent: Tuesday, March 03, 2009 10:55 AM > To: [email protected] > Subject: How to do this? > > ** > I have 5 parameter fields I need to build a external qualification using > these 5 parameter fields > First I need to check if they are null or value in there then then i > need to build a external qualification of the table using all the one > which has non null values. > > For ex: parameter fields are serial number, ci name, company name, > manufacture name and product category if any of them have value I need > to search asset table with external qualification > > Any suggestions ? > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > html___ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
