alarm-ng issueshttps://gitlab.elettra.eu/cs/gui/alarm-ng/-/issues2021-05-28T12:17:59Zhttps://gitlab.elettra.eu/cs/gui/alarm-ng/-/issues/10Add helper application2021-05-28T12:17:59ZGraziano ScalameraAdd helper applicationAttribute names inside values field in the info box, could be associated to helper applications to be opened with mouse right click.Attribute names inside values field in the info box, could be associated to helper applications to be opened with mouse right click.https://gitlab.elettra.eu/cs/gui/alarm-ng/-/issues/9Add history tab2021-05-28T12:14:23ZGraziano ScalameraAdd 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(REPL...
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.https://gitlab.elettra.eu/cs/gui/alarm-ng/-/issues/5Handle alarm-handler not responding2021-05-28T07:08:02ZGraziano ScalameraHandle alarm-handler not respondingWhen an alarm-handler server is not responding, GUI should sound, add a line with an entry to be defined, diplay alarms for other alarm-handlers correctlyWhen an alarm-handler server is not responding, GUI should sound, add a line with an entry to be defined, diplay alarms for other alarm-handlers correctly