Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-76715

When all fields are removed all entries should be also removed

XMLWordPrintable

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE, MOODLE_402_STABLE
    • MDL-76715-401
    • MDL-76715-master
    • Hide

      For easier testing use a new Moodle instance with no Database activities created.

      Before applying the patch:

      1. Create a course
      2. Create a Database activity in the course
      3. Go to Presets and Use 'Journal' preset.
      4. Go to Database and create a couple of entries
      5. Go to Fields and delete all the fields of the database one by one
      6. Execute following query on the database:

      SELECT * FROM mdl_data_records;

      1. Confirm the result of the query is not empty.

      Test

      1. Apply the patch and upgrade Moodle instance
      2. Execute following query on the database:

      SELECT * FROM mdl_data_records;

      1. Confirm the result of the query is empty.
      2. Create a Database activity in the course (or use the same as before)
      3. Go to Presets and Use 'Journal' preset.
      4. Go to Database and create a couple of entries
      5. Go to Fields and delete all the fields of the database one by one
      6. Execute following query on the database:

      SELECT * FROM mdl_data_records;

      1. Confirm the result of the query is empty.
      Show
      For easier testing use a new Moodle instance with no Database activities created. Before applying the patch: Create a course Create a Database activity in the course Go to Presets and Use 'Journal' preset. Go to Database and create a couple of entries Go to Fields and delete all the fields of the database one by one Execute following query on the database: SELECT * FROM mdl_data_records; Confirm the result of the query is not empty. Test Apply the patch and upgrade Moodle instance Execute following query on the database: SELECT * FROM mdl_data_records; Confirm the result of the query is empty . Create a Database activity in the course (or use the same as before) Go to Presets and Use 'Journal' preset. Go to Database and create a couple of entries Go to Fields and delete all the fields of the database one by one Execute following query on the database: SELECT * FROM mdl_data_records; Confirm the result of the query is empty .
    • HQ 2023 Sprint i2.1 Moppies

      Step 1.
      The database has fields with field names 'image', 'title' and 'description', and an entry exists.
      Step 2.
      Select a preset that does not have a field name that is the same as a field name in the current database.
      Step 3.
      Make sure all current fields are eligible for deletion and apply for the preset.
      Step 4. Confirm that the preset has been applied and the fields have changed.
      Step 5. I don't see any entries, but there is no zero state view because an entry still exists on the database (mdl_data_records table)

      Since the attachment icon has disappeared, I will attach the image after creating the issue.

        1. addentrybutton.png
          addentrybutton.png
          707 kB
        2. MDL-76715.png
          MDL-76715.png
          312 kB

            amaia Amaia Anabitarte
            r-yamada Ryotaro Yamada
            Carlos Escobedo Carlos Escobedo
            Ferran Recio Ferran Recio
            Ron Carl Alfon Yu Ron Carl Alfon Yu
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 days, 5 hours, 34 minutes
                3d 5h 34m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.