deleteAll does not work when logging is already disabled

[5G7K]

I want to use the deleteALL functionality to delete entries for not more existing data points.
I tried to use it like documented. BTW in the example in the docu there are some ' and , missing?

To delete ALL history data for some data point execute:

sendTo('sql.0', 'deleteAll', [
    {id: 'mbus.0.counter.xxx} 
    {id: 'mbus.0.counter.yyy}
], result => console.log('deleted'));

I tried to use it the following way:

sendTo('sql.0', 'deleteAll', [
    {id: 'alias.0.Heizung.Switch.Heating'},
    {id: 'alias.0.Heizung.Switch.Cooling'}
], result => console.log('deleted'));

I also tried instead of the name the IDs. But nothing happens

Log:

2021-11-30 12:49:11.873 - info: javascript.0 (32056) script.js.Test.JS_Test1: deleted
2021-11-30 12:49:11.854 - debug: sql.0 (32083) prepareTaskCheckTypeAndDbId CALLED for alias.0.Heizung.Switch.Heating
2021-11-30 12:49:11.855 - warn: sql.0 (32083) Ignore type lookup for alias.0.Heizung.Switch.Heating because not enabled anymore
2021-11-30 12:49:11.856 - warn: sql.0 (32083) Cannot store values of type "undefined" for alias.0.Heizung.Switch.Heating
2021-11-30 12:49:11.857 - debug: sql.0 (32083) prepareTaskCheckTypeAndDbId CALLED for alias.0.Heizung.Switch.Cooling
2021-11-30 12:49:11.857 - warn: sql.0 (32083) Ignore type lookup for alias.0.Heizung.Switch.Cooling because not enabled anymore
2021-11-30 12:49:11.859 - warn: sql.0 (32083) Cannot store values of type "undefined" for alias.0.Heizung.Switch.Cooling
2021-11-30 12:49:11.866 - debug: sql.0 (32083) deleteStateAll 2 items
2021-11-30 12:49:11.867 - debug: sql.0 (32083) prepareTaskCheckTypeAndDbId CALLED for alias.0.Heizung.Switch.Heating
2021-11-30 12:49:11.867 - warn: sql.0 (32083) Ignore type lookup for alias.0.Heizung.Switch.Heating because not enabled anymore
2021-11-30 12:49:11.868 - warn: sql.0 (32083) Cannot store values of type "undefined" for alias.0.Heizung.Switch.Heating
2021-11-30 12:49:11.869 - debug: sql.0 (32083) prepareTaskCheckTypeAndDbId CALLED for alias.0.Heizung.Switch.Cooling
2021-11-30 12:49:11.870 - warn: sql.0 (32083) Ignore type lookup for alias.0.Heizung.Switch.Cooling because not enabled anymore
2021-11-30 12:49:11.870 - warn: sql.0 (32083) Cannot store values of type "undefined" for alias.0.Heizung.Switch.Cooling
2021-11-30 12:49:13.269 - info: javascript.0 (32056) Stop script script.js.Test.JS_Test1

It this a bug or what's wrong?
Thank you very much!

[Apollon77]

Ignore type lookup for alias.0.Heizung.Switch.Heating because not enabled anymore

This is the reason. the adapter can only handle values that are enabled for logging ...

Can this be the reason?

[5G7K]

I want to use it to delete old entries out of my MariaDB for datapoints for which I have disabled SQL logging or for datapoints with SQL logging which I have deleted.
So yes, logging is not enabled any more.
But that would be the perfect function to delete the old entries. Would it be possible to enable this functionality also for this case?
Or is there an other way to do this (easier than to write a script with all the SQL statements)?
Thanks!

[Apollon77]

The problem is that for all that many meta information are needed and when the datapoint is disabled these data structures are not there. Ideally enable it and maybe set the min/max or such in a way that no new value is logged ... then delete, then deactivate again