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.

Reply via email to