To address the issue of the first 'OR', you will need duplicate active
links to set the tmpQuery field. The first one will run if tmpQuery =
$NULL$, then set tmpQuery = "'LOCATION' = $tmpChar$"
The second one will run if tmpQuery != $NULL$, then go ahead and do the
set fields below of tmpQuery = $tmpQuery$ + " OR 'LOCATION' = "........
To address the second issue, you might try changing the Run-If from
If $tmpLocation$ != $NULL$ AND $tmpLocation$ != " "
To
If $tmpLocation$ LIKE ("%" + "|" + "%")
I think this might work, since you will always have a | symbol at the
end of your country strings, even if the user selects only one country.
Look into it and see if it will work. If it won't let us know and I'm
positive we can come up with something.
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 Micheal Gere
Sent: Monday, August 27, 2007 2:57 PM
To: [email protected]
Subject: Re: Table Field qualification
**
Hi Gary
Firstly thanks for your code...I tried to play with the syntax and I
think I am almost there in making it work. I think there is some change
required in the second active link of the guide. Appreciate your help if
you can figure out something.
Run If: ( 'tmpLocation' != $NULL$ ) AND ( 'tmpLocation' != " " )
Action 1: Set fields
tmpQuery = ((($tmpQuery$ + " OR 'LOCATION' = ") + """") + $tmpChar$) +
""""
Action 2: Go To Guide Label
When I select the value in the LOCATION field = Toronto | Houston |
Sacramento |
Then I get the following result
tmpchar = Sacramento
tmpQuery = OR 'LOCATION' = " Toronto " OR 'LOCATION' =
"Houston"
Couple of questions:
1. How do we get rid of the OR at the beginning
2. The tmpQuery doesn't seem to get the third value. I looked at
the log and it doesn't fire the Active link since $tmpLocation$ != " "
Thanks
Mike
On 8/21/07, Opela, Gary L Contr OC-ALC/ITMA
<[EMAIL PROTECTED]> wrote:
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: [email protected]
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] <mailto:[email protected]> ] On
Behalf Of Micheal Gere
Sent: Tuesday, August 21, 2007 11:31 AM
To: [email protected]
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"
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
