Greg,
This is just a shot in the dark....
try this:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= "$\NULL$" AND '7' <= "Pending"
OR (if the next one keeps the $NULL$ after saving the value try this form)
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= "$NULL$" AND '7' <= "Pending"
We have noticed that in some contexts the ARS server deails with
$NULL$ differently than "$NULL$". Maybe this is another case where the
quotes are needed?
We currently use:
Solaris: 2.9
ARS server: 6.3 patch 2
RDBMS: Sybase (12.x)
--
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 2/28/07, Greg Hale <[EMAIL PROTECTED]> wrote:
Working with ARS 6.3 patch 20 and HD 6 on Solaris with remote Oracle 10gr2
database.
I have run the following query on the Change Request Form:
('Category*' = "Testing Tools" OR 'Category*' =
"Remedy") AND 'ReleaseID' = $NULL$ AND 'Status*' <= "Pending"
and I get the expected results.
I now need to create a report with the same selection criteria. When I add
my report to the REPORT form and enter the above in the qualification it
doesn't work. The issue seems to be with the 'ReleaseID' = NULL check.
I tried using $\NULL$ and that just shows as "\NULL" and no records are
returned.
In the Report Form the Base Qualification shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= $\NULL$ AND '7' <= "Pending"
When I pull up the report the qualification shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= "\NULL" AND '7' <= "Pending"
If I manually select the qualification I need, it shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= $\NULL$ AND '7' <= "Pending"
It appears that whenever I use a $ in the Report Form's Base Qualification
the $ is replace with a double quote(").
What am I doing wrong?
Thanks,
Greg
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
