Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Report Grid: investigate support for derived columns #6221

Closed
davidwatkins73 opened this issue Sep 7, 2022 · 0 comments
Closed

Report Grid: investigate support for derived columns #6221

davidwatkins73 opened this issue Sep 7, 2022 · 0 comments
Labels
fixed (test & close) An issue has been fixed, merged into master and is ready for further testing
Milestone
1.45

Comments

@davidwatkins73
Copy link
Member

Description

e.g. col C = if (col A == 'Y' & col B == 'Y') then "PASS" else "FAIL"

A main driver behind this to support 'insights', e.g. check app mappings for Payments Fn, Payments Process and Payments Data types, and calc a confidence %age.

Resourcing

We intend to contribute this feature
@davidwatkins73 davidwatkins73 added this to the todo : 1.45 milestone Sep 7, 2022
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@db-waltz
Report Grid: derived cols
943df2b 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@db-waltz
Report Grid: derived cols
fef1c0f 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
ratioProvided and checks to see columns exist
be473a3 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
renaming columnDefinitions to fixedColumnDefinitions and calculatedCo…
c338c39 
…lumnDefinitions to derivedColumnDefinitions

#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
renaming columnDefinitions to fixedColumnDefinitions and calculatedCo…
7f5120a 
…lumnDefinitions to derivedColumnDefinitions

-- Added percentageProvided

#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Add derived column table and rename to fixed cols
d3005e6 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Add kind to the report grid column
c8c097c 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Switching to rgcd table with fk between that and the derived/fixed co…
0335e6f 
…lumn tables

#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Fixing derived cells to use gridColumnId
6335b7e 
- adding a time function

#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Show derived columns in column list and attributes editable
a78cf2f 
#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Adding create derived column screen,
2c0e8c1 
- modift edit panel to just 2 columns

#CTCTOWALTZ-2558
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 20, 2022
@jessica-woodland-scott-db
Add external id to derived column editor
21a18ac 
#CTCTOWALTZ-2558
finos#6221
@davidwatkins73 davidwatkins73 mentioned this issue Sep 20, 2022
Merged
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Clear working values from the derived col editor
d8a411f 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Add external id to fixed column editor
e424ac1 
- clear off working copy for fixed cols

#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Get filter grid group populator to work with not provided filters
93b7736 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Pull mkaHeaderString out so less calculations of it
9cdb42b 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Tidy up
140605d 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Sep 23, 2022
@jessica-woodland-scott-db
Add endpoint for recalculating only one group from report filters
a4566dc 
#CTCTOWALTZ-2560
finos#6221
@davidwatkins73 davidwatkins73 mentioned this issue Sep 23, 2022
Merged
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 5, 2022
@jessica-woodland-scott-db
Add string filter into grid filters
69688e7 
- Change format of filter text

#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 5, 2022
@jessica-woodland-scott-db
Add string filter into grid filters
b78b363 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 5, 2022
@jessica-woodland-scott-db
Rename to contains any option
ec1dd90 
#CTCTOWALTZ-2560
finos#6221
@davidwatkins73 davidwatkins73 mentioned this issue Oct 5, 2022
Merged
@davidwatkins73 davidwatkins73 modified the milestones: wip : 1.45, done : 1.45 Oct 5, 2022
@davidwatkins73 davidwatkins73 added the fixed (test & close) An issue has been fixed, merged into master and is ready for further testing label Oct 5, 2022
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 5, 2022
@jessica-woodland-scott-db
Add endpoint to recalculate group and page to display success
72107e3 
#CTCTOWALTZ-2560
finos#6221
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 5, 2022
@jessica-woodland-scott-db
Modify freemarker template so doesn't rely on linked styles
26d3abc 
#CTCTOWALTZ-2560
finos#6221
@davidwatkins73 davidwatkins73 mentioned this issue Oct 5, 2022
Merged
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Oct 17, 2022
@jessica-woodland-scott-db
Fix foreign keys on grid col tables
86cd44e 
- remove time function from RGEndpoint, fixing test

#CTCTOWATLZ-2558
finos#6221
@davidwatkins73 davidwatkins73 mentioned this issue Oct 18, 2022
Merged
@davidwatkins73 davidwatkins73 modified the milestones: done : 1.45, 1.45 Nov 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
fixed (test & close) An issue has been fixed, merged into master and is ready for further testing
Projects
None yet
Milestone
1.45
Development

No branches or pull requests
1 participant
@davidwatkins73