Antoon Van Dessel
04/24/2026, 6:52 AMFanis Tharropoulos
04/24/2026, 9:36 AMstock.productCode references products.code, querying products and pulling in stock is the reverse side of the join. In this case, include_fields alone wasn’t enough. You also need a join filter.
This worked:
curl -G 'https://<cluster>/collections/default_dev_products_00010101_000000_00000000/documents/search' \
-H 'X-TYPESENSE-API-KEY: <api-key>' \
--data-urlencode 'q=*' \
--data-urlencode 'query_by=code' \
--data-urlencode 'filter_by=$default_dev_stock_00010101_000000_00000000(id:*)' \
--data-urlencode 'include_fields=code,name,$default_dev_stock_00010101_000000_00000000(*,strategy:nest_array) as stock'
So in Postman, keep your include_fields, but add filter_by=$default_dev_stock_00010101_000000_00000000(id:*). After that, the response includes the matching stock rows under stock.Antoon Van Dessel
04/24/2026, 9:59 AMFanis Tharropoulos
04/24/2026, 10:18 AMAntoon Van Dessel
04/24/2026, 11:01 AMAntoon Van Dessel
04/24/2026, 11:01 AMHarpreet Sangar
04/24/2026, 11:39 AM