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

Actor: assign UID to extId on creation #6578

Closed
davidwatkins73 opened this issue Apr 28, 2023 · 1 comment
Closed

Actor: assign UID to extId on creation #6578

davidwatkins73 opened this issue Apr 28, 2023 · 1 comment
Labels
fixed (test & close) An issue has been fixed, merged into master and is ready for further testing noteworthy probably worth mentioning in release notes
Milestone
1.49

Comments

@davidwatkins73
Copy link
Member

Description

currenlty there are no immutable external ids for actors. We should autoassign one if not provided.

Resourcing

We would like to add this request to the Waltz team's feature backlog
@davidwatkins73 davidwatkins73 added this to the todo : 1.49 milestone Apr 28, 2023
@davidwatkins73 davidwatkins73 added the waiting on contribution Issue has been fixed, however the code has not _yet_ made it's way upstream label Apr 28, 2023
@davidwatkins73
Copy link
Member Author

Script to update existing actors:

update actor
set external_id = lower(newid())
where external_id is null;

@davidwatkins73 davidwatkins73 added the noteworthy probably worth mentioning in release notes label Apr 29, 2023
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue May 2, 2023
@db-waltz
Adding external identifiers to Actors
1daab67 
To update existing actors use this script:

```
update actor
set external_id = lower(newid())
where external_id is null;
```

#CTCTOWALTZ-2700
finos#6578
Merged
@jessica-woodland-scott-db jessica-woodland-scott-db added fixed (test & close) An issue has been fixed, merged into master and is ready for further testing and removed waiting on contribution Issue has been fixed, however the code has not _yet_ made it's way upstream labels May 2, 2023
@davidwatkins73 davidwatkins73 modified the milestones: done : 1.49, 1.49 May 10, 2023
@davidwatkins73 davidwatkins73 mentioned this issue Aug 10, 2023
Closed
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 noteworthy probably worth mentioning in release notes
Projects
None yet
Milestone
1.49
Development

No branches or pull requests
2 participants
@davidwatkins73 @jessica-woodland-scott-db