Good Afternoon John,
I should have told you about this earlier; I even use a work around.
I have a named Query as follows (commented out where):
SELECT CONT_EMAIL, common…(…) “Grantee_Password”,
/* test_passwords.sql */
DATE_PW_CHANGED, TIMES_REMINDED, PROG_CODE, INST_TYPE, START_PREF, ZIP, rcip_no, w2w_password,
–ROWID, RCIP_NO, SEQ_NO, W2W_PASSWORD,
–W2W_PIN, CONT_NAME, ADDR1,
–ADDR2, CITY, STATE,
–ZIP, CONT_PHONE, CONT_FAX,
–CONT_EMAIL,
DATE_DELAYED,
DATE_PW_CHANGED,
DATE_LAST, DATE_NOTIFIED, DATA_ADDED_BY,
NOTIFICATION_SENT_BY, PRIM_CONTACT, RCIP_NAME,
CONT_TITLE, RCIP_TYPE, --START_PREF, DATE_DELAYED, TIMES_REMINDED,
DATE_PW_CHANGED
FROM COMMON.WHO_ARE_YOU
natural join COMMON.WHO_ARE_YOU_CHANGES
–Where
–lower(CONT_EMAIL) = ‘wickliffe.larry@dol.gov’ and
–NOTIFICATION_SENT_BY IS NOT NULL
– AND DATA_ADDED_BY IS NOT NULL
–AND
–W2W_PASSWORD IS NOT NULL
–AND date_last > to_date(‘12/01/2015’, ‘MM/DD/YYYY’)
ORDER BY DATE_LAST DESC NULLS LAST
If I apply a named filter, the filter replaces the entire query (the filter takes on the Query name, too):
WHERE
cont_email = ‘l.wickliffe@hush.com’
Since there is no select …
from …
this fails.
Larry
703-508-4945
PS. My work around is to create extra named query with the different filters.
PSS. Thank you! Still love it!