Versions Compared

Old Version 20

changes.mady.by.user Paul Nguyen

Saved on

compared with

New Version Current

changes.mady.by.user Paul Nguyen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


UI Text Box
typetip

NOTE:

  • Meshlets will only run with Java 11 and greater.


Version 

Html-bobswift
<style> 
.version {
	height: 25px;
    width: 200px;
    border-radius: 5px;
    border: 1px solid #ddd;
}
</style>
<select class="version" id="version" onchange="showContent()">
	<option value="7.0.2">7.0.2</option>
	<option value="7.0.1" selected>7.0.1</option>
	<option value="7.0.0">7.0.0</option>
</select>
<script> 
function showContent() {
	var dropdown = document.getElementById("version"); 
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == dropdown.value) {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
}
</script>



UI Tab
title7.0.2

Release Date: TBD

Note

Iodine 7.0.2 and newer will require a new databaseConfig.json. Contact Perspectium Support for more information.


Enhancements

Add loadSchemasOnStart configuration to create table in Snowflake database from local schemas only when a record for the table is received.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-27016


Optimize to use SELECT LIMIT 1 statement as part of querying if table exists in Snowflake database prior to taking action.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-27143


Updated to use CREATE TABLE to prevent overwriting tables that already exists in Snowflake database and handle response if table exists to continue processing records. Added CREATE TABLE to databaseConfig.json configuration file to allow updating of configuration outside of meshlet.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-27143



Bug Fixes

Handle messages with empty or undefined value field without looping.




UI Tab
title7.0.1

Release Date: November 14, 2022

New Features

Support filtering messages to only read messages from one instance (key)

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyINC-5599


Support DB views to skip null values for the compound sys_id and order *_sys_id values in alphabetical order.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyINC-5600



Enhancements

Fix to truncate text if its over a column's length and log if record fails being inserted/updated in Snowflake.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyINC-5568


Extend column to max size if content is larger than current size. Requires the extendColumnsMaxLength configuration.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-26829


Log which column is being truncated when insert/update a record into Snowflake and the data is too large for the column. Requires the truncateColumns configuration.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-26854



Bug Fixes

Fix for Numeric value 'true' is not recognized , Numeric value 'false' is not recognized error when translating boolean values for newly adding custom columns using the translateBooleans configuration.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyINC-5580


Fix for processing message and improperly pushing to error queue.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-26441





UI Tab
title7.0.0

Release Date: December 10, 2021


DataSync for Snowflake is now bi-directional! You can now share from your Snowflake database to ServiceNow. Click here to get started! 

New Features
Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-22268

Enhancements

Meshlets will only run with Java 11 and greater. 

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-17288


Enable the purgeTable directive to truncate or delete all the records for a selected table in your database before bulk sharing. See Meshlet Configurations for Snowflake.

Show If
special@authenticated

Jira
serverJIRA
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverIde15725ca-3b2b-32f6-914c-89477a90901d
keyDEV-19191






HTML
<script>
	var tabs = document.getElementsByClassName("rwui_tab_content");
	for (var i = 0; i < tabs.length; i++) {
		if (tabs[i].getAttribute("data-name") == "7.0.1") {
			tabs[i].style.display = "";
		}
		else {
			tabs[i].style.display = "none";
		}
	}
</script>