Okay, my suggestion is that whenever the user chooses a location, on
menu/row choice, set location = location + X where X is some delimiter
you choose.
Next, before you do the table refresh, you need to see if that delimiter
is in the location field, if it is, then use substr and strstr to parse
out all of the values in that field and create a dynamic query.
So, let's say that location = "Toronto | Houston | Sacremento |"
You would want the table qualification to state: ('Location' = "Toronto"
OR 'Location' = "Houston" OR 'Location' = "Sacremento") AND ....
You will need a guide that contains the following active links:
First Active Link:
Set tmpLocation = $Location$ This will allow you to
parse Location without modifying what the user put in the Location field
Call guide below:
Guide:
First Active Link:
Set tmpInt = STRSTR($tmpLocation$, "|")
This gives you the location of the first | symbol,
assuming you use | as your delimiter.
Set tmpChar = RTRIM(SUBSTR($tmpLocation$, 0, $tmpInt$)))
This will give you your first location, up to the first
Pipe symbol
Set tmpLocation = LTRIM(SUBSTR($tmpLocation$, $tmpInt$))
This will give you the rest of the location, after the
first
Second Active Link:
If $tmpLocation$ != $NULL$ AND $tmpLocation$ != " "
Set tmpQuery = $tmpQuery$ + " OR 'Location' = " + $tmpChar$
GOTO Guide Label Start
Third Active Link: (this one is outside of the guide
Refresh Table field
Then the qualification on your table field will be:
(EXTERNAL($tmpQuery$) AND ('POSITION' =
$POSITION$))
Now granted, I didn't note in detail everything that needs to happen.
For instance, the first time your active link rusn that sets the
tmpQuery field, you will not want to have OR at the beginning of the set
fields statement. You will also need to put () around your array of OR
statements for the Location part of the query.
Plus the syntax might be off just a bit, you'll have to play with it.
It's been probably a year since I've used any of the functionality
listed above, and I'm just trying to write it from memory.
Thanks,
Gary Opela, Jr
Sr. Remedy Developer
Leader Communications, Inc.
405 736 3211
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Tuesday, August 21, 2007 12:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: Table Field qualification
Why not just change the table qualification to $LOCATION$ LIKE "%" +
'LOCATION' = "%" AND $POSITION$ LIKE "%" + 'POSITION' + "%"
??
Sorry if I'm misunderstanding the issue and oversimplifying it.
Norm
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Micheal Gere
Sent: Tuesday, August 21, 2007 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Table Field qualification
**
Hello Everyone
I hope somebody can answer this...
I have a form with the following fields
LOCATION - A character field with a menu append
POSITION - A character field with a menu append
TABLE - A table field whose source form is a JOIN form of employee
location and employee position. This table gets refreshed and fetches
the
data based on the user selection of LOCATION and POSITION.
Table qualification is (( 'LOCATION' = $LOCATION$) AND ('POSITION' =
$POSITION$))
Now when the menu is appended and I have multiple values in the LOCATION
and POSITION fields, how would I set the table qualification ?
I am guessing it can be done using some External qualification but not
sure how ?
Thanks in advance for your time
Gere
__20060125_______________________This posting was submitted with HTML in
it___
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
