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

database activity, date fields: impossible to avoid searching by them

XMLWordPrintable

    • Any
    • MOODLE_20_STABLE, MOODLE_23_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • wip-MDL-25275-master
    • Moderate
    • Hide
      1. Create a database activity.
      2. Add some fields, one of which is a date field.
      3. Add the date field into the 'Advanced search template' (make sure to save the templates for the single and list sections).
      4. Add data into the database, some with different dates.
      5. Click on the Search tab.
      6. Save settings with "Use this date in the search?" un-ticked.
        All of the entries should be displayed
      7. Tick the "Use this date in the search?" box.
        The search should now be limited to entries with that specific date
      Show
      Create a database activity. Add some fields, one of which is a date field. Add the date field into the 'Advanced search template' (make sure to save the templates for the single and list sections). Add data into the database, some with different dates. Click on the Search tab. Save settings with "Use this date in the search?" un-ticked. All of the entries should be displayed Tick the "Use this date in the search?" box. The search should now be limited to entries with that specific date

      While doing various fixes related to MDL-21437, in order to get the database module working ok under mssql/oracle DBs, this problem has been revealed:

      1) Create one database activity
      2) Add some fields to them, on pupose add one "date" field.
      3) Fill some records.
      4) Go to the advanced search tab

      Current behavior:

      • The date field appears in the advanced search, filled with current date, and it is impossible to take it out from the search.

      Expected behavior:

      • Near to de the DD/MM/YYYY field should be one checkbox to control if the search must include the date or no, defaulting to no (unchecked and DD/MM/YYYY disabled).

      Known workaround:

      • Edit the advanced search template and take out any date field. Imperfect because then the activity cannot be searched by date fields, but at least doesn't break all the searches.

      Ciao

            abgreeve Adrian Greeve
            stronk7 Eloy Lafuente (stronk7)
            Sam Hemelryk Sam Hemelryk
            Rossiani Wijaya Rossiani Wijaya
            Votes:
            3 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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