Toad World® Forums

Filter title clears every time I change the filter with and or OR buttons

Good afternoon TOAD team,

This is weird, happens on my production laptop in TOAD 14.1, but not on my dev VM in TOAD 14.1 or 14.2 beta. Very annoying and repeatable.

I'm been doing this for decades and the new "feature" is to clear the filter name every time I use the Add to Filter (And) or Add to Filter (Or) buttons to assist me in writing the filter. As shown below:

Larry

Hi Larry,

I don't think this is a new problem. I can reproduce it in both 13.1 and the current beta. It won't happen if one or more sort column is defined on the "Sort" tab.

I'll fix it for the version after 14.2

-John

Good afternoon John,

Thank you!

You see recent first in the title; it is sorted on a TIMESTAMP(6) field, LOG_DATE:

image008.png

SELECT

ROWID, CLIENT_IP, ENVIRONMENT, PASSWORD_TRIED,

ACTION_REQ, SUCCESS_FAIL, LOG_DATE,

REMARKS

FROM COMMON.ACCOUNT_LOGIN_LOG

WHERE

-- Recent first SailPoint

CLIENT_IP IN ('10.49.2.9', '10.48.36.225', '10.48.36.226', '10.48.36.227', '10.48.36.228')

ORDER BY LOG_DATE DESC NULLS LAST

image001.png

image009.png

image010.png

image011.png

Hmm, I am only able to make the filter name get cleared by clicking "Add to filter" when there is no sort column set.

If you send me your user files folder and Create Table stmt for this table, I will try again. I don't need any table data.

Good evening John,

Not sure if I screwed up, but just sent the script for this table in reply to other other bug, pretty sure that was the wrong table and for that ticket.

Sorry, I'm a morning person. Monday I should be able to figure this out.

Larry