| Step Description | Expected result |
|---|---|
| Go to advanced Parameters > Database > SQL Manager | SQL Manager page is well displayed the SQL Manager table is empty = 0 |
| create 20 new SQL query | SQL Manager page is well displayed the SQL Manager table = 20 |
| Reset all filters | All filters are reset , the query sql are displayed |
| Sort SQL Manager by ID desc | SQL Manager are sorted by ID (4 -> 3 -> …) |
| Sort SQL Manager by ID asc | SQL Manager are sorted by ID (1 -> 2 -> 3…) |
| Sort SQL Manager by SQL query name desc | SQL Manager are sorted by SQL query name ( z-> y -> …) |
| Sort SQL Manager by SQL query name asc | SQL Manager are sorted by SQL query name ( a-> b ->c …) |
| Sort SQL Manager by SQL query desc | SQL Manager are sorted by SQL query ( z-> y -> …) |
| Sort SQL Manager by SQL query asc | SQL Manager are sorted by SQL query ( a-> b ->c …) |
| Filter by ID | SQL Manager list is filtered by ID=3 |
| Filter by SQL query name | SQL Manager list is filtered by SQL query name =test |
| Filter by SQL query | SQL Manager list is filtered by SQL query = select * from ps_access |
| Change the items number to 10 per page | 2 pages are displayed (page 1/2) |
| Go to page 2 | 2 pages are displayed (page 2/2) |
| Change the items number to 100 per page | Only one page is displayed (page 1 / 1) |
| Delete created sql query by bulk actions |