Ihor Shevchenko

@yw4z How you configure LED as a switch control? I have LED as a slider disregard of states ON/OFF.

Just a suggestion: add these changes to the library. It can be used for Ukrainian also

It is a fragment of debug log: Please pay attention to variable **alias.0.Energy.Battery.Axioma100 (type: undefined, ID: 405)** ``` 2023-02-14 10:38:02.202 - debug: sql.0 (9038) pushValueIntoDB called for alias.0.Energy.Battery.Axioma100 (type: undefined,...

``` { "type": "state", "common": { "name": "Equipment/VoltmetersDC/V0280/CH2/Voltage", "role": "variable", "type": "number", "read": true, "write": true, "alias": { "id": "mqtt.0.Equipment.VoltmetersDC.V0280.CH2.Voltage", "read": "Math.round(val*10)/10" }, "custom": { "sql.0": { "enabled": true, "storageType":...

The base variable was created by MQTT Publish request. The alias is created manually from alias-manager. Ok I will change it manually

The role "mixed" is absent in the list of available roles in both Admin UI and Alias-Manager [https://i.imgur.com/620dq4n.png](url)

The problem is: the SQL adapter creates a hundreds records in the DB with the same values: ``` "id","ts","val","ack","_from","q" 405,1676366200106,12.3,True,2,0 405,1676366199072,12.3,True,2,0 405,1676366197410,12.3,True,2,0 405,1676366040604,12.3,True,2,0 405,1676366039468,12.3,True,2,0 405,1676366039131,12.3,True,2,0 405,1676364832976,12.3,True,2,0 405,1676364831606,12.3,True,2,0 405,1676364828837,12.3,True,2,0 405,1676364283636,12.3,True,2,0 ```...

BTW. I changed role: "mixed" manually and restart of SQL driver. Nothing to changed - a lot of records in DB with the same value

"Disable charting optimized logging of skipped values" = off. "On query round numbers to" is empty

BTW, I set "On query round numbers to"=1. Nothing to changed - lot's of records in DB