Re: Problem with EXTERNAL() in search menu
Hi,
Can you email screenshot of your menu from admin tool.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
- Original Message -
From: "Joe Castleman"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Wednesday, April 08, 2009 10:22 AM
Subject: Re: Problem with EXTERNAL() in search menu
Well, it seems to be doing that by itself (and for some reason it no
longer changes 'Status' to $7$). If I don't use the dollar signs, it
won't refer to the current form. I thought the single-quotes would
force it to check against the menu's source form, which I don't want
to do.
Again, the same qualification does what I want it to do (and keeping
the structure I intended) if I use it in a Table Field qualification.
Thanks for your response,
Bill B.
On Tue, Apr 7, 2009 at 9:17 PM, Leonard Neely - FOJ
wrote:
Bill,
I think your qualification needs to be structured as follows:
('Status' = "Active") AND (EXTERNAL('536870930')) AND
(EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
Note: No Dollar Signs
HTH
Leonard Neely
Column Technologies
___
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"
Re: Problem with EXTERNAL() in search menu
Well, it seems to be doing that by itself (and for some reason it no
longer changes 'Status' to $7$). If I don't use the dollar signs, it
won't refer to the current form. I thought the single-quotes would
force it to check against the menu's source form, which I don't want
to do.
Again, the same qualification does what I want it to do (and keeping
the structure I intended) if I use it in a Table Field qualification.
Thanks for your response,
Bill B.
On Tue, Apr 7, 2009 at 9:17 PM, Leonard Neely - FOJ
wrote:
> Bill,
>
> I think your qualification needs to be structured as follows:
>
> ('Status' = "Active") AND (EXTERNAL('536870930')) AND
> (EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
>
> Note: No Dollar Signs
>
> HTH
> Leonard Neely
> Column Technologies
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: Problem with EXTERNAL() in search menu
Bill,
I think your qualification needs to be structured as follows:
('Status' = "Active") AND (EXTERNAL('536870930')) AND
(EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
Note: No Dollar Signs
HTH
Leonard Neely
Column Technologies
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Bill Bookers
Sent: Tuesday, April 07, 2009 5:22 PM
To: arslist@ARSLIST.ORG
Subject: Problem with EXTERNAL() in search menu
Howdy,
I have a problem using the EXTERNAL() operator in a search menu
qualification. I set up my qualification like this:
'Status' = "Active" AND (EXTERNAL($536870930$)) AND
(EXTERNAL($536870931$)) AND (EXTERNAL($536870934$))
Yesterday when I tested this, it worked. (At least, that's how I
remember it.) Right now, when I open the same menu, the same menu's
qualification now looks like this:
($7$ = "Active" ) AND (EXTERNAL('536870930')) AND
(EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
Note that the single-quotes around 'Status' have changed to dollar
signs (i.e. field ID for the current form), while my other fields'
dollar signs have changed to single quotes. Obviously the menu no
longer works as I had intended.
If it makes any difference, the "dollar sign" fields refer to
display-only fields on a display-only form. Note also that the exact
same qualification works in a table field on the same display-only
form.
I have tried re-writing my qualification and saving it again, but now
it changes every time I open it back up.
Any ideas what is making this change, and why?
Specifications:
ARS 7.1.00 Build 200708221849
Oracle 10g (remote DB)
Win2003 Server, SP2
Thanks in advance,
Bill B.
___
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"
Problem with EXTERNAL() in search menu
Howdy,
I have a problem using the EXTERNAL() operator in a search menu
qualification. I set up my qualification like this:
'Status' = "Active" AND (EXTERNAL($536870930$)) AND
(EXTERNAL($536870931$)) AND (EXTERNAL($536870934$))
Yesterday when I tested this, it worked. (At least, that's how I
remember it.) Right now, when I open the same menu, the same menu's
qualification now looks like this:
($7$ = "Active" ) AND (EXTERNAL('536870930')) AND
(EXTERNAL('536870931')) AND (EXTERNAL('536870934'))
Note that the single-quotes around 'Status' have changed to dollar
signs (i.e. field ID for the current form), while my other fields'
dollar signs have changed to single quotes. Obviously the menu no
longer works as I had intended.
If it makes any difference, the "dollar sign" fields refer to
display-only fields on a display-only form. Note also that the exact
same qualification works in a table field on the same display-only
form.
I have tried re-writing my qualification and saving it again, but now
it changes every time I open it back up.
Any ideas what is making this change, and why?
Specifications:
ARS 7.1.00 Build 200708221849
Oracle 10g (remote DB)
Win2003 Server, SP2
Thanks in advance,
Bill B.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
