Thanks Chad - I'll take a look at those suggestions! On Tuesday, August 22, 2023 at 10:11:07 AM UTC+1 Chad Wilson wrote:
> Yeah, they are in the DB keyed to the user's id: > https://github.com/gocd/gocd/blob/0f58107c851cf2df6ce7c6902eebde796dc1f742/db-support/db-migration/src/main/resources/db-migration-scripts/initial/create-schema.xml#L291-L303 > > > While it comes with some risks, it probably wouldn't be super difficult to > update the views/filters (PIPELINESELECTIONS) to point to the new user IDs > for each user with an appropriate query? IIRC there should be max one row > per user (can't recall if it's 1-to-(0,1) or 1-to-1 from USERS). > > Not aware of any specific export or share support. The UI uses an internal > API */go/api/internal/pipeline_selection* to retrieve (GET) and update > (PUT) the views in one big block as an array of "filters", which in theory > you could use to get a JSON representation of your individual views if you > can still login with the old username. If one is more savvy, one could then > also PUT the collection back to the same API to update views when > authenticated with the new username - but obviously this is > undocumented/unsupported and would require some browser "Inspect" digging > :-) > > -Chad > > On Tue, Aug 22, 2023 at 4:21 PM 'Chris Gillatt' via go-cd < > go...@googlegroups.com> wrote: > >> I think that the user-configurable pipeline views in GoCD are stored >> against the user in the DB. I'm pretty sure that without messing around >> with the DB, migrating views (or sharing or exporting them) would not be >> possible. Could anyone confirm this please? >> >> The reason I ask is that we've migrated from one auth plugin to another, >> and as a result, all users now have a new username (old: user.name, new: >> user.name@domain). This means the users have lost their views. It's not a >> biggie, and moving from LDAP to OIDC auth is a much bigger win than keeping >> views, but thought I'd just ask the question. >> >> Cheers >> Chris >> >> -- >> You received this message because you are subscribed to the Google Groups >> "go-cd" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to go-cd+un...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/8280b950-9e20-4291-845a-e35de44634ffn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/8280b950-9e20-4291-845a-e35de44634ffn%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/774c932a-2072-4c22-ad15-3c783c397a97n%40googlegroups.com.
