Good Afternoon TOAD team,
I'm sure this used to work; but Saturday at home on TOAD 13.0 it failed. I exported my setting and imported them into TOAD 13.2. I removed table alias, when I thought that may be the issue; but no change except making the code bigger. All I did was join another table in my custom query to use a related table, now the filters do not apply.
With the default query the custom filters work, and the filter updates the code in the query window. When I pick the custom query, the filters no longer make any change. The query stays the same as it was, as does the data displayed; the only change is the check box location on custom filters, even if I add a new custom filter. All that appears to work is changing the order, but that is not shown in the Query code window.
Default Query:
SELECT
ROWID, AUTHU_ID, USERID, USERID_OID,
AUTHASR_ID, ACCOUNTLOCKDATE, AUTHCHANGE,
AGENCY_ID, INSERTDATE, INSERTUSERID,
UPDATEDATE, UPDATEUSERID, RID
FROM EGRANTS.AUTHUSER
Custom Query:
-- With why changed
SELECT AUTHACCOUNTSTATUSREASONREF.REASON,
AUTHUSER.AUTHU_ID,
AUTHUSER.USERID,
AUTHUSER.USERID_OID,
AUTHUSER.AUTHASR_ID,
AUTHUSER.ACCOUNTLOCKDATE,
AUTHUSER.AUTHCHANGE,
AUTHUSER.AGENCY_ID,
AUTHUSER.INSERTDATE,
AUTHUSER.INSERTUSERID,
AUTHUSER.UPDATEDATE,
AUTHUSER.UPDATEUSERID,
AUTHUSER.RID,
AUTHACCOUNTSTATUSREASONREF.AUTHASRR_ID,
AUTHACCOUNTSTATUSREASONREF.REASON,
AUTHACCOUNTSTATUSREASONREF.REASON_DESC
FROM EGRANTS.AUTHUSER
LEFT OUTER JOIN EGRANTS.AUTHACCOUNTSTATUSREASONREF
ON AUTHACCOUNTSTATUSREASONREF.AUTHASRR_ID = AUTHUSER.RID
Larry