Hi,
I have created an ad-hoc report to show all CM work orders based on the Reported Date parameter range which should also show all statuses and changed by user id.
But the report is not showing the CLOSE status workorders. I've also removed the historyflag=0 condition from the where clause from back-end but no luck. There is no data restriction as I can see the CLOSE records by clicking ALL RECORDS query in the List Tab.
Is this the default behavior of the adhoc reports?
Thanks,
Shahid Saeed Khan