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
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
