Re: Auto-filter a la "Excel"?

[Holger Brands]

Benoit,

I've created an issue for your suggestion:
https://glazedlists.dev.java.net/issues/show_bug.cgi?id=450

If you would like to contribute your code you can attach it to
this issue.

Thanks,
Holger

>
> Hi *,
>
> Quick update: I have sorted most of my Swing basic problems (using a
> sub-class of JDialog to display the list), keeping 2 sets of data (available
> and selected). I can send the stuff over if required.
>
> One thing is missing... how to display a little icon on the header to say
> that it was filtered... Or may be change the header colour for that column
> only??? Suggestions?
>
> Thanks
>
> Benoit
>
>
>
> Benoitx wrote:
> >
> > Dear James & All,
> >
> > Thanks for replying. I went ahead and started on some exploratory work
 it
> > nearly works but the glitches that I am experiencing will surely show the
> > depth of my ignorance.  I have 2 types of issues, one with Swing and the
> > other with GlazedLists.
> >
> > First of all, the scope of this exercise.  I am using an extension to the
> > EventTableModel. When a user clicks (right button) on the jtable header I
> > would like a small JList to appear. By default everything should be
> > selected; when the user selects some items and press ok, the table will be
> > filtered. Our application is using Swing and MDI with the table created in
> > a JInternalFrame.
> >
> > I have a solution which is work-in-progress, you can see the current
> > result on:
> > http://www.objectlab.co.uk/jfree/jtable-filter.png
> >
> > SWING Issues
> >
> > 1/ Which container to use? For the panel with the JList? I have used a
> > JWindow as it was the only one that seemed working
(JFrame appears like
> > another window) Basically, how do you overlay a panel on top of a header
> > and part of the JTable?
> >
> > 2/ How to position the Window/Panel? I have picked up the MouseEvent point
> > but how can one detect the top-left corner of the COLUMN header?
> >
> > 3/ for some reason, I *had* to make the JWindow always on top (otherwise
> > it would disappear as soon as it gets clicked on).  This leads to some
> > ugly effect if you then bring another application on top
 as the little
> > filter panel stays on top of anything on your machine!!!
> >
> > 4/ I tried to add a focus listener on the JWindow and dispose of the
> > window when it loses the focus (reasonable assumption I guess) but the
> > JWindow does not pickup any focus event:
> > window.addFocusListener(new FocusAdapter() {
> >     public void focusLost(final FocusEvent e) {
> > window.dispose();
> >     }
> > });
> >
> > GLAZED LISTS Deisgn & Issues
> >
> > 1/ I wanted this functionality to be totally transparent, ie current users
> > of the EventTable would not need to do anything, so the idea was to
> > override the EventTableModel and give it a FilterList when it is created.
> > Unfortunately, once a list is given to an EventTableModel it appears that
> > there is no way to get back the list (the table should listen for events
> > in order to refresh the list of existing values)? The list is wrapped up
> > in a swingThreadSource transformed list
 Why can’t we get the source in
> > order to apply the filter?
> >
> > 2/ Current solution creates a sub-class of EventTableModel which creates a
> > FilterList and passes it to the EventTableModel, it also retains a link to
> > the FilterList and can give it to the MouseListener code on the table
> > header so that a Matcher can be applied to the filter list.
> >
> > 3/ on pressing the header, the column property name is found and we’re
> > using the Spirng BeanWrapper to fetch all valid data from the list, put
> > those in a Set (to remove duplicates). Once the list of items is prepared,
> > a new Matcher is created (also using a BeanWrapper to access values of
> > each beans given the column name).
> >
> > My questions really relates to the fact that usually one creates an
> > EventList, then a SortedList and gives the SortedList to the
> > EventTableModel.  Some of our tables have also a FilterList (with
> > textfield) but it is always a SortedList given to the EventTableModel
 so
> > we end-up with the possibility of having 2 filter lists on the dataset

> > and also having no way to use the FilterList from the table model outside
> > the table (say for a chart too).  It would be good if my sub-class of
> > EventTableModel could look at the list given and see if it is the result
> > of a FilterList
 and keep a reference to it

> >
> > As you can see my main issues are related to Swing
 any suggestion would
> > be welcome!
> > I have no problem sending the non-generic/hack code in order to design a
> > better solution

> >
> > Thanks a lot
> > Benoit
> >
> >
> >
> > James Lemieux wrote:
> >>
> >> Benoit,
> >>
> >>    No work has been done specifically to support this, though it sounds
> >> like
> >> "generally useful behaviour", and one that could have a home in the GL
> >> core.
> >> If you've got the time, we can design something together via this
> >> channel...
> >> I'll be back online fulltime in 3 weeks, but Holger would probably be
> >> able
> >> to help you out too....
> >>
> >> James
> >>
> >> On Tue, May 27, 2008 at 2:26 PM, Benoitx <benoitx@...> wrote:
> >>
> >>>
> >>> Hi
> >>>
> >>> I was looking around this forum to find some pointers or example of code
> >>> that could let us emulate the "Auto-filter" functionality form Excel.
> >>>
> >>> On a given event (say right click?) on a JTable Header, a JList would
> >>> appear
> >>> and the set of possible values in this column displayed and selected.
> >>> One
> >>> could unselect them all or just select a few and on closing of this
> >>> "filter"
> >>> panel, only those rows would be displayed.
> >>>
> >>> This sounds like a job for a FilteredList but has anybody done it in
> >>> JDK5?
> >>> There is a fair amount of work to display etc... so rather than
> >>> re-inventing
> >>> the wheel, I was wondering if anyone had done something similar and
> >>> would
> >>> be
> >>> willing to share it or explain a bit?
> >>>
> >>> Many thanks for GlazedLists!
> >>>
> >>> Thanks a lot
> >>>
> >>> Best regards from London
> >>> (the English one)
> >>>
> >>> Benoit
> >>>
> >>> -----
> >>> Thanks & Regards,
> >>>
> >>> Benoit
> >>>
> >>> http://www.Appendium.com   http://objectlab.blogspot.com
> >>>
> >>> --
> >>> View this message in context:
> >>> http://www.nabble.com/Auto-filter-a-la-%22Excel%22--tp17500378p17500378.html
> >>> Sent from the GlazedLists - User mailing list archive at Nabble.com.
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: users-unsubscribe@...
> >>> For additional commands, e-mail: users-help@...
> >>>
> >>>
> >>
> >>
> >
> >
>
>
> -----
> Thanks & Regards,
>
> Benoit
>
> http://www.Appendium.com   http://objectlab.blogspot.com
>
> --
> View this message in context: http://www.nabble.com/Auto-filter-a-la-%22Excel%22--tp17500378p17568954.html
> Sent from the GlazedLists - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Benoitx]

Hi Holger,

For some reason this post did not appear under the original thread and I missed it.
Sorry!

I will put something together trying to remove our project-specific stuff (using Spring RC)

It is probably an ugly duckling... but it quacks for us...
feel free to take it apart and create something great for us!

Give me a few days,

Benoit

Holger Brands wrote:

Benoit,

I've created an issue for your suggestion:
https://glazedlists.dev.java.net/issues/show_bug.cgi?id=450

If you would like to contribute your code you can attach it to
this issue.

Thanks,
Holger

>
> Hi *,
>
> Quick update: I have sorted most of my Swing basic problems (using a
> sub-class of JDialog to display the list), keeping 2 sets of data (available
> and selected). I can send the stuff over if required.
>
> One thing is missing... how to display a little icon on the header to say
> that it was filtered... Or may be change the header colour for that column
> only??? Suggestions?
>
> Thanks
>
> Benoit
>
>
>
> Benoitx wrote:
> >
> > Dear James & All,
> >
> > Thanks for replying. I went ahead and started on some exploratory work
 it
> > nearly works but the glitches that I am experiencing will surely show the
> > depth of my ignorance.  I have 2 types of issues, one with Swing and the
> > other with GlazedLists.
> >
> > First of all, the scope of this exercise.  I am using an extension to the
> > EventTableModel. When a user clicks (right button) on the jtable header I
> > would like a small JList to appear. By default everything should be
> > selected; when the user selects some items and press ok, the table will be
> > filtered. Our application is using Swing and MDI with the table created in
> > a JInternalFrame.
> >
> > I have a solution which is work-in-progress, you can see the current
> > result on:
> > http://www.objectlab.co.uk/jfree/jtable-filter.png
> >
> > SWING Issues
> >
> > 1/ Which container to use? For the panel with the JList? I have used a
> > JWindow as it was the only one that seemed working
(JFrame appears like
> > another window) Basically, how do you overlay a panel on top of a header
> > and part of the JTable?
> >
> > 2/ How to position the Window/Panel? I have picked up the MouseEvent point
> > but how can one detect the top-left corner of the COLUMN header?
> >
> > 3/ for some reason, I *had* to make the JWindow always on top (otherwise
> > it would disappear as soon as it gets clicked on).  This leads to some
> > ugly effect if you then bring another application on top
 as the little
> > filter panel stays on top of anything on your machine!!!
> >
> > 4/ I tried to add a focus listener on the JWindow and dispose of the
> > window when it loses the focus (reasonable assumption I guess) but the
> > JWindow does not pickup any focus event:
> > window.addFocusListener(new FocusAdapter() {
> >     public void focusLost(final FocusEvent e) {
> > window.dispose();
> >     }
> > });
> >
> > GLAZED LISTS Deisgn & Issues
> >
> > 1/ I wanted this functionality to be totally transparent, ie current users
> > of the EventTable would not need to do anything, so the idea was to
> > override the EventTableModel and give it a FilterList when it is created.
> > Unfortunately, once a list is given to an EventTableModel it appears that
> > there is no way to get back the list (the table should listen for events
> > in order to refresh the list of existing values)? The list is wrapped up
> > in a swingThreadSource transformed list
 Why can’t we get the source in
> > order to apply the filter?
> >
> > 2/ Current solution creates a sub-class of EventTableModel which creates a
> > FilterList and passes it to the EventTableModel, it also retains a link to
> > the FilterList and can give it to the MouseListener code on the table
> > header so that a Matcher can be applied to the filter list.
> >
> > 3/ on pressing the header, the column property name is found and we’re
> > using the Spirng BeanWrapper to fetch all valid data from the list, put
> > those in a Set (to remove duplicates). Once the list of items is prepared,
> > a new Matcher is created (also using a BeanWrapper to access values of
> > each beans given the column name).
> >
> > My questions really relates to the fact that usually one creates an
> > EventList, then a SortedList and gives the SortedList to the
> > EventTableModel.  Some of our tables have also a FilterList (with

> > textfield) but it is always a SortedList given to the EventTableModel
 so
> > we end-up with the possibility of having 2 filter lists on the dataset

> > and also having no way to use the FilterList from the table model outside
> > the table (say for a chart too).  It would be good if my sub-class of
> > EventTableModel could look at the list given and see if it is the result
> > of a FilterList
 and keep a reference to it

> >
> > As you can see my main issues are related to Swing
 any suggestion would
> > be welcome!
> > I have no problem sending the non-generic/hack code in order to design a
> > better solution

> >
> > Thanks a lot
> > Benoit
> >
> >
> >
> > James Lemieux wrote:
> >>
> >> Benoit,
> >>
> >>    No work has been done specifically to support this, though it sounds
> >> like
> >> "generally useful behaviour", and one that could have a home in the GL
> >> core.
> >> If you've got the time, we can design something together via this
> >> channel...
> >> I'll be back online fulltime in 3 weeks, but Holger would probably be
> >> able
> >> to help you out too....
> >>
> >> James
> >>
> >> On Tue, May 27, 2008 at 2:26 PM, Benoitx <[e-mail]> wrote:
> >>
> >>>
> >>> Hi
> >>>
> >>> I was looking around this forum to find some pointers or example of code
> >>> that could let us emulate the "Auto-filter" functionality form Excel.
> >>>
> >>> On a given event (say right click?) on a JTable Header, a JList would
> >>> appear
> >>> and the set of possible values in this column displayed and selected.
> >>> One
> >>> could unselect them all or just select a few and on closing of this
> >>> "filter"
> >>> panel, only those rows would be displayed.
> >>>
> >>> This sounds like a job for a FilteredList but has anybody done it in
> >>> JDK5?
> >>> There is a fair amount of work to display etc... so rather than
> >>> re-inventing
> >>> the wheel, I was wondering if anyone had done something similar and
> >>> would
> >>> be
> >>> willing to share it or explain a bit?
> >>>
> >>> Many thanks for GlazedLists!
> >>>
> >>> Thanks a lot
> >>>
> >>> Best regards from London
> >>> (the English one)
> >>>
> >>> Benoit
> >>>
> >>> -----
> >>> Thanks & Regards,
> >>>
> >>> Benoit
> >>>
> >>> http://www.Appendium.com   http://objectlab.blogspot.com
> >>>
> >>> --
> >>> View this message in context:
> >>> http://www.nabble.com/Auto-filter-a-la-%22Excel%22--tp17500378p17500378.html
> >>> Sent from the GlazedLists - User mailing list archive at Nabble.com.
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: [e-mail]
> >>> For additional commands, e-mail: [e-mail]
> >>>
> >>>
> >>
> >>
> >
> >
>
>
> -----
> Thanks & Regards,
>
> Benoit
>
> http://www.Appendium.com   http://objectlab.blogspot.com
>
> --
> View this message in context: http://www.nabble.com/Auto-filter-a-la-%22Excel%22--tp17500378p17568954.html
> Sent from the GlazedLists - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>


_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114


---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]