Proyectos de Subversion Moodle

@core_reportbuilder @javascript

Feature: Manage custom report filters

  In order to manage the filters of custom reports

  As an admin

  I need to add, edit and delete filters in a report

  Scenario: Add filter to report

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    When I click on "Show/hide 'Filters'" "button"

    Then I should see "There are no filters selected" in the "[data-region='active-filters']" "css_element"

    And I set the field "Select a filter" to "Email address"

    And I should see "Added filter 'Email address'"

    And I should not see "There are no filters selected" in the "[data-region='active-filters']" "css_element"

    And I should see "Email address" in the "[data-region='active-filters']" "css_element"

  Scenario: Rename filter in report

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:email       |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I click on "Show/hide 'Filters'" "button"

    When I set the field "Rename filter 'Email address'" to "My Email filter"

    And I reload the page

    And I click on "Show/hide 'Filters'" "button"

    Then I should see "My Email filter" in the "[data-region='active-filters']" "css_element"

  Scenario: Rename filter in report using filters

    Given the "multilang" filter is "on"

    And the "multilang" filter applies to "content and headings"

    And the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:email       |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I click on "Show/hide 'Filters'" "button"

    When I set the field "Rename filter 'Email address'" to "<span class=\"multilang\" lang=\"en\">English</span><span class=\"multilang\" lang=\"es\">Spanish</span>"

    And I reload the page

    And I click on "Show/hide 'Filters'" "button"

    Then I should see "English" in the "[data-region='active-filters']" "css_element"

    And I should not see "Spanish" in the "[data-region='active-filters']" "css_element"

  Scenario: Rename filter in report using special characters

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:email       |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I click on "Show/hide 'Filters'" "button"

    When I set the field "Rename filter 'Email address'" to "Fish & Chips"

    And I click on "Switch to preview mode" "button"

    And I click on "Filters" "button"

    Then I should see "Fish & Chips" in the "[data-region='report-filters']" "css_element"

  Scenario: Move filter in report

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:fullname    |

      | My report | user:email       |

      | My report | user:country     |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    When I click on "Show/hide 'Filters'" "button"

    And I click on "Move filter 'Country'" "button"

    And I click on "After \"Full name\"" "link" in the "Move filter 'Country'" "dialogue"

    Then I should see "Moved filter 'Country'"

    And "Country" "text" should appear before "Email address" "text"

  Scenario: Delete filter from report

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:email       |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I click on "Show/hide 'Filters'" "button"

    And I click on "Delete filter 'Email address'" "button"

    And I click on "Delete" "button" in the "Delete filter 'Email address'" "dialogue"

    Then I should see "Deleted filter 'Email address'"

    And I should see "There are no filters selected" in the "[data-region='active-filters']" "css_element"

    And I should not see "Email address" in the "[data-region='active-filters']" "css_element"

  Scenario: Reset filters in report

    Given the following "core_reportbuilder > Reports" exist:

      | name      | source                                   |

      | My report | core_user\reportbuilder\datasource\users |

    And I am on the "My report" "reportbuilder > View" page logged in as "admin"

    When I click on "Filters" "button"

    And I set the following fields in the "Full name" "core_reportbuilder > Filter" to these values:

      | Full name operator | Contains |

      | Full name value    | Lionel   |

    And I click on "Apply" "button" in the "[data-region='report-filters']" "css_element"

    And I should see "Nothing to display"

    And I click on "Reset all" "button" in the "[data-region='report-filters']" "css_element"

    Then I should see "Filters reset"

    And the following fields in the "Full name" "core_reportbuilder > Filter" match these values:

      | Full name operator | Is any value |

    And I should see "Admin User" in the "reportbuilder-table" "table"

  Scenario: Use report filters when previewing report

    Given the following "users" exist:

      | username  | firstname | lastname |

      | user1     | User      | 1        |

      | user2     | User      | 2        |

      | user3     | User      | 3        |

    And the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Columns" exist:

      | report    | uniqueidentifier  |

      | My report | user:fullname     |

      | My report | user:email        |

    And the following "core_reportbuilder > Filters" exist:

      | report    | uniqueidentifier |

      | My report | user:fullname    |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I change window size to "large"

    And I should see "user1@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user2@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user3@example.com" in the ".reportbuilder-table" "css_element"

    When I click on "Switch to preview mode" "button"

    And I click on "Filters" "button"

    And I set the following fields in the "Full name" "core_reportbuilder > Filter" to these values:

      | Full name operator | Does not contain |

      | Full name value    | User 2           |

    And I click on "Apply" "button" in the "[data-region='report-filters']" "css_element"

    Then I should see "Filters applied"

    And I should see "Filters (1)" in the "#dropdownFiltersButton" "css_element"

    And the following should exist in the "reportbuilder-table" table:

      | Full name | Email address     |

      | User 1    | user1@example.com |

      | User 3    | user3@example.com |

    And the following should not exist in the "reportbuilder-table" table:

      | Full name | Email address     |

      | User 2    | user2@example.com |

    # Switching back to edit mode should not apply filters.

    And I click on "Switch to edit mode" "button"

    And I should see "user1@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user2@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user3@example.com" in the ".reportbuilder-table" "css_element"

  Scenario: Use report filters when previewing report that contains same condition

    Given the following "users" exist:

      | username  | firstname | lastname |

      | user1     | User   | 1        |

      | user2     | User   | 2        |

      | user3     | User   | 3        |

    And the following "core_reportbuilder > Reports" exist:

      | name      | source                                   | default |

      | My report | core_user\reportbuilder\datasource\users | 0       |

    And the following "core_reportbuilder > Columns" exist:

      | report    | uniqueidentifier  |

      | My report | user:fullname     |

      | My report | user:email        |

    And the following "core_reportbuilder > Condition" exists:

      | report           | My report  |

      | uniqueidentifier | user:email |

    And the following "core_reportbuilder > Filter" exists:

      | report           | My report  |

      | uniqueidentifier | user:email |

    And I am on the "My report" "reportbuilder > Editor" page logged in as "admin"

    And I change window size to "large"

    And I should see "user1@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user2@example.com" in the ".reportbuilder-table" "css_element"

    And I should see "user3@example.com" in the ".reportbuilder-table" "css_element"

    # Set a condition to the report.

    When I click on "Show/hide 'Conditions'" "button"

    And I set the following fields in the "Email address" "core_reportbuilder > Condition" to these values:

      | Email address operator | Is not equal to   |

      | Email address value    | user3@example.com |

    And I click on "Apply" "button" in the "#settingsconditions" "css_element"

    And I click on "Switch to preview mode" "button"

    And I click on "Filters" "button"

    And I set the following fields in the "Email address" "core_reportbuilder > Filter" to these values:

      | Email address operator | Is not equal to   |

      | Email address value    | user2@example.com |

    And I click on "Apply" "button" in the "[data-region='report-filters']" "css_element"

    Then I should see "Filters applied"

    And I should see "Filters (1)" in the "#dropdownFiltersButton" "css_element"

    # Assert we haven't overridden the condition and user3 is still not showing in the report.

    And the following should exist in the "reportbuilder-table" table:

      | Full name | Email address     |

      | User 1    | user1@example.com |

    And the following should not exist in the "reportbuilder-table" table:

      | Full name | Email address     |

      | User 2    | user2@example.com |

      | User 3    | user3@example.com |