bcgov / bcgov/parks-data-register

Change Null/Missing Excel Columns for Easier Filtering

Open
#533 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
5
Forks
7
PR merge metrics
No merged PRs in 30d

Description

#### Description:

When I open up a recently downloaded Null/Missing export, I would like to see the Bundle, Park, Subarea, and Months in separate columns so it's easier to filter the data.

Right now, the Bundle, Park, Subarea and Months are in rows, but it would be easier to filter the data if these items were in columns instead.

#### Acceptance Criteria:

Given I am an A&R user
When I export the A&R Missing data
Then I get an excel spreadsheet where the Bundle, Park, Subarea, and Months are in separate columns

#### Development Checklist:

- [ ] Bundle, Park, Subarea, and Months are in separate columns
- [ ] The Activities and Years are in the same format

**Definition of Ready** (Note: If any of these points are not applicable, mark N/A)

- [ ] User story is included
- [ ] User role and type are identified
- [ ] Acceptance criteria are included
- [ ] Wireframes are included
- [ ] Design / Solution is accepted by Product Owner
- [ ] Dependencies are identified (technical, business, regulatory/policy)
- [ ] Story has been estimated (under 13 pts)

**Definition of Done**
- In progress:
- [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
- [ ] UI meets accessibility requirements
- [ ] Unit tests are written
- [ ] Work is traceable in GitHub
- [ ] PR linked to ticket number
- [ ] If needed/required - Dev adds flag/label to highlight any migration steps necessary prior to PROD deployment
- Code review:
- [ ] Code is peer reviewed and has passed CI/CD tests
- QA:
- [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
- [ ] Code is potentially shippable to the production environment
- [ ] Functional features have been tested and passed by QA
- [ ] UI components tested by designer
- [ ] Code is deployed to PROD when moved to 'done' column (unless requested otherwise by PO)
- PO Review:
- [ ] Acceptance criteria are tested (Functionality meets the acceptance criteria defined in the ticket)
- [ ] Reviewed and approved by Product Owner

#### Notes:
-
-

Contributor guide

No contributing guide indexed for this repository

Research direction

No file or test is identified in the issue. Start by locating the A&R Missing export and comparing its output with the Activities and Years formats; done means the Excel export places Bundle, Park, Subarea, and Months in separate filterable columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
data
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.