query question

[crsdev]

Hello friends,
When i run a query with this condition in sql developer i get results
where to_date(run_date) = to_date(sysdate-3)

but when i copy and paste the same query in CR add command i don't get any results, doesn't show any errors either.

can anyone please tell me why this might be happening.

BOXIR2, CRXIr2,

 

[synapsevampire]

It should error at least, you don't even have a select clause in it.

You can do the same without a Command Object in the Report->Selection Formula->record using:

{table.date} = currentdate-3

-k

 

[crsdev]

synapse,

this is my actual query

select a, b, c
from schema.sometable
where to_date(run_date) = to_date(sysdate-3)
and
( a IS NOT NULL
or b IS NOT NULL
or c IS NOT NULL)

this query runs fine in sql developer but not in CR.

the solution you proposed is what i am usnig now but just wondering why this query didn't work in CR.