@@ -226,6 +226,7 @@ func Workspaces(ctx context.Context, db database.Store, query string, page coder
226226filter .HasExternalAgent = parser .NullableBoolean (values , sql.NullBool {},"has_external_agent" )
227227filter .OrganizationID = parseOrganization (ctx ,db ,parser ,values ,"organization" )
228228filter .Shared = parser .NullableBoolean (values , sql.NullBool {},"shared" )
229+ filter .SharedWithUserID = parseUser (ctx ,db ,parser ,values ,"shared_with_user" )
229230
230231type paramMatch struct {
231232name string
@@ -363,6 +364,25 @@ func parseOrganization(ctx context.Context, db database.Store, parser *httpapi.Q
363364})
364365}
365366
367+ func parseUser (ctx context.Context ,db database.Store ,parser * httpapi.QueryParamParser ,vals url.Values ,queryParam string ) uuid.UUID {
368+ return httpapi .ParseCustom (parser ,vals ,uuid .Nil ,queryParam ,func (v string ) (uuid.UUID ,error ) {
369+ if v == "" {
370+ return uuid .Nil ,nil
371+ }
372+ userID ,err := uuid .Parse (v )
373+ if err == nil {
374+ return userID ,nil
375+ }
376+ user ,err := db .GetUserByEmailOrUsername (ctx , database.GetUserByEmailOrUsernameParams {
377+ Username :v ,
378+ })
379+ if err != nil {
380+ return uuid .Nil ,xerrors .Errorf ("user %q either does not exist, or you are unauthorized to view them" ,v )
381+ }
382+ return user .ID ,nil
383+ })
384+ }
385+
366386// splitQueryParameterByDelimiter takes a query string and splits it into the individual elements
367387// of the query. Each element is separated by a delimiter. All quoted strings are
368388// kept as a single element.