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

Backpacks sortorder is not updated properly

XMLWordPrintable

    • MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE
    • MOODLE_310_STABLE, MOODLE_39_STABLE
    • MDL-70913-master
    • Hide

      Before applying the patch

      1. Login as admin.
      2. Access to "Site administration > Badges > Manage backpacks"
      3. Add a new backpack. You can use dummy values for the required form fields (for instance, http://test.cat for both URLs).
      4. Run the following SQL query and check the sortorder column has the same value ("1") for the 2 entries returned.

        SELECT id, backpackweburl, sortorder FROM mdl_badge_external_backpack

      After applying the patch

      1. Apply the patch.
      2. Login as admin and run the upgrade process.
      3. Access to "Site administration > Badges > Manage backpacks"
      4. Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://toberemoved.cat for both URLs).
      5. Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://otherurl.cat for both URLs).
      6. Remove the backpack created in step #4 (http://toberemoved.cat).
      7. Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://lasturl.cat for both URLs).
      8. Run the following SQL query and check the sortorder column has a different value of each field now (the one with lower id should have 1, the one you created before applying the patch should contain 2, the one you created in step #5 should have 4 and the latest one you created should contain 5).

        SELECT id, backpackweburl, sortorder FROM mdl_badge_external_backpack

      9. Check the backpacks are displayed following the previous sortorder column in page "Manage backpacks" (lower sortorder rows should be displayed first).
      10. Go to "Site administration > Badges > Backpack settings".
      11. Check the backpacks in "Active external backpack" are displayed following the sortorder column (lower sortorder rows should be displayed first in that list).

       

      Show
      Before applying the patch Login as admin. Access to "Site administration > Badges > Manage backpacks" Add a new backpack. You can use dummy values for the required form fields (for instance, http://test.cat  for both URLs). Run the following SQL query and  check the sortorder column has the same value ("1") for the 2 entries returned. SELECT id, backpackweburl, sortorder FROM mdl_badge_external_backpack After applying the patch Apply the patch. Login as admin and run the upgrade process. Access to "Site administration > Badges > Manage backpacks" Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://toberemoved.cat  for both URLs). Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://otherurl.cat  for both URLs). Remove the backpack created in step #4 ( http://toberemoved.cat ). Add a new backpack. You can use dummy values for the required form fields, different from the previous one (for instance, http://lasturl.cat  for both URLs). Run the following SQL query and  check the sortorder column has a different value of each field now (the one with lower id should have 1, the one you created before applying the patch should contain 2, the one you created in step #5 should have 4 and the latest one you created should contain 5). SELECT id, backpackweburl, sortorder FROM mdl_badge_external_backpack Check the backpacks are displayed following the previous sortorder column in page "Manage backpacks" (lower sortorder rows should be displayed first). Go to "Site administration > Badges > Backpack settings". Check the backpacks in "Active external backpack" are displayed following the sortorder column (lower sortorder rows should be displayed first in that list).  
    • Moppies Kanban

      The "sortorder" field in badge_external_backpack table is not updated as expected. Steps to reproduce:

      1. Access to Manage backpacks
      2. Create a backpack with any value (you can use, for instance, http://google.cat in both URL fields).
      3. Check the value for the "sortorder" field in {badge_external_backpack} table.

      Expected result

      The sortorder is higher than the max(sortorder) field.

      Current result

      The sortorder is exactly the count(sortorder) field.

       

      Besides, external backpacks in "Manage backpack" site administration page should be ordered by this sortorder field.

            sarjona Sara Arjona (@sarjona)
            sarjona Sara Arjona (@sarjona)
            Amaia Anabitarte Amaia Anabitarte
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Janelle Barcega Janelle Barcega
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours, 50 minutes
                3h 50m

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