This question is answered

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

Follow / 14 Aug 2014 at 12:13pm

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

 

Replies

All Replies
  • Follow / 14 Aug 2014 at 5:54pm

    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.

  • Follow / 14 Aug 2014 at 9:24pm
    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

     

    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

    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.


  • Follow / 14 Aug 2014 at 9:30pm

    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@software.dell.com

  • Follow / 14 Aug 2014 at 9:32pm
    I have attached the pictures from toadworld.com instead :-)
    /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

    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@software.dell.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.


  • Verified Answer
    Follow / 14 Aug 2014 at 9:33pm

    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 <none>

  • Follow / 14 Aug 2014 at 9:42pm

    Thanks a million - I would never have found it ... there are sooo many icons nowadays ;-)