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: 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
