Looking in this report. You can see that when i am using a date where there is record is not appearing. But when i will select a date after date, Then it will show me that record. Will also give the query for the data below. Please assist. Thanks.
SELECT DISTINCT ROWNUM REC,LT.SYSTEMDATE DATE_REVISED,LT.TRANS_DATE TRADE_DATE, LT.TRADERID OPERATOR_NAME,
CA.ACCOUNT_OFFICER ACCOUNT_OFFICER, TD.TRANSTYPE TRANSACTION_TYPE,TYPE INVT_TYPE,
LT.SECURITYSYMBOL SECURITY_NAME,GS.RBI_SYMBOL CUSIP,PORT.PORTNAME PORTFOLIO_NAME,
LT.FIRST_LEG_QUANTITY QUANTITY_UNITS,LT.FIRST_LEG_AMOUNT TOTAL_AMOUNT,
LT.DEAL_NO TRANS_NUMBER, lt.dealer_ticket_no Dealer_Ticket_No
FROM log_transact lt, (SELECT DISTINCT operation, portcode, dealer_ticket_no, deal_no, entitycode, gross_amount, net_consideration, userid, operationdatetime FROM log_portallocation) pt, rpt_client_account ca, tbl_portmast port, transactiondef td , global_security gs , additional_transact alt
WHERE lt.deal_no = pt.deal_no
AND lt.operation =pt.operation
AND lt.systemdate = pt.operationdatetime
AND pt.portcode(+) = port.portcode
AND port.fund_code = ca.pms_acno(+)
AND lt.transaction_type_code = td.trans_code
AND lt.securitysymbol = gs.securitysymbol
AND lt.deal_no = alt.deal_no(+)
AND pt.DEAL_NO = alt.DEAL_NO (+)
AND lt.operation IN ('MODIFY')
[[and LT.SYSTEMDATE BETWEEN {{StartDate}} AND {{EndDate}}]]
order by lt.SYSTEMDATE desc