bcgov / MFIN-Data-Catalogue

The Finance Data Catalogue enables users to discover data holdings at the BC Ministry of Finance and offers information and functionality that benefits consumers of data for business purposes. The product is built using Drupal and adheres to the Government of BC's Core Metadata Standard.
Other
6 stars 0 forks source link

Build a report builder #395

Closed CraigClark closed 2 months ago

CraigClark commented 3 months ago

OP timer

https://openplus.monday.com/boards/4092908516/pulses/6313583751


on the reports section of the dashboard, create a 'Report builder' tab.

This will be a view with exposed filters. The filters allow people to create their own reports and export to csv.

This should be done as a view and discussed with Nicole before refining. I am not confident that this will offer much more than what the search page does now. Some experimenting will help determine that.

CraigClark commented 2 months ago

@NicoledeGreef

First version of this is done at https://github.com/bcgov/MFIN-Data-Catalogue/tree/395-report-builder.

This is using 'out of the box' views features. If this is approved, there are some things that should be done to improve it.

To do

Issues

CraigClark commented 2 months ago

Sample of exported report report-builder-example.xlsx

NicoledeGreef commented 2 months ago

Please remove the item in the list related to Review status value "Active" and remove the count of records that use the asset being reported on.

CraigClark commented 2 months ago

@lkmorlan as part of this, There is are custom buttons to scroll the table because the browser scrollbar isn't always obvious. When it is, you need to scroll from the bottom of the table of your mouse does not support swiping left or right.

There is an addition to the costom module that needs to be reviewed/merged here https://github.com/bcgov/bcbb/tree/395-dc-table-scroll

I have attached the library to the base theme here https://github.com/bcgov/bcbb-theme/tree/395-dc-report-builder, this was an arbitrary decision. If you think it better to attach to dc theme that's fine.

CraigClark commented 2 months ago

Related #439

This has been deployed to dev for review

NicoledeGreef commented 2 months ago

reviewed in dev. closing ticket