Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-38427

Forums > new settings to disable email notifications at the topic level

    Details

    • Type: Feature Request
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 12.0, 19.0
    • Fix Version/s: 19.0
    • Component/s: Forums Tool
    • Labels:
      None
    • Conversion Script Required:
      Yes
    • Test Plan:
      Hide
      1. Create a topic; uncheck the setting for 'Include contents of messages in email notifications'
      2. Create a conversation in this topic; post to it as one or more users
      3. Verify that email is sent, but the contents of the post(s) are not included in the emails
      4. Create a second topic; uncheck the setting for 'Allow email notifications for new messages'
      5. Create a conversation in this topic; post to it as one or more users
      6. Verify that no email is received
      Show
      Create a topic; uncheck the setting for 'Include contents of messages in email notifications' Create a conversation in this topic; post to it as one or more users Verify that email is sent, but the contents of the post(s) are not included in the emails Create a second topic; uncheck the setting for 'Allow email notifications for new messages' Create a conversation in this topic; post to it as one or more users Verify that no email is received

      Description

      The linked PR introduces two new settings at the topic level:

      • Allow email notifications for new messages
      • Include contents of messages in email notifications

      This new feature arose out of a faculty member request, who was concerned about the security of sensitive forum data being sent in plain text via email.

      Both settings default to the enabled state to preserve OOTB functionality.

      MySQL conversion script:

      ALTER TABLE MFR_TOPIC_T ADD COLUMN ALLOW_EMAIL_NOTIFICATIONS BIT(1) NOT NULL DEFAULT 1;
      ALTER TABLE MFR_TOPIC_T ADD COLUMN INCLUDE_CONTENTS_IN_EMAILS BIT(1) NOT NULL DEFAULT 1;
      

      Oracle conversion script:

      ALTER TABLE MFR_TOPIC_T ADD ALLOW_EMAIL_NOTIFICATIONS NUMBER(1,0) DEFAULT 1 NOT NULL;
      ALTER TABLE MFR_TOPIC_T ADD INCLUDE_CONTENTS_IN_EMAILS NUMBER(1,0) DEFAULT 1 NOT NULL;
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  bjones86 Brian Jones
                  Reporter:
                  bjones86 Brian Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code