Exact

Exact Union RegExp

Kris 0284e0a2a5 A11Y: live announcements and optional sounds for chat messages (#41213) ... This introduces two new chat settings in user preferences, grouped in a new accessibility section. The first "announce new messages to screen readers", defaults on, and uses an aria live region to politely announce messages as they're posted. There's some grouping (user sent 3 messages) and throttling involved here in cases where many messages are sent, and attachments are also referenced. The second "Play a sound for every new message while chat is in the foreground" is default off, and provides an optional secondary approach if the announcement of messages proves to be too noisy. This plays a sound for each message (throttled slightly to avoid floods), and leans on our existing chat sounds. <img width="500" alt="image" src="https://github.com/user-attachments/assets/3c4e6173-3b2d-463d-9040-050311f91d63" />		2026-07-02 12:48:58 -04:00
..
20210225230057_create_chat_tables.rb
20210403025854_add_action_code_to_topic_chat_message.rb
20210706214013_rename_topic_chats_to_chat_channels.rb	DEV: Enable Style/RedundantBegin rubocop rule (#40096)	2026-05-19 18:44:54 +02:00
20210729134042_create_chat_message_revisions.rb
20210730134847_create_user_chat_channel_last_read.rb
20210812145801_create_direct_message_tables.rb
20210813141741_add_timestamps_to_chat_channels.rb
20210819202912_create_incoming_chat_webhooks.rb
20210823160357_create_chat_webhook_events.rb
20210901130308_create_user_chat_channel_membership.rb
20210930144333_add_chat_enabled_to_user_options.rb
20211022151713_create_chat_message_post_connections.rb
20211029145508_add_chat_isolated_to_user_options.rb
20211104141254_add_only_chat_push_notifications_to_user_options.rb
20211119142000_add_cooked_to_chat_messages.rb
20211129171229_create_chat_uploads.rb
20211201171813_create_chat_reactions.rb
20211210191830_create_chat_mentions.rb
20211213150607_add_chat_sound_to_user_options.rb
20211217221026_add_name_to_chat_channel.rb
20211222153716_add_description_to_chat_channels.rb
20220104051326_change_chat_channels_timestamp_columns_to_timestamp_type.rb
20220119170535_add_chat_retention_fields_to_user_options.rb
20220203204002_create_chat_drafts_table.rb
20220203204003_migrate_drafts_to_chat_drafts.rb
20220218023859_add_status_to_chat_channel.rb
20220228051724_create_chat_channel_archive_table.rb
20220308165620_add_user_count_to_chat_channel.rb
20220309174820_add_last_message_created_at_to_chat_channels.rb
20220321235638_drop_chat_message_post_connections_table.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20220324062937_ignore_channel_wide_mention_to_user_options.rb
20220328142120_create_user_chat_message_statuses.rb
20220504080457_drop_old_chat_message_post_id_action_code_columns.rb	DEV: Remove logical OR assignment of constants (#29201)	2024-10-16 10:09:07 +08:00
20220516142658_remove_email_statuses_table.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20220518140004_track_last_unread_mention_when_emailed.rb
20220518180642_remove_user_option_last_emailed_at.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20220526135414_remove_corrupted_last_read_message_id.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20220531105951_drop_user_chat_channel_last_reads.rb	DEV: Remove logical OR assignment of constants (#29201)	2024-10-16 10:09:07 +08:00
20220629190633_auto_join_users_to_channels.rb
20220630074200_drop_chat_isolated_from_user_options.rb	DEV: Remove logical OR assignment of constants (#29201)	2024-10-16 10:09:07 +08:00
20220701195731_convert_chatable_topics_to_categories.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20220706114835_add_join_mode_to_channel_memberships.rb
20220729032237_add_index_to_chat_message_created_at.rb
20220802014549_disable_chat_uploads_if_secure_media_enabled.rb
20220901034107_add_user_count_stale_to_channel.rb
20221004122254_delete_reviewables_targetting_deleted_chat_messages.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221005143622_add_type_to_chat_channel.rb
20221014005208_add_slug_column_to_chat_channel.rb
20221018091412_migrate_chat_channels.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221027090832_migrate_dm_channels.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221101061319_add_last_editor_id_to_chat_messages.rb
20221104054957_backfill_channel_slugs.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221107034541_make_chat_editor_ids_not_null.rb
20221117052348_truncate_chat_messages_over_max_length.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221117142910_delete_orphaned_channels.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221118104708_add_allow_channel_wide_mentions_to_chat_channels.rb
20221122070108_save_chat_allowed_groups_site_setting.rb
20221201024458_make_channel_slugs_unique_with_index.rb
20221201032830_drop_tmp_chat_slug_tables.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20221201035918_add_slug_unique_index_for_chat_channels.rb
20221202032006_add_chat_message_count_to_chat_channels.rb
20221202043755_update_chat_channel_message_counts.rb	DEV: Promote historic post_deploy migrations	2023-07-26 10:36:37 +02:00
20230116090324_drop_chat_drafts_over_max_length.rb	DEV: Promote historic post_deploy migrations (#25334)	2024-01-19 14:47:42 +00:00
20230123020036_move_chat_uploads_to_upload_references.rb
20230123025112_move_chat_uploads_to_upload_references_post.rb	DEV: Promote historic post_deploy migrations (#25334)	2024-01-19 14:47:42 +00:00
20230130053144_add_threading_enabled_to_chat_channels.rb
20230201012734_create_chat_threading_models.rb
20230227172543_make_chat_mention_notification_id_nullable.rb	DEV: Promote historic post_deploy migrations (#25334)	2024-01-19 14:47:42 +00:00
20230228062442_add_chat_header_indicator_preference.rb
20230403012844_drop_chat_uploads.rb	DEV: Remove logical OR assignment of constants (#29201)	2024-10-16 10:09:07 +08:00
20230411012630_add_thread_not_deleted_index_chat_messages.rb
20230411023246_add_chat_message_replies_count_to_chat_threads.rb
20230411023340_update_thread_reply_counts.rb	DEV: Promote historic post_deploy migrations (#28128)	2024-07-30 01:14:03 +08:00
20230510142249_add_user_chat_thread_memberships.rb
20230607091233_backfill_thread_memberships.rb	FIX: Backfill chat thread memberships (#21971)	2023-06-14 13:54:51 +10:00
20230627044755_add_last_viewed_at_to_user_chat_channel_memberships.rb	FEATURE: Track last_viewed_at datetime for channel members (#22294)	2023-06-29 09:22:17 +10:00
20230707025733_add_last_message_id_to_channel_and_thread.rb	DEV: Add last_message_id to channel and thread (#22488)	2023-07-13 10:28:11 +10:00
20230707082645_backfill_chat_channel_and_thread_last_message_ids.rb	DEV: Add last_message_id to channel and thread (#22488)	2023-07-13 10:28:11 +10:00
20230710040640_backfill_chat_channel_and_thread_last_message_ids_post_migrate.rb	DEV: Promote historic post_deploy migrations (#28128)	2024-07-30 01:14:03 +08:00
20230721025249_remove_experimental_site_setting_for_threads.rb	DEV: Remove experimental setting row for chat threads (#22730)	2023-07-27 15:29:28 +02:00
20230722124044_add_chat_separate_sidebar_mode_user_option.rb	FEATURE: implements user based sidebar mode (#23078)	2023-08-18 20:33:07 +02:00
20231006160650_add_group_field_to_direct_message_channels.rb	FEATURE: introduces group channels (#24288)	2023-11-10 11:29:28 +01:00
20231006161051_set_multiusers_direct_message_channels_as_group.rb	FEATURE: introduces group channels (#24288)	2023-11-10 11:29:28 +01:00
20231110214451_adds_thread_id_to_chat_drafts.rb	FEATURE: implements drafts for threads (#24483)	2023-11-22 11:54:23 +01:00
20231207135641_add_user_chat_thread_memberships_on_thread_id_user_id_index.rb	FEATURE: my threads page (#24771)	2023-12-11 07:38:07 +01:00
20231214180000_add_chat_mention_notifications.rb	DEV: Allow chat mentions to have several notifications (#24874)	2023-12-19 18:53:00 +04:00
20231214180001_update_relationship_between_chat_mentions_and_notifications.rb	DEV: Allow chat mentions to have several notifications (#24874)	2023-12-19 18:53:00 +04:00
20231214180002_update_relationship_between_chat_mentions_and_notifications_post_migrate.rb	DEV: Promote historic post_deploy migrations (#28128)	2024-07-30 01:14:03 +08:00
20231227160001_add_type_and_target_id_to_chat_mentions.rb	DEV: Redesign chat mentions (#24752)	2024-01-17 15:24:01 +04:00
20231227160002_set_type_and_target_id_on_chat_mentions.rb	DEV: Redesign chat mentions (#24752)	2024-01-17 15:24:01 +04:00
20231227160003_add_and_remove_indexes_on_chat_mentions.rb	DEV: Redesign chat mentions (#24752)	2024-01-17 15:24:01 +04:00
20231227160004_set_type_and_target_id_on_chat_mentions_post_migrate.rb	DEV: Promote historic post_deploy migrations (#28128)	2024-07-30 01:14:03 +08:00
20231227160005_make_type_on_chat_mentions_non_nullable.rb	DEV: Promote historic post_deploy migrations (#28128)	2024-07-30 01:14:03 +08:00
20240118120825_add_threads_enabled_site_setting.rb	DEV: Skip backfill INSERTs in old migrations on fresh installs (#39976)	2026-05-13 13:59:28 +01:00
20240213175713_add_streaming_to_message.rb	DEV: chat streaming (#25736)	2024-02-20 09:49:19 +01:00
20240214135517_fix_chat_channel_slug_index.rb	FIX: Allow several chat channels to have an empty slug (#25680)	2024-02-15 00:39:39 +04:00
20240301100413_add_force_to_threads.rb	FEATURE: allows to force a thread (#25987)	2024-03-06 12:03:42 +01:00
20240408140000_drop_notification_id_from_chat_mentions.rb	DEV: Promote historic post_deploy migrations for core plugins. (#30987)	2025-01-24 11:47:03 -03:00
20240409060201_add_thread_title_prompt_to_user_chat_thread_memberships.rb	FEATURE: encourage users to set chat thread titles (#26617)	2024-04-29 17:20:01 +08:00
20240409093348_add_show_thread_title_prompts_to_user_options.rb	DEV: update thread title prompt migration (#27052)	2024-05-17 00:53:19 +04:00
20240410130000_drop_user_id_from_chat_mentions.rb	DEV: Promote historic post_deploy migrations for core plugins. (#30987)	2025-01-24 11:47:03 -03:00
20240422042830_add_excerpt_to_chat_messages.rb	PERF: Reduce overhead from chat message excerpt (#26712)	2024-04-25 14:29:00 +02:00
20240425133407_drop_chat_channels_last_message_sent_at.rb	DEV: Promote historic post_deploy migrations for core plugins. (#30987)	2025-01-24 11:47:03 -03:00
20240516145911_update_user_options_for_thread_title_prompts.rb	DEV: Promote historic post_deploy migrations for core plugins. (#30987)	2025-01-24 11:47:03 -03:00
20240711153837_add_created_by_sdk_to_chat_messages.rb	FEATURE: prevent chat emails for messages created via SDK (#27875)	2024-07-12 10:57:14 +04:00
20240711154622_update_chat_messages_created_by_sdk.rb	DEV: Promote historic post_deploy migrations for core plugins. (#30987)	2025-01-24 11:47:03 -03:00
20240827040131_add_new_notification_id_to_chat_mention_notifications.rb	DEV: Migrate Chat::NotificationMention#notification_id to bigint (#28571)	2024-08-27 14:57:16 +03:00
20240827040550_copy_chat_mention_notifications_notification_id_values.rb	DEV: Migrate Chat::NotificationMention#notification_id to bigint (#28571)	2024-08-27 14:57:16 +03:00
20240827040810_copy_chat_mention_notifications_notification_id_indexes.rb	DEV: Migrate Chat::NotificationMention#notification_id to bigint (#28571)	2024-08-27 14:57:16 +03:00
20240827040811_swap_bigint_chat_mention_notifications_notification_id.rb	DEV: Migrate Chat::NotificationMention#notification_id to bigint (#28571)	2024-08-27 14:57:16 +03:00
20240829140227_drop_chat_mention_notifications_old_id_column.rb	DEV: Promote historic core plugins post_deploy migrations (#34274)	2025-08-13 15:52:19 +08:00
20241003122030_add_notification_level_to_user_chat_channel_memberships.rb	DEV: consolidate chat channel notification settings (#29080)	2024-10-08 13:13:01 +04:00
20241029192512_alter_chat_ids_to_bigint.rb	DEV: Fix mismatched column types (#29477)	2024-11-06 20:00:40 +02:00
20241031050638_add_custom_fields_to_chat.rb	FEATURE: add custom fields to chat (channel/message/thread) (#29504)	2024-11-01 09:12:19 +11:00
20241104053309_add_icon_upload_id_to_chat_channel.rb	DEV: sets an icon_upload_id on a channel (#29566)	2024-11-04 17:19:44 +09:00
20241110120303_add_blocks_to_chat_messages.rb	DEV: adds blocks support to chat messages (#29782)	2024-11-19 07:07:58 +01:00
20241111022618_create_chat_message_interactions.rb	DEV: adds blocks support to chat messages (#29782)	2024-11-19 07:07:58 +01:00
20241120182858_add_index_to_chat_messages_on_chat_channel_id.rb	DEV: Make sure chat migration is in plugin directory (#29867)	2024-11-20 14:50:15 -07:00
20241226162229_add_chat_send_shortcut_preference.rb	UX: adds chat send shortcut user preference (#30473)	2025-01-22 13:17:45 +01:00
20250220090521_add_last_unread_message_when_emailed_id_to_chat_thread_memberships.rb	FIX: delayed chat summary email (#31255)	2025-02-24 14:25:52 +04:00
20250307185912_add_chat_quick_reaction_preferences.rb	FEATURE: One-click chat reaction settings (#32150)	2025-04-04 09:15:13 +02:00
20250903091723_create_chat_message_search_data.rb	FEATURE: Add full-text search for chat messages (#34704)	2025-10-22 11:30:35 +02:00
20251119100000_add_starred_to_user_chat_channel_memberships.rb	FEATURE: Ability to star chat channels (#36142)	2025-12-03 09:25:08 -08:00
20251125101809_add_emoji_to_chat_channels.rb	FEATURE: chat channel emojis (#36288)	2025-11-28 10:09:08 +04:00
20251203000005_create_chat_message_links.rb	DEV: Fix duplicate migration version (#36469)	2025-12-05 11:22:21 +10:00
20251215125122_drop_icon_upload_id_from_chat_channels.rb	DEV: Promote old post-deploy migrations to pre-deploy (#38595)	2026-03-13 19:09:30 +00:00
20260122134202_create_chat_pinned_messages.rb	FEATURE: Pin chat messages (#37985)	2026-02-23 22:00:16 +01:00
20260122214226_add_last_viewed_pins_at_to_user_chat_channel_memberships.rb	FEATURE: Pin chat messages (#37985)	2026-02-23 22:00:16 +01:00
20260421061908_add_covering_index_on_chat_messages_thread_id.rb	PERF: speed up chat channel and thread unread queries (#39398)	2026-04-22 14:57:56 +10:00
20260623201925_add_chat_announce_new_messages_to_user_options.rb	A11Y: live announcements and optional sounds for chat messages (#41213)	2026-07-02 12:48:58 -04:00