# Column Selexctor **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [April 7, 2014, 5:24pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270 "2014-04-07T17:24:57Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![arye](https://avatars.discourse-cdn.com/v4/letter/a/cc9497/32.png) [@arye](https://forum.inductiveautomation.com/u/arye)\ **Post date:** [April 7, 2014, 5:24pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/1 "2014-04-07T17:24:57Z")
Hi All, First I would like to Thank you so much for your support and expert advises. I have a question that I would like to get help on; I use Column selector and in the DATA IN I put the SQL Query binding the following: SELECT \* FROM unit\_plc\_data where t\_stamp BETWEEN '{Root Container.Historical Mode.Start Date.date}' AND '{Root Container.Historical Mode.End Date.date}' AND UNIT != '' order by {Root Container.Dropdown 1.selectedStringValue} ASC By default I get all check-boxes selected - that means I have everything inside. I would like to be able to have a button that will allow me to select all or deselect all when needed. We have so many tags that we are logging and I would like to be able to deselect all and only check 2 or three and not going the wrong way of deselecting everything but these two or three - that is time consuming. I would be happy to know if I can use buttons that will hold queries over the same table with a custom selected tags - I would like to have them as templates for users from different teams that monitor the same unit. I export the table into a CSV file and I would be happy to be able to have the ability to set buttons that will give several filtering over the data collected in the column selector. Just to make myself clear i would like to Summarize my request AND I would be happy to get help on that. - Be able to have a Button for Select All and Deselect All. - Be able to have pre made buttons that can filter out the table upon selecting the relevant from the column selector. - Be able to set and save template upon use. The ides is to be able to handle the Column selector by using buttons on the page. Currently I wrote SELECT \* But I would like to be able to have a different selection while using Buttons. Please help me understand how that can be done. thanks for your support! Arye ---
**Author:** ![Luke.Stone](https://avatars.discourse-cdn.com/v4/letter/l/5fc32e/32.png) [@Luke.Stone](https://forum.inductiveautomation.com/u/Luke.Stone)\ **Post date:** [June 5, 2014, 9:04pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/2 "2014-06-05T21:04:42Z")
There are plans to add “select all/deselect all” buttons for the Column Selector component in 7.7. It hasn’t been decided yet which release of 7.7 this will make it into, but it should be one of the early ones. ---
**Author:** ![praneethmuktheeswara](https://avatars.discourse-cdn.com/v4/letter/p/7bcc69/32.png) [@praneethmuktheeswara](https://forum.inductiveautomation.com/u/praneethmuktheeswara)\ **Post date:** [January 13, 2021, 1:31pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/3 "2021-01-13T13:31:44Z")
Hi @paul-griffith, @Kevin.Herron, @Kevin.McClusky, @KathyApplebaum Sorry for looping everybody. Can you let us know if the “Select All”/ “Deselect All” options for the column selector were provided with Ignition Vision 7.xx or a work around has been provided? This has been a requirement in some of our projects. Thanks & Regards, Praneeth Barry-Wehmiller Design Group ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 13, 2021, 4:22pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/4 "2021-01-13T16:22:22Z")
In 7.9.0 the component got a scripting method to `selectAll()` or `deselectAll()`, which you could add to your own checkbox easily. There’s no checkbox built in to the component itself. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 13, 2021, 4:33pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/5 "2021-01-13T16:33:50Z")
Paul, were the doc’s updated to reflect this? I’ve skimmed them and don’t see it. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 13, 2021, 4:41pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/6 "2021-01-13T16:41:02Z")
It looks like the reporting specific appendix pages haven’t been updated in quite some time - I let the training department know about some discrepancies, so they’ll probably update them pretty soon. In the meantime, I think the only way to know about this would have been the release notes or introspection on the live component in the designer, unfortunately. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 13, 2021, 5:04pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/7 "2021-01-13T17:04:35Z")
I have had a look at the component on 7.9.12 and I’m not seeing it there either. Whilst we are awaiting Doc update, for Praneeth and I, and forum posterity, would you mind having a check and maybe posting a quick ‘how-to’? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 13, 2021, 5:26pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/8 "2021-01-13T17:26:53Z")
It’s not a property that would be exposed, you would just access it from scripting - so if you had a checkbox, for example, you could have the `actionPerformed` event do something like this: ```auto cs = event.source.parent.getComponent("Column Selector") cs.selectAll() if event.newValue else cs.deselectAll() ``` I can guarantee the method is there by 7.9.5, at minimum: [http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/factorypmi/plugins/reporting/components/ColumnSelectorPanel.html#selectAll--](http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/factorypmi/plugins/reporting/components/ColumnSelectorPanel.html#selectAll--) ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [January 15, 2021, 10:19am UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/9 "2021-01-15T10:19:33Z")
Implemented and working in 7.9.12, thanks! 😃 ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [October 17, 2024, 7:54am UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/11 "2024-10-17T07:54:11Z")
I'm on-site commissioning robots. Might get a look later. Can you share your code so far, please use the forum formatting. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/4/f49c6e46583ab68a9b15ce725bf60af17b2c69e9.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 17, 2024, 12:33pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/12 "2024-10-17T12:33:26Z")
In four hours, you posted a version of this question in three places. Please follow this [forum's "Keep It Tidy" rules](https://forum.inductiveautomation.com/faq), and avoid reviving old topics. This new topic is the right place for your discussion: > [@Reset Column Selector Values](https://forum.inductiveautomation.com/t/reset-column-selector-values/97375): > > Hi Everyone, I hope all are well. I have one requirement in Column Selector. I have 180 columns containing tables and I'm using that Column Selector to hide 110 columns and show 80 columns as default. I have given one confirm button once I select or unselect the columns in the column selector click that button to apply the changes on the CS. And now my new requirement is Just I need to add one button named "Reset". If I deselect a few columns from the default 80 columns and click the confirm bu… ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 17, 2024, 12:33pm UTC](https://forum.inductiveautomation.com/t/column-selexctor/8270/13 "2024-10-17T12:33:38Z")