V Parthiban
06/23/2025, 8:16 AM"*" (wildcard) on the Client Name List field, the facet counts shown (like Augustus Limited: 80234) are correct and reflect the actual document counts accurately.
Problem:
However, when I search using a term like "augustus" in the same Client Name List facet field, the filtered list of facet values (e.g., Augustus Limited, Augustus Foundation, etc.) appears, but their counts are significantly lower or don't match the wildcard counts — despite documents being visible in the results for those clients.
🧪 What I did:
• facet_by=Client Name List
• No filters applied when searching with *
• When typing "augustus" in the facet field, it triggers filtering/searching using the facet values that contain "augustus", but the counts shown are incorrect or inconsistent compared to the wildcard result.
I Have attached screen shots and payload for refs.Alan Martini
06/23/2025, 6:18 PMV Parthiban
06/24/2025, 6:31 AMV Parthiban
06/24/2025, 7:03 AMV Parthiban
06/24/2025, 7:04 AM{
"enable_nested_fields": true,
"fields": [
{
"name": ".*",
"type": "auto"
},
{
"name": ".*_str",
"optional": true,
"sort": true,
"type": "string"
},
{
"facet": false,
"index": true,
"infix": false,
"locale": "",
"name": "ocr_data",
"optional": true,
"sort": false,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.Extension_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.file_modified_date",
"optional": true,
"sort": true,
"stem": false,
"type": "int64"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.ModifiedDate",
"optional": true,
"sort": true,
"stem": false,
"type": "int64"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.CreatedDate",
"optional": true,
"sort": true,
"stem": false,
"type": "int64"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_name_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Client Name List_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Client ID_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": false,
"index": true,
"infix": false,
"locale": "",
"name": "dfx_restricted_document",
"optional": true,
"sort": false,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.CreatedBy_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Matter Document Type_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Matter Document Sub Type_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Lawyer",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
},
{
"facet": true,
"index": true,
"infix": false,
"locale": "",
"name": "system.lf.file.properties.template.template_fields.Matter Document Sub Folder_str",
"optional": true,
"sort": true,
"stem": false,
"type": "string"
}
],
"name": "RC1"
}V Parthiban
06/24/2025, 7:06 AM