| Summary: | ERM eUsage reports : data table filter does not work | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Michaela Sieber <michaela.sieber> |
| Component: | ERM | Assignee: | Matt Blenkinsop <matt.blenkinsop> |
| Status: | Signed Off --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | david, ddaghita, jonathan.druart, jonathan.field, martin.renvoize, matt.blenkinsop, pedro.amorim |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| Change sponsored?: | --- | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Attachments: |
Test file - TR_J1
Bug 36925: Remove filtering from usage reports Screenshot - Export option NOT visible after the patch is applied Bug 36925: Reinstate export button Bug 36925: Remove filtering from usage reports Bug 36925: Reinstate export button Bug 36925: Remove filtering from usage reports Bug 36925: Reinstate export button |
||
|
Description
Michaela Sieber
2024-05-22 12:51:03 UTC
Created attachment 167544 [details]
Test file - TR_J1
Created attachment 167545 [details] [review] Bug 36925: Remove filtering from usage reports The query behind a usage report is too complex for the datatables filtering options and so should be removed until we can add some datatables utility methods to assist with the filtering Test plan: 1) Navigate to E-resource management > eUsage > Data providers 2) Create a provider 3) Click into the provider and navigate to the Manual upload tab 4) Upload the file attached 5) Navigate to the Reports section in the left hand menu 6) Run a report that returns some data from the harvested file (report type is TR_J1) 7) Try to filter the table using the filter inputs, it will fail 8) Apply patch 9) Run yarn js:build to rebuild the Javascript 10) Hard refresh the browser 11) The filter options should not not be in the table The query behind the reports table is too complex for the datatable filtering so in the short term we need to switch the filtering off. Reports can be exported to excel for filtering / analysis Created attachment 167592 [details]
Screenshot - Export option NOT visible after the patch is applied
This works, however the 'Export' button/link is not there after the patch. See the attached screenshot.
Created attachment 167856 [details] [review] Bug 36925: Reinstate export button Created attachment 167857 [details] [review] Bug 36925: Remove filtering from usage reports The query behind a usage report is too complex for the datatables filtering options and so should be removed until we can add some datatables utility methods to assist with the filtering Test plan: 1) Navigate to E-resource management > eUsage > Data providers 2) Create a provider 3) Click into the provider and navigate to the Manual upload tab 4) Upload the file attached 5) Navigate to the Reports section in the left hand menu 6) Run a report that returns some data from the harvested file (report type is TR_J1) 7) Try to filter the table using the filter inputs, it will fail 8) Apply patch 9) Run yarn js:build to rebuild the Javascript 10) Hard refresh the browser 11) The filter options should not not be in the table Created attachment 167858 [details] [review] Bug 36925: Reinstate export button Created attachment 167862 [details] [review] Bug 36925: Remove filtering from usage reports The query behind a usage report is too complex for the datatables filtering options and so should be removed until we can add some datatables utility methods to assist with the filtering Test plan: 1) Navigate to E-resource management > eUsage > Data providers 2) Create a provider 3) Click into the provider and navigate to the Manual upload tab 4) Upload the file attached 5) Navigate to the Reports section in the left hand menu 6) Run a report that returns some data from the harvested file (report type is TR_J1) 7) Try to filter the table using the filter inputs, it will fail 8) Apply patch 9) Run yarn js:build to rebuild the Javascript 10) Hard refresh the browser 11) The filter options should not not be in the table Signed-off-by: David Nind <david@davidnind.com> Created attachment 167863 [details] [review] Bug 36925: Reinstate export button Signed-off-by: David Nind <david@davidnind.com> One minor note, but wasn't a blocker for me: The Export link is now just after Last >>, rather than aligned to the far right. Testing notes (using KTD): 1. Details I used for a report (step 6). Go to Reports > Create report and use these values for the options: Data display: By year Choose data provide: [The provider you created in step 2] Choose report: TR_J1.... Start year: 2020 End year: 2024 Select report columns: select all available columns to display (I saved the report: enter a name for the report and the "Save report".) What's the problem exactly with the filtering? |