Let me add my voice to the 30 or so people who will respond to this one. By
now, this must certainly be considered a frequently asked question. (That's a
hint, Mr. Bloom.)
If you save a keyword in a character field, AR System will convert it to a
static value. So, $USER$ becomes something like "jsmith" and $NULL$ becomes...
well, nothing. So it's a real conundrum -- how do you express a keyword as a
constant without AR System converting it? Remedy addresses this problem by
letting you "escape" the keyword with a backslash after the first dollar sign.
For example, if you set "$\USER$" in character field, it will remain without
conversion, and you can still use it as if it were a keyword. Thus, you can
enter:
( OR ‘SPAR Reference’ != $\NULL$ )
...and AR System won't convert the keyword on saving the entry. Yet you can
still use this qualification string (backslash and all) in an EXTERNAL() query.
Tim Widowfield
[EMAIL PROTECTED]
v: 937-878-9045
f: 937-878-9055
m: 937-369-7012
http://www.widowfield.com
----- Original Message ----
From: "Nicoll, Alan" <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, October 10, 2006 4:07:03 PM
Subject: [ARSLIST] How to pass nothing
I have a user that wants to force their will on management and make them look
at SPAR Goals too every time they search for a goal and the owner of the Goal
form has agreed with them so all I have to do is implement this. My current
design is an Active Link firing on Search that attempts (fails) to add ( OR
‘SPAR Reference’ != $NULL$ ) to whatever string of search terms they are using
if the user doing the search is a manager and the Goal with the non-null ‘SPAR
Reference’ field is still unprioritized and a few other things. It fails
because I can’t figure out a way to pass in nothing ($NULL$) using a Set Fields
action. I’ve created a hidden field and set it with the $NULL$ and then
created two hidden fields and set one with $NU and the other with LL$ and
concatenated them in the Set Fields to the ‘SPAR Reference’ field but the
$NULL$ disappears every time.
So, how do I pass in nothing? If it’s impossible to pass nothing can anyone
think of another way to implement this ask: add a search term to every search
that meets other criteria?
Alan E (Nick) Nicoll
DocuSP Problem System Administrator
Xerox Corporation
Xerox Centre Drive, MS: ESC1-615
El Segundo, CA 90245
Phone 310 333-5081 Internal 8*823-5081
Fax 310 333-6898
[EMAIL PROTECTED]
XEROX
Technology Document Management Consulting Services
www.xerox.com
This email and any files transmitted with it are confidential and intended
solely for the use of the addressee. If you have received this email in error
please delete it. Any views or opinions presented in this email are solely
those of the sender and do not necessarily represent those of Xerox
Corporation. Finally, the recipient should check this email is authentic and
examine it for the presence of viruses. Xerox does perform virus checks but
cannot accept liability for any damage caused by any virus transmitted by this
email.
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
