Query linked records

[henribruvier]

Hello everyone

I have created a subscription module and linked it to the customer module.

The generated types in the .medusa folder looks good :

export type Customer = {
  __typename?: 'Customer';
  id: Scalars['ID']['output'];
  company_name: Maybe<Scalars['String']['output']>;
  first_name: Maybe<Scalars['String']['output']>;
  last_name: Maybe<Scalars['String']['output']>;
  email: Maybe<Scalars['String']['output']>;
  phone: Maybe<Scalars['String']['output']>;
  has_account: Scalars['Boolean']['output'];
  metadata: Maybe<Scalars['JSON']['output']>;
  created_by: Maybe<Scalars['String']['output']>;
  groups: Array<Maybe<CustomerGroup>>;
  addresses: Array<Maybe<CustomerAddress>>;
  created_at: Scalars['DateTime']['output'];
  updated_at: Scalars['DateTime']['output'];
  deleted_at: Maybe<Scalars['DateTime']['output']>;
  carts: Maybe<Array<Maybe<Cart>>>;
  orders: Maybe<Array<Maybe<Order>>>;
  subscription_link: Maybe<Array<Maybe<LinkSubscriptionModuleSubscriptionCustomerCustomer>>>;
  subscriptions: Maybe<Array<Maybe<Subscription>>>;
};

However when I try to fetch the linked subscription in a customer widget like this:

  const { data: queryResult } = useQuery({
    queryFn: () =>
      sdk.admin.customer.retrieve(customer.id, { fields: "+subscriptions.*" }),
    queryKey: [["customer", customer.id]],
  });

I have this error:

error:   Requested fields [subscriptions] are not valid
MedusaError: Requested fields [subscriptions] are not valid
    at prepareListQuery (/medusa/node_modules/@medusajs/framework/src/http/utils/get-query-config.ts:179:11)
    at prepareRetrieveQuery (/medusa/node_modules/@medusajs/framework/src/http/utils/get-query-config.ts:245:45)
    at validateQuery (/node_modules/@medusajs/framework/src/http/utils/validate-query.ts:85:31) {
  __isMedusaError: true,
  type: 'invalid_data',
  code: undefined,
  date: 2025-01-15T09:47:52.174Z
}

So also try to get default linked fields like orders or carts (to test) and I have the same error...

[saranshisatgit]

So, instead of doing this you could re-use the hook provided by default by looking up the names as I did here and pass your fields

https://github.com/Jaal-Yantra-Textiles/v2/blob/b1b6d5bbc46fd953239dc6ca6fb4a0656ec5dbeb/src/admin/widgets/inventory-raw-material.tsx#L79

and pass it as a query also

export const useInventoryItem = (
  id: string,
  query?: Record<string, any>,
  options?: Omit<
    UseQueryOptions<
      HttpTypes.AdminInventoryItemResponse,
      FetchError,
      RawMaterialResponse,
      QueryKey
    >,
    "queryKey" | "queryFn"
  >
) => {
  const { data, ...rest } = useQuery({
    queryFn: () => sdk.admin.inventoryItem.retrieve(id, query),
    queryKey: inventoryItemsRawMaterialQueryKeys.detail(id),
    ...options,
  })

  return { ...data, ...rest }
}

From your client side

 const {
    inventory_item,
    isPending: isLoading,
    isError,
    error,
  } = useInventoryItem(
    data.id!,
    {
      fields: "+raw_materials.*, +raw_materials.material_type.*",
    },
  )

Now, maybe your links are not established or there is something that’s missing