2.23.0 Release Notes
October 8, 2021
Summary
The 2.23.0 release of AnswerHub introduces a new messaging integration capability and availability of the 2-way messaging integration module for Slack and several maintenance updates.
Updated Features
A new messaging integration capability and the first release of a 2-way messaging integration with Slack which allows announcement of new questions, ideas, and articles in AnswerHub to be published on select channels. Mapping to channels supports Topics and Spaces and this functionality has been updated from the previous Slack integration plugin. A new 2-way enablement feature in conjunction with an installed slack bot allows users on Slack to ask questions which are published into AnswerHub. Threaded replies posted to the question on Slack will appear as answers to the question in AnswerHub, along with Answers and comments that are posted natively in AnswerHub. During initial roll out, this new plugin is available upon request - please contact your Customer Success Manager. Additional updates of this feature are in development and as they are delivered in an upcoming release, this integration will become automatically available to all clients as a core feature. See configuration guide for additional details
Changelog
2.23.0 updates include the following:
-
ANSUP-14482 Resolved issue where the default answer list sorting option in the admin was not being saved when saving settings on that page (site navigation).
-
ANSUP-14488 Resolved error message for file too large when uploading some images despite being within the defined limit set in the admin.
-
ANSUP-14470 Resolved an issue that prevented copy and paste a picture functionality from working as expected with Froala editor and client custom themes using the theme compatibility module for legacy 1.6 version themes.
Super User Permission Config Change
The ability to change the permissions for the site administration roles has been removed from the super user group. This change prevents a member of the super user group from revoking key administration permissions to edit settings, edit users and groups, edit permissions when applied to the super user group. Revocation of these permissions would prevent the members of the super user group from accessing admin pages, accessing users and group settings, or accessing permission settings. This change prevents super users from accidentally locking themselves and other admins out.
Schema Changes from 2.22.5 to 2.23.0
Core changelogs.xml:
DELETE FROM ${teamhub_table_prefix}authorities WHERE c_role = 'ROLE_SPAM_MODERATOR' AND c_authoritable = 3;
</sql>
</changeSet>
+
+ <changeSet id="create_table_${teamhub_table_prefix}_messaging_integration_node" author="pedroz">
+ <validCheckSum>ANY</validCheckSum>
+ <preConditions onError="MARK_RAN" onFail="MARK_RAN">
+ <not>
+ <tableExists tableName="${teamhub_table_prefix}messaging_integration_nodes" />
+ </not>
+ </preConditions>
+
+ <createTable tableName="${teamhub_table_prefix}messaging_integration_nodes">
+ <column name="c_id" type="BIGINT">
+ <constraints primaryKey="true"/>
+ </column>
+ <column name="c_creation_date" type="datetime"/>
+ <column name="c_modification_date" type="datetime"/>
+ <column name="c_shared" type="BIGINT" />
+ <column name="c_channel" type="varchar(40)" />
+ <column name="c_identifier" type="varchar(125)" />
+ </createTable>
+
+ <addForeignKeyConstraint baseColumnNames="c_shared" baseTableName="${teamhub_table_prefix}messaging_integration_nodes"
+ constraintName="shared_nodes_fk" deferrable="false" initiallyDeferred="false"
+ onDelete="SET NULL" onUpdate="NO ACTION"
+ referencedColumnNames="c_id" referencedTableName="${teamhub_table_prefix}nodes" />
+ <createIndex tableName="${teamhub_table_prefix}messaging_integration_nodes" indexName="${teamhub_table_prefix}shared_channel_idx">
+ <column name="c_channel"/>
+ </createIndex>
+ <createIndex tableName="${teamhub_table_prefix}messaging_integration_nodes" indexName="${teamhub_table_prefix}shared_identifier_idx">
+ <column name="c_identifier"/>
+ </createIndex>
+ <createIndex tableName="${teamhub_table_prefix}messaging_integration_nodes" indexName="${teamhub_table_prefix}shared_node_idx">
+ <column name="c_shared"/>
+ </createIndex>
+ </changeSet>
+
+ <changeSet id="create_${teamhub_table_prefix}messaging_integration_mapping" author="pedroz">
+ <validCheckSum>ANY</validCheckSum>
+ <preConditions onError="MARK_RAN" onFail="MARK_RAN">
+ <not>
+ <tableExists tableName="${teamhub_table_prefix}messaging_integration_mappings" />
+ </not>
+ </preConditions>
+ <createTable tableName="${teamhub_table_prefix}messaging_integration_mappings">
+ <column name="c_id" type="BIGINT">
+ <constraints primaryKey="true"/>
+ </column>
+ <column name="c_integration" type="varchar(40)" />
+ <column name="c_channel_name" type="varchar(255)" />
+ <column name="c_channel_id" type="varchar(100)" />
+ <column name="c_topic" type="BIGINT" />
+ <column name="c_space" type="BIGINT" />
+ </createTable>
+
+ <addForeignKeyConstraint baseColumnNames="c_topic" baseTableName="${teamhub_table_prefix}messaging_integration_mappings"
+ constraintName="topics_fk" deferrable="false" initiallyDeferred="false"
+ onDelete="SET NULL" onUpdate="NO ACTION"
+ referencedColumnNames="c_id" referencedTableName="${teamhub_table_prefix}nodes" />
+ <addForeignKeyConstraint baseColumnNames="c_space" baseTableName="${teamhub_table_prefix}messaging_integration_mappings"
+ constraintName="space_fk" deferrable="false" initiallyDeferred="false"
+ onDelete="SET NULL" onUpdate="NO ACTION"
+ referencedColumnNames="c_id" referencedTableName="containers" />
+
+ <createIndex tableName="${teamhub_table_prefix}messaging_integration_mappings" indexName="${teamhub_table_prefix}messaging_integration_mappings_topic_id">
+ <column name="c_topic"/>
+ </createIndex>
+ <createIndex tableName="${teamhub_table_prefix}messaging_integration_mappings" indexName="${teamhub_table_prefix}messaging_integration_mappings_space_idx">
+ <column name="c_space"/>
+ </createIndex>
+
+ </changeSet>
+
</databaseChangeLog>
Plugins changelog.xml:
No diffs in plugins changelog.xml