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