sanketkumar.d ,
I'm speaking abou database, whatever you need to do, it's necessarily looking for database. The CA help us to don't make some mistakes but sometimes this happens, and all do you need is: know how DB works.
CALL_REQ
- ACT_LOG
- dateadd(ss, CALL_REQ.open_date, '19700101') > '20151001'
- CALL_REQ.type = 'R'
select *
from call_req
where dateadd(ss, open_date, '19700101') > '20151001'
and CALL_REQ.type = 'Rand status in ('OP', 'ACK')
Therefore you select some field where bring other table, how to find it?
On query panel, last icon :
You'll looking for "database select", can you see "alg" object/table?
Do you see more object than cr/call_req?
The fields are available on the same order than panel, try to remove some one where don't show cr object.
Regards
Tiago Macul