Gary, (and maybe Joe too)
I actually think the "date" stuff your seeing is actually related to
these details...
Ref: Workflow-Objects-700.pdf Pg 199
"
For example, if you have a table field with a qualification of
EXTERNAL($Qualify Field$)
and Qualify Field is a character field with a value of
('Create Date' < $TIMESTAMP$) AND ('Login Name' = $USER$)
the table field will not produce expected results when refreshed. The
keywords will expand, producing a qualification such as
('Create Date' < 05/22/02 11:00:34 AM) AND ('Login Name' = Demo)
This is not a valid query, since the date/time and character values
are not enclosed in quotation marks. To prevent the keywords from
expanding, write the qualification like this:
('Create Date' < $\TIMESTAMP$) AND ('Login Name' = $\USER$)
In forms viewed on the Web, if EXTERNAL() references a field that
contains a qualification such as $Date 1$ <= 'Date 2', you must add
double quotation marks around $Date 1$, like this:
"$Date 1$" <= 'Date 2'.
Note: In BMC Remedy User, the EXTERNAL operator reads date and time
string from the server's time. On the web, the EXTERNAL operator reads
the date and time string from client's time zone.
"
HTH
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 8/21/07, Opela, Gary L Contr OC-ALC/ITMA
<[EMAIL PROTECTED]> wrote:
> Joe, try the following:
>
> Change the table qualification to (EXTERNAL($ztmpQualification$)) AND
> ('Start Date' <= $DATE$)
>
> Create display only field ztmpQualification.
> Create active link that sets ztmpQualification = "('Queue' = $Queue$)"
> Create active link that does a table refresh
>
> You might have to end up setting ztmpQualification = "('Queue' =
> $Queue$) AND ('Start Date' < = $\DATE$)" and your table field
> qualification just to EXTERNAL($ztmpQualification$)
>
> For some reason, a table field on a display-only form doesn't seem to
> parse correctly $Field$ although the EXTERNAL() function does.
>
> It is also worth noting that if you are pulling in data from 'Queue' and
> there is the event that the value could be $NULL$, you need to check for
> $NULL$ and for "". I know you aren't doing that here, but for instance
> if you had 'Queue' != $NULL$ on there, you need to change this to
> ('Queue' != $NULL$) AND ('Queue' != ""). If the user puts value in the
> 'Queue' field and then backspaces over it, on a display only form, I've
> noticed that the value is no longer $NULL$, but the empty set, "".
>
>
>
> 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 Joe D'Souza
> Sent: Monday, August 20, 2007 11:30 PM
> To: arslist@ARSLIST.ORG
> Subject: Bug with comparing a Date field to the $DATE$ keyword in a
> table fields qualification???
>
> **
> Listers,
>
> I am literally pulling my hair over this.. I am on ARS 7.0.1 Patch 003
> on Windows 2K3SP2 and MS-SQL 2K5SP2..
>
> I have one data form and another display only form. In the data form
> among other fields I have a character field called Queue and another
> Date field (not Date/Time).
> I have a simple qualification using a Date field in the qualification on
> a Table field. I copied the qualification below.
> ('Queue' = $Queue$) AND ('Start Date' < = $DATE$)
> This returns all the records when the table field is refreshed after
> having a value of "Test Queue" in the Queue field irrespective of the
> value of the Start Date in the underlying data form when it should have
> been returning only 1 record on the table field.
>
> On the User Tool however if I search the form using advanced search
> ('Queue' = "Test Queue") AND ('Start Date' <= 8/20/2007)
> I get just one record as I should given my data.
>
> Is this a known bug with using a Date field on a table fields
> qualification??
>
> Joe
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
