Add history tab
A tab with history should be added. It should display 3 columns: date, name, state. An example of query could be the following:
SELECT asd.data_time as date,ac.att_name as name, COALESCE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(asd.value_r,'0','NORMAL'),'1','ALARM UNACK'),'2','ALARM ACKED'),'3','NORMAL UNACK'),'4','SHELVED'),'5','SUPPRESSED BY DESIGN'),'6','DISABLED'),'7','ERROR'),aed.error_desc) as state FROM att_scalar_devenum_ro asd JOIN att_conf ac ON asd.att_conf_id=ac.att_conf_id LEFT OUTER JOIN att_error_desc aed ON aed.att_error_desc_id=asd.att_error_desc_id WHERE asd.att_conf_id in (SELECT att_conf_id FROM att_conf WHERE att_name LIKE '%alarm/fermi/climate/%' OR att_name LIKE '%alarm/fermi/diagnostics/%') AND asd.data_time > NOW() - INTERVAL 1 DAY and asd.data_time <= NOW() ORDER BY asd.data_time DESC;
where the REPLACE(REPLACE...) is used to replace [0-7] enum values with the labels [NORMAL','ALARM UNACK','ALARM ACKED','NORMAL UNACK','SHELVED','SUPPRESSED BY DESIGN','DISABLED','ERROR'], JOIN with att_conf is used to replace att_conf_id with att_name from att_conf, LEFT OUTER JOIN is used to replace att_error_desc_id with error_desc, SELECT att_conf_id in the WHERE condition is used to retrieve all alarms belonging to the listed handlers. Attention should be paid to handler names, whether they are FQDN or not.
It should be possible to filter history by both name, state and date.
Parameters to access DataBase could be saved in a free property.