Session Browser: user defined filteres - how to apply them ?

Toad for Oracle & DevOps Toolkit
1

Hi there

I’m on 12.5.1 of TOAD

I able able to define a user defined filter ie

SELECT * FROM V$SESSION s

WHERE

(

s.USERNAME = ‘MST’

)

And I can press the test button - and it works fine.
How do I apply the filter from the sessionbrowser “filter button” ?
I want to be able to use all user defined filters - with the lovely layout of the session browser

Regards
Mette

1 Like
2

When you created your filter, you had to give it a name. Just choose that name in the “Filter:” dropdown on the Session Browser. It will apply the filter when you choose it.

3

But thats's jut the thing

In the dropdown there is only the 3 fixed filters.

See attached pictures of the dropdown - and of the other 13 filters.

/Mette

in_051.jpeg

in_052.jpeg
in_052.jpeg719×398 26.4 KB

From: bounce-jdorlon@toadworld.com
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] Session Browser: user defined filteres - how to apply them ?
Date: Thu, 14 Aug 2014 16:55:03 +0000

RE: Session Browser: user defined filteres - how to apply them ?

Reply by John Dorlon
When you created your filter, you had to give it a name. Just choose that name in the "Filter:" dropdown on the Session Browser. It will apply the filter when you choose it.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

4

I didn’t see any attachments, but will you send me your TOAD_SESSBROWFILTERS.Ini file? I think there is something wrong in it. You can send to john.dorlon@quest.com

5

I have attached the pictures from toadworld.com instead :slight_smile:
/Mette

From: bounce-jdorlon@toadworld.com
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] Session Browser: user defined filteres - how to apply them ?
Date: Thu, 14 Aug 2014 20:31:04 +0000

RE: Session Browser: user defined filteres - how to apply them ?

Reply by John Dorlon
I didn’t see any attachments, but will you send me your TOAD_SESSBROWFILTERS.Ini file? I think there is something wrong in it. You can send to john.dorlon@quest.com

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

6

Weird - after I posted my last message, the pictures showed up! You care clicking the wrong “filter” dropdown. Use the one on the main Session Browser toolbar, where it says “Filter” and the selected choice in your screenshot is

7

Thanks a million - I would never have found it … there are sooo many icons nowadays :wink: