I'm locked at v1.16.3 and i don't understand whats wrong

[MohammedFaragallah]

    projects: {
        Row: {
          created_at: string
          created_by: string
          id: string
          manager_id: string
          name: string
          policies: Json
          reviewed_policies: boolean
          reviewed_workflows: boolean
          updated_at: string | null
          updated_by: string | null
          workflows: Json
        }
        Insert: {
          created_at?: string
          created_by?: string
          id?: string
          manager_id: string
          name: string
          policies?: Json
          reviewed_policies?: boolean
          reviewed_workflows?: boolean
          updated_at?: string | null
          updated_by?: string | null
          workflows?: Json
        }
        Update: {
          created_at?: string
          created_by?: string
          id?: string
          manager_id?: string
          name?: string
          policies?: Json
          reviewed_policies?: boolean
          reviewed_workflows?: boolean
          updated_at?: string | null
          updated_by?: string | null
          workflows?: Json
        }
        Relationships: [
          {
            foreignKeyName: "projects_created_by_fkey"
            columns: ["created_by"]
            isOneToOne: false
            referencedRelation: "employees"
            referencedColumns: ["id"]
          },
          {
            foreignKeyName: "projects_manager_id_fkey"
            columns: ["manager_id"]
            isOneToOne: false
            referencedRelation: "employees"
            referencedColumns: ["id"]
          },
          {
            foreignKeyName: "projects_updated_by_fkey"
            columns: ["updated_by"]
            isOneToOne: false
            referencedRelation: "employees"
            referencedColumns: ["id"]
          },
        ]
      }

workspaces: {
        Row: {
          created_at: string
          created_by: string
          id: string
          name: string
          policies: Json
          project_id: string
          reviewed_policies: boolean
          reviewed_workflows: boolean
          root: boolean | null
          updated_at: string | null
          updated_by: string | null
          workflows: Json
        }
        Insert: {
          created_at?: string
          created_by?: string
          id?: string
          name: string
          policies?: Json
          project_id: string
          reviewed_policies?: boolean
          reviewed_workflows?: boolean
          root?: boolean | null
          updated_at?: string | null
          updated_by?: string | null
          workflows?: Json
        }
        Update: {
          created_at?: string
          created_by?: string
          id?: string
          name?: string
          policies?: Json
          project_id?: string
          reviewed_policies?: boolean
          reviewed_workflows?: boolean
          root?: boolean | null
          updated_at?: string | null
          updated_by?: string | null
          workflows?: Json
        }
        Relationships: [
          {
            foreignKeyName: "workspaces_created_by_fkey"
            columns: ["created_by"]
            isOneToOne: false
            referencedRelation: "employees"
            referencedColumns: ["id"]
          },
          {
            foreignKeyName: "workspaces_project_id_fkey"
            columns: ["project_id"]
            isOneToOne: false
            referencedRelation: "projects"
            referencedColumns: ["id"]
          },
          {
            foreignKeyName: "workspaces_updated_by_fkey"
            columns: ["updated_by"]
            isOneToOne: false
            referencedRelation: "employees"
            referencedColumns: ["id"]
          },
        ]
      }

this query worked fine and it still works but with type error

       client
		.from(Resources.Projects)
		.select(`*,workspaces(*)`)
		.eq('id', project_id)
		.single()

the current result

{
    created_at: string;
    created_by: string;
    id: string;
    manager_id: string;
    name: string;
    policies: Json;
    reviewed_policies: boolean;
    reviewed_workflows: boolean;
    updated_at: string | null;
    updated_by: string | null;
    workflows: Json;
    workspaces: SelectQueryError<"could not find the relation between projects and workspaces">;
}

[silentworks]

What is your question here as it's not very clear from the information you've provided?

[MohammedFaragallah]

What is your question here as it's not very clear from the information you've provided?

Thank you for your response, my question is why am i getting this error see the last line

{
    created_at: string;
    created_by: string;
    id: string;
    manager_id: string;
    name: string;
    policies: Json;
    reviewed_policies: boolean;
    reviewed_workflows: boolean;
    updated_at: string | null;
    updated_by: string | null;
    workflows: Json;
    workspaces: SelectQueryError<"could not find the relation between projects and workspaces">; // This line
}

[MohammedFaragallah]

.from('projects)
.select(`*,workspaces(*)`)
.eq('id', project_id)
.single()

this works my bad sorry

i never thought that would be the problem because other queries setup the same way works fine