case 1: Request : curl --location 'https://demo.datafabricx.com:8108/multi_search' \ --header 'x-typesense-api-key: ******' \ --header 'Content-Type: application/json' \ --data '{ "searches": [ { "query_by": "system.lf.file.properties.template", "per_page": "1", "exclude_fields": "embedding", "sort_by": "system.lf.file.properties.file_modified_date:desc", "highlight_full_fields": "system.lf.file.properties.template", "collection": "DFXAppv3", "q": "*", "facet_by": "system.lf.file.properties.CreatedBy_str,system.lf.file.properties.CreatedDate,system.lf.file.properties.Extension_str,system.lf.file.properties.ModifiedDate,system.lf.file.properties.template.template_fields.Client Id_str,system.lf.file.properties.template.template_fields.Client Name_str,system.lf.file.properties.template.template_name_str", "max_facet_values": 20, "page": 1, "filter_by": "dfx_restricted_document:!= deleted" } ] }' response :{ "results": [ { "facet_counts": [ { "counts": [ { "count": 740495, "highlighted": "DATAFABRICX\\nmuthu", "value": "DATAFABRICX\\nmuthu" } ], "field_name": "system.lf.file.properties.CreatedBy_str", "sampled": false, "stats": { "total_values": 1 } }, { "counts": [ { "count": 740495, "highlighted": "1739197170", "value": "1739197170" } ], "field_name": "system.lf.file.properties.CreatedDate", "sampled": false, "stats": { "avg": 1739197170.0, "max": 1739197170.0, "min": 1739197170.0, "sum": 1.28786680839915e+15, "total_values": 1 } }, { "counts": [ { "count": 148595, "highlighted": "xlsx", "value": "xlsx" }, { "count": 148300, "highlighted": "docx", "value": "docx" }, { "count": 148014, "highlighted": "txt", "value": "txt" }, { "count": 147820, "highlighted": "pdf", "value": "pdf" }, { "count": 147766, "highlighted": "pptx", "value": "pptx" } ], "field_name": "system.lf.file.properties.Extension_str", "sampled": false, "stats": { "total_values": 5 } }, { "counts": [ { "count": 740495, "highlighted": "1747114407", "value": "1747114407" } ], "field_name": "system.lf.file.properties.ModifiedDate", "sampled": false, "stats": { "avg": 1747114407.0, "max": 1747114407.0, "min": 1747114407.0, "sum": 1.293729482811465e+15, "total_values": 1 } }, { "counts": [ { "count": 148597, "highlighted": "CL0000111", "value": "CL0000111" }, { "count": 148452, "highlighted": "CL0000115", "value": "CL0000115" }, { "count": 148358, "highlighted": "CL0000109", "value": "CL0000109" }, { "count": 147827, "highlighted": "CL0000114", "value": "CL0000114" }, { "count": 147261, "highlighted": "CL0000107", "value": "CL0000107" } ], "field_name": "system.lf.file.properties.template.template_fields.Client Id_str", "sampled": false, "stats": { "total_values": 5 } }, { "counts": [ { "count": 122144, "highlighted": "Kumar Trust", "value": "Kumar Trust" }, { "count": 121604, "highlighted": "Raleigh Limited", "value": "Raleigh Limited" }, { "count": 121579, "highlighted": "Helier Investments Limited", "value": "Helier Investments Limited" }, { "count": 120780, "highlighted": "Walter Trust", "value": "Walter Trust" }, { "count": 108277, "highlighted": "Baskin Robins Investment Ltd.", "value": "Baskin Robins Investment Ltd." }, { "count": 107778, "highlighted": "Durban Consultants", "value": "Durban Consultants" }, { "count": 13197, "highlighted": "k M jb Durban Consultants", "value": "k M jb Durban Consultants" }, { "count": 13136, "highlighted": " L K Baskin Robins Investment Ltd", "value": " L K Baskin Robins Investment Ltd" } ], "field_name": "system.lf.file.properties.template.template_fields.Client Name_str", "sampled": false, "stats": { "total_values": 8 } }, { "counts": [ { "count": 247077, "highlighted": "Invoices", "value": "Invoices" }, { "count": 246793, "highlighted": "Audit", "value": "Audit" }, { "count": 246625, "highlighted": "Client Document", "value": "Client Document" } ], "field_name": "system.lf.file.properties.template.template_name_str", "sampled": false, "stats": { "total_values": 3 } } ], "found": 740495, "hits": [ { "document": { "document_created_by": "DATAFABRICX\\nmuthu", "document_created_date": "1739197170", "document_current_version": 0, "document_id": "840499", "document_modified_date": "1747114407", "document_name": "CL840499-23-07-2024-Raleigh Limited", "document_source": "", "id": "840499", "lastupdated_datetime": 1748520991, "ocr_data": "At most periods of her history India,....", "ocr_status": "completed", "system": { "business": { "properties": { "Client Id_str": "CL0000114", "Client Name_str": "Raleigh Limited", "DFXAI_str": "Yes", "Document Date_str": "Jul 23 2024 12:00AM", "Document Sub Type_str": "A01. Accounting File Note", "Document Title_str": "CL840499-23-07-2024-Raleigh Limited", "Document Type_str": "A01. Accounting", "Repository Type_str": "Client" } }, "custom": {}, "lf": { "file": { "properties": { "CreatedBy_str": "DATAFABRICX\\nmuthu", "CreatedDate": "1739197170", "DocSize": "731495", "EntryID_str": "840499", "EntryName_str": "CL840499-23-07-2024-Raleigh Limited", "Extension_str": "pdf", "LFPath_str": "", "MimeType_str": "application/octet-stream", "ModifiedDate": "1747114407", "PageCount": "0", "ParentId": "116917", "file_modified_date": "1747114407", "template": { "template_fields": { "Client Id_str": "CL0000114", "Client Name_str": "Raleigh Limited", "DFXAI_str": "Yes", "Document Date_str": "Jul 23 2024 12:00AM", "Document Sub Type_str": "A01. Accounting File Note", "Document Title_str": "CL840499-23-07-2024-Raleigh Limited", "Document Type_str": "A01. Accounting", "Repository Type_str": "Client" }, "template_name_str": "Audit" } } } }, "network": { "file": {} } } }, "highlight": {}, "highlights": [] } ], "out_of": 740500, "page": 1, "request_params": { "collection_name": "DFXAppv3", "first_q": "*", "per_page": 1, "q": "*" }, "search_cutoff": false, "search_time_ms": 343 } ] } case 2: request: curl --location 'https://demo.datafabricx.com:8108/multi_search' \ --header 'x-typesense-api-key: ****' \ --header 'Content-Type: application/json' \ --data '{ "searches": [ { "query_by": "system.lf.file.properties.template", "per_page": "1", "exclude_fields": "embedding", "sort_by": "system.lf.file.properties.file_modified_date:desc", "highlight_full_fields": "system.lf.file.properties.template", "collection": "DFXAppv3", "q": "Baskin Robins Investment Ltd.", "facet_by": "system.lf.file.properties.CreatedBy_str,system.lf.file.properties.CreatedDate,system.lf.file.properties.Extension_str,system.lf.file.properties.ModifiedDate,system.lf.file.properties.template.template_fields.Client Id_str,system.lf.file.properties.template.template_fields.Client Name_str,system.lf.file.properties.template.template_name_str", "max_facet_values": 20, "page": 1, "filter_by": "dfx_restricted_document:!= deleted" } ] }' Response:{ "results": [ { "facet_counts": [ { "counts": [ { "count": 123413, "highlighted": "DATAFABRICX\\nmuthu", "value": "DATAFABRICX\\nmuthu" } ], "field_name": "system.lf.file.properties.CreatedBy_str", "sampled": false, "stats": { "total_values": 1 } }, { "counts": [ { "count": 123413, "highlighted": "1739197170", "value": "1739197170" } ], "field_name": "system.lf.file.properties.CreatedDate", "sampled": false, "stats": { "avg": 1739197170.0, "max": 1739197170.0, "min": 1739197170.0, "sum": 214639540341210.0, "total_values": 1 } }, { "counts": [ { "count": 24961, "highlighted": "xlsx", "value": "xlsx" }, { "count": 24715, "highlighted": "docx", "value": "docx" }, { "count": 24596, "highlighted": "txt", "value": "txt" }, { "count": 24595, "highlighted": "pdf", "value": "pdf" }, { "count": 24546, "highlighted": "pptx", "value": "pptx" } ], "field_name": "system.lf.file.properties.Extension_str", "sampled": false, "stats": { "total_values": 5 } }, { "counts": [ { "count": 123413, "highlighted": "1747114407", "value": "1747114407" } ], "field_name": "system.lf.file.properties.ModifiedDate", "sampled": false, "stats": { "avg": 1747114407.0, "max": 1747114407.0, "min": 1747114407.0, "sum": 215616630311091.0, "total_values": 1 } }, { "counts": [ { "count": 24947, "highlighted": "CL0000111", "value": "CL0000111" }, { "count": 24695, "highlighted": "CL0000114", "value": "CL0000114" }, { "count": 24625, "highlighted": "CL0000115", "value": "CL0000115" }, { "count": 24613, "highlighted": "CL0000107", "value": "CL0000107" }, { "count": 24533, "highlighted": "CL0000109", "value": "CL0000109" } ], "field_name": "system.lf.file.properties.template.template_fields.Client Id_str", "sampled": false, "stats": { "total_values": 5 } }, { "counts": [ { "count": 108277, "highlighted": "Baskin Robins Investment Ltd.", "value": "Baskin Robins Investment Ltd." }, { "count": 13136, "highlighted": " L K Baskin Robins Investment Ltd", "value": " L K Baskin Robins Investment Ltd" } ], "field_name": "system.lf.file.properties.template.template_fields.Client Name_str", "sampled": false, "stats": { "total_values": 2 } }, { "counts": [ { "count": 41239, "highlighted": "Audit", "value": "Audit" }, { "count": 41089, "highlighted": "Invoices", "value": "Invoices" }, { "count": 41085, "highlighted": "Client Document", "value": "Client Document" } ], "field_name": "system.lf.file.properties.template.template_name_str", "sampled": false, "stats": { "total_values": 3 } } ], "found": 123413, "hits": [ { "document": { "document_created_by": "DATAFABRICX\\nmuthu", "document_created_date": "1739197170", "document_current_version": 0, "document_id": "840494", "document_modified_date": "1747114407", "document_name": "CL840494-23-07-2024-Baskin Robins Investment Ltd.", "document_source": "", "id": "840494", "lastupdated_datetime": 1748520991, "ocr_data": "At most periods of her history India, ", "ocr_status": "completed", "system": { "business": { "properties": { "Client Id_str": "CL0000111", "Client Name_str": "Baskin Robins Investment Ltd.", "DFXAI_str": "Yes", "Document Date_str": "Jul 23 2024 12:00AM", "Document Sub Type_str": "A01. Accounting File Note", "Document Title_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.", "Document Type_str": "A01. Accounting", "Repository Type_str": "Client" } }, "custom": {}, "lf": { "file": { "properties": { "CreatedBy_str": "DATAFABRICX\\nmuthu", "CreatedDate": "1739197170", "DocSize": "731495", "EntryID_str": "840494", "EntryName_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.", "Extension_str": "pptx", "LFPath_str": "", "MimeType_str": "application/octet-stream", "ModifiedDate": "1747114407", "PageCount": "0", "ParentId": "116917", "file_modified_date": "1747114407", "template": { "template_fields": { "Client Id_str": "CL0000111", "Client Name_str": "Baskin Robins Investment Ltd.", "DFXAI_str": "Yes", "Document Date_str": "Jul 23 2024 12:00AM", "Document Sub Type_str": "A01. Accounting File Note", "Document Title_str": "CL840494-23-07-2024-Baskin Robins Investment Ltd.", "Document Type_str": "A01. Accounting", "Repository Type_str": "Client" }, "template_name_str": "Client Document" } } } }, "network": { "file": {} } } }, "highlight": { "system": { "lf": { "file": { "properties": { "template": { "template_fields": { "Client Id_str": { "matched_tokens": [], "snippet": "CL0000111", "value": "CL0000111" }, "Client Name_str": { "matched_tokens": [ "Baskin", "Robins", "Investment", "Ltd" ], "snippet": "Baskin Robins Investment Ltd.", "value": "Baskin Robins Investment Ltd." }, "DFXAI_str": { "matched_tokens": [], "snippet": "Yes", "value": "Yes" }, "Document Date_str": { "matched_tokens": [], "snippet": "Jul 23 2024 12:00AM", "value": "Jul 23 2024 12:00AM" }, "Document Sub Type_str": { "matched_tokens": [], "snippet": "A01. Accounting File Note", "value": "A01. Accounting File Note" }, "Document Title_str": { "matched_tokens": [ "Robins", "Investment", "Ltd" ], "snippet": "CL840494-23-07-2024-Baskin Robins Investment Ltd.", "value": "CL840494-23-07-2024-Baskin Robins Investment Ltd." }, "Document Type_str": { "matched_tokens": [], "snippet": "A01. Accounting", "value": "A01. Accounting" }, "Repository Type_str": { "matched_tokens": [], "snippet": "Client", "value": "Client" } }, "template_name_str": { "matched_tokens": [], "snippet": "Client Document", "value": "Client Document" } } } } } } }, "highlights": [], "text_match": 2314894167593451522, "text_match_info": { "best_field_score": "4419510927616", "best_field_weight": 0, "fields_matched": 2, "num_tokens_dropped": 0, "score": "2314894167593451522", "tokens_matched": 4, "typo_prefix_score": 0 } } ], "out_of": 740500, "page": 1, "request_params": { "collection_name": "DFXAppv3", "first_q": "Baskin Robins Investment Ltd.", "per_page": 1, "q": "Baskin Robins Investment Ltd." }, "search_cutoff": false, "search_time_ms": 531 } ] }