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

Sorting database module entries by certain fields shows no results

XMLWordPrintable

    • MOODLE_311_STABLE, MOODLE_32_STABLE, MOODLE_33_STABLE, MOODLE_400_STABLE
    • MOODLE_311_STABLE, MOODLE_400_STABLE
    • MDL-59458-master
    • Hide
      1. Create a new database activity
      2. Use the default preset "Image gallery"
      3. Add two entries:
      4. Entry 1 / Description: Entry 1 / Alternative text: Entry 1
      5. Entry 2 / Description: caption / Alternative text: Entry 2
      6. Go to "Templates", Reset templates and Save changes.
      7. Go to the list view.
      8. Type 'caption' in search box.
      9. Press 'Save settings'.
      10. Ensure that search results show matched items with 'caption' in description (Entry 2).
      11. Now change 'Sort by' to 'title' for example.
      12. Press 'Save settings'.
      13. Ensure that search results show matched items with 'caption' in description (Entry 2).
      14. Remove all search parameters
      15. Click on advanced search
      16. Enter "caption" in the description field of the advanced search query
      17. Sort by "title"
      18. Save settings
      19. Ensure that search results show matched items with 'caption' in description (Entry 2).
      Show
      Create a new database activity Use the default preset "Image gallery" Add two entries: Entry 1 / Description: Entry 1 / Alternative text: Entry 1 Entry 2 / Description: caption / Alternative text: Entry 2 Go to "Templates", Reset templates and Save changes. Go to the list view. Type 'caption' in search box. Press 'Save settings'. Ensure that search results show matched items with 'caption' in description (Entry 2). Now change 'Sort by' to 'title' for example. Press 'Save settings'. Ensure that search results show matched items with 'caption' in description (Entry 2). Remove all search parameters Click on advanced search Enter "caption" in the description field of the advanced search query Sort by "title" Save settings Ensure that search results show matched items with 'caption' in description (Entry 2).
    • 2
    • HQ Sprint 0.2 Database

      Steps to recreate problem:

      1. Create a new database activity
      2. Use the default preset "Image gallery"
      3. Add two entries:
        1. Entry 1 / Description: Entry 1 / Alternative text: Entry 1
        2. Entry 2 / Description: caption / Alternative text: Entry 2
      4. Go to the list view
        1. Type 'caption' in search box. Press 'Save settings'. Search results show matched items with 'caption' in the description (Entry 2).
        2. Now change 'Sort by' to 'title' for example. Press 'Save settings'.
      5. Result: 'No records found'

       

        1. database_error.png
          database_error.png
          118 kB
        2. MDL-59458_master_1.png
          MDL-59458_master_1.png
          121 kB
        3. MDL-59458_master_2.png
          MDL-59458_master_2.png
          119 kB
        4. MDL-59458_master_3.png
          MDL-59458_master_3.png
          118 kB
        5. MDL-59458_v311_1.png
          MDL-59458_v311_1.png
          97 kB
        6. MDL-59458_v311_2.png
          MDL-59458_v311_2.png
          95 kB
        7. MDL-59458_v311_3.png
          MDL-59458_v311_3.png
          100 kB
        8. MDL-59458_v400_1.png
          MDL-59458_v400_1.png
          80 kB
        9. MDL-59458_v400_2.png
          MDL-59458_v400_2.png
          79 kB
        10. MDL-59458_v400_3.png
          MDL-59458_v400_3.png
          87 kB

            laurent.david@moodle.com Laurent David
            amanda.doughty Amanda Doughty
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Amaia Anabitarte Amaia Anabitarte
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 3 hours, 37 minutes
                1d 3h 37m

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