Hello.

The argument can be a substring. If you have an array, convert it to string.

Hello.

Example of using the methodindexOf():

var str = 'Быть или не быть, вот в чём вопрос.';
var count = 0;
var pos = str.indexOf('в');

while (pos !== -1) {
count++;
pos = str.indexOf('в', pos + 1);
}

IR.Log(count); // 3

Hello.

MQTT in iRidium is a native driver. The license is the same as for the Custom AV driver.

var systembase = IR.GetDatabase();

var result = systembase.Request('DELETE FROM INTEGER_TAG_HISTORY WHERE VALUE = 0;');

//The system database is read-only. Therefore, this code may not work in future releases.

DELETE FROM table_name WHERE VALUE = 0;

Hello.

Iridium does not provide import for the MQTT driver.

We understand, do it at your own risk. If the database is damaged and you do not have a backup, the iRidium server will not be able to start. In this case, stop the iRidium server, delete the broken database and start again. The database will be created again automatically, with empty values.

Hello.

Do you want to query the system database? We strongly recommend that you do not remove something from the system database script from the server project. You have the right to do with your database whatever you see fit, but in case of wrong actions, you risk to bring iRidium server inoperable.

Hello.

Install this on your PC.

Then estimate the size of the received data and if memory allows, just collect the data in one piece.