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

Support tag columns/filters in report builder

    XMLWordPrintable

Details

    • MOODLE_400_STABLE
    • MOODLE_401_STABLE
    • Hide

      Course tags

      1. Log in as admin
      2. Create three new courses, with tags as follows:
        • Course one; tags: cat, dog, fish
        • Course two; tags: cat, horse
        • Course three;
      3. Navigate to Reports > Report builder > Custom reports in site administration
      4. Create a new report from the Courses report source
        • Ensure Include default setup is unchecked
      5. In report editor, add the following columns:
        • Course > Course full name
        • Course > Tags
      6. Confirm report shows all courses and corresponding tags
      7. Change aggregation for Tags column to Comma separated values
      8. Confirm report shows each course with aggregated tags
      9. Add the following report condition:
        • Course > Tags
      10. Set condition to Is not empty and apply
      11. Confirm report shows only those courses with tags
      12. Set condition to Is equal to
      13. Confirm the autocomplete shows all available course tags
      14. Select "dog" and "cat" tags and apply
      15. Confirm report shows only those courses matching given tags

      User interests

      1. Create two new users, with interests as follows:
        • User one; interests: tomato, rice, ketchup
        • User two; interests: rice, potato
      2. Navigate to Reports > Report builder > Custom reports in site administration
      3. Create a new report from the Users report source
        • Ensure Include default setup is unchecked
      4. In report editor, add the following columns:
        • User > Full name
        • User > Interests
      5. Confirm report shows all users and corresponding interests
      6. Change aggregation for Interests column to Comma separated values
      7. Confirm report shows each user with aggregated interests
      8. Add the following report condition:
        • User > Interests
      9. Set condition to Is not empty and apply
      10. Confirm report shows only those users with interests
      11. Set condition to Is equal to
      12. Confirm the autocomplete shows all available user interests
      13. Select "potato" interest and apply
      14. Confirm report shows only those users matching given interests
      Show
      Course tags Log in as admin Create three new courses, with tags as follows: Course one; tags: cat, dog, fish Course two; tags: cat, horse Course three; Navigate to Reports > Report builder > Custom reports in site administration Create a new report from the Courses report source Ensure Include default setup is unchecked In report editor, add the following columns: Course > Course full name Course > Tags Confirm report shows all courses and corresponding tags Change aggregation for Tags column to Comma separated values Confirm report shows each course with aggregated tags Add the following report condition: Course > Tags Set condition to Is not empty and apply Confirm report shows only those courses with tags Set condition to Is equal to Confirm the autocomplete shows all available course tags Select "dog" and "cat" tags and apply Confirm report shows only those courses matching given tags User interests Create two new users, with interests as follows: User one; interests: tomato, rice, ketchup User two; interests: rice, potato Navigate to Reports > Report builder > Custom reports in site administration Create a new report from the Users report source Ensure Include default setup is unchecked In report editor, add the following columns: User > Full name User > Interests Confirm report shows all users and corresponding interests Change aggregation for Interests column to Comma separated values Confirm report shows each user with aggregated interests Add the following report condition: User > Interests Set condition to Is not empty and apply Confirm report shows only those users with interests Set condition to Is equal to Confirm the autocomplete shows all available user interests Select "potato" interest and apply Confirm report shows only those users matching given interests

    Description

      We have a tags filter type in Workplace, which is generic enough that it should belong in Moodle

      Update the user & course entities/report sources to add tag column and filters

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              pholden Paul Holden
              Carlos Castillo Carlos Castillo
              Sara Arjona (@sarjona) Sara Arjona (@sarjona)
              Gladys Basiana Gladys Basiana
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 7 hours
                  7h

                  Clockify

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