Georgi Nachev
12/01/2025, 3:36 PMquery_by) on referenced/joined fields in Typesense (like vendor.name when searching products)?
Currently, it seems that query_by works only on the main collection, and I’m wondering if native support for searching across related collections will be added soon.
Thank you!Kishore Nallan
12/01/2025, 4:04 PMGeorgi Nachev
12/01/2025, 4:06 PMGeorgi Nachev
12/02/2025, 7:57 AMKishore Nallan
12/02/2025, 8:10 AMNikhil Agarwal
12/08/2025, 1:20 PMHarpreet Sangar
12/08/2025, 1:22 PMNikhil Agarwal
12/08/2025, 1:27 PMNikhil Agarwal
12/08/2025, 1:28 PMHarpreet Sangar
12/08/2025, 1:33 PMNikhil Agarwal
12/08/2025, 1:36 PMconst itemMasterCollectionSchemaFields: CollectionCreateSchema['fields'] = [
{ name: 'id', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'active', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'modifiedOn', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'itemNumber', type: 'string', index: true, optional: false, sort: true, infix: true },
{ name: 'description', type: 'string', index: true, optional: false, sort: true, infix: true, stem: true },
{ name: 'commodityId', type: 'string', index: true, optional: false, sort: true, infix: false, facet: true },
{ name: 'brand', type: 'string', index: true, optional: true, sort: true, infix: true, facet: true },
{ name: 'caseDimension', type: 'float', index: true, optional: true, sort: true, infix: false },
{ name: 'caseNetWeight', type: 'float', index: true, optional: false, sort: true, infix: false },
{ name: 'hasChildNutrition', type: 'bool', index: true, optional: false, sort: false, infix: false, facet: true },
{ name: 'isFood', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'isCatchWeight', type: 'bool', index: true, optional: false, sort: false, infix: false, facet: true },
{ name: 'itemPack', type: 'int32', index: true, optional: true, sort: true, infix: false },
{ name: 'gtin', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'packSize', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'packSizeDescription', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'allergensContains', type: 'string[]', index: true, optional: true, sort: false, infix: false, facet: true },
{ name: 'allergensFreeFrom', type: 'string[]', index: true, optional: true, sort: false, infix: false, facet: true },
{ name: 'marketingDescription', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'ingredients', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'storageType', type: 'string', index: true, optional: true, sort: false, infix: false, facet: true },
];
const itemWarehouseCollectionSchemaFields: CollectionCreateSchema['fields'] = [
{ name: 'id', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'itemNumber', type: 'string', index: true, optional: false, sort: true, infix: true, reference: 'item_master.itemNumber', async_reference: true },
{ name: 'active', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'modifiedOn', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'division', type: 'int32', index: true, optional: true, sort: false, infix: false },
{ name: 'isBrokenCase', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'reservedShipTos', type: 'string[]', index: true, optional: true, sort: false, infix: false },
{ name: 'vendorNumber', type: 'string', index: true, optional: true, sort: true, infix: true },
{ name: 'isSuspended', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'barcode', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'itemZone', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'isDropShip', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'isJustInTime', type: 'bool', index: true, optional: false, sort: false, infix: false },
];
const customerItemsCollectionSchemaFields: CollectionCreateSchema['fields'] = [
{ name: 'id', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'itemWhId', type: 'string', index: true, optional: false, sort: false, infix: false, reference: 'item_warehouse.id', async_reference: true },
{ name: 'active', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'itemNumber', type: 'string', index: true, optional: false, sort: true, infix: true, reference: 'item_master.itemNumber', async_reference: true },
{ name: 'shipTo', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'division', type: 'int32', index: true, optional: true, sort: false, infix: false },
{ name: 'type', type: 'int32', index: true, optional: true, sort: false, infix: false },
{ name: 'customerDescription', type: 'string', index: true, optional: true, sort: true, infix: true },
{ name: 'customerItemNumber', type: 'string', index: true, optional: true, sort: true, infix: true },
{ name: 'modifiedOn', type: 'string', index: true, optional: true, sort: true, infix: false }
];
const contractItemsCollectionSchemaFields: CollectionCreateSchema['fields'] = [
{ name: 'id', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'itemWhId', type: 'string', index: true, optional: false, sort: false, infix: false, reference: 'item_warehouse.id', async_reference: true },
{ name: 'contractId', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'itemNumber', type: 'string', index: true, optional: false, sort: true, infix: true, reference: 'item_master.itemNumber', async_reference: true },
{ name: 'division', type: 'int32', index: true, optional: true, sort: false, infix: false },
{ name: 'active', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'modifiedOn', type: 'string', index: true, optional: true, sort: true, infix: false }
];
const guideItemsCollectionSchemaFields: CollectionCreateSchema['fields'] = [
{ name: 'id', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'itemWhId', type: 'string', index: true, optional: false, sort: false, infix: false, reference: 'item_warehouse.id', async_reference: true },
{ name: 'active', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'guideType', type: 'int32', index: true, optional: false, sort: false, infix: false },
{ name: 'guideId', type: 'string', index: true, optional: false, sort: false, infix: false },
{ name: 'type', type: 'int32', index: true, optional: false, sort: false, infix: false },
{ name: 'itemNumber', type: 'string', index: true, optional: true, sort: true, infix: true, reference: 'item_master.itemNumber', async_reference: true },
{ name: 'customerItemId', type: 'string', index: true, optional: true, sort: true, infix: true, reference: 'customer_items.customerItemNumber', async_reference: true },
{ name: 'shipTo', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'division', type: 'int32', index: true, optional: true, sort: false, infix: false },
{ name: 'guideItemId', type: 'string', index: true, optional: true, sort: false, infix: false },
{ name: 'modifiedOn', type: 'string', index: true, optional: true, sort: true, infix: false },
{ name: 'sortSequence', type: 'int32', index: true, optional: true, sort: true, infix: false },
{ name: 'eachOnly', type: 'bool', index: true, optional: false, sort: false, infix: false },
{ name: 'lastPurchaseUt', type: 'int64', index: true, optional: true, sort: true, infix: false }
];Nikhil Agarwal
12/08/2025, 1:44 PMNikhil Agarwal
12/08/2025, 1:44 PMNikhil Agarwal
12/09/2025, 7:06 AMquery_byNikhil Agarwal
12/09/2025, 7:06 AMKishore Nallan
12/09/2025, 7:07 AMNikhil Agarwal
12/09/2025, 7:08 AMNikhil Agarwal
12/09/2025, 7:10 AMKishore Nallan
12/09/2025, 7:11 AM