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"
