function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Nitish Singh 22Nitish Singh 22 

SOSL query with DATA CATEGORY filter returns more records than the same SOSL query with no filters applied

Hi All ,

I have SOSL a query with DATA CATEGORY filter that returns some 50 records 

Same SOSL query with no DATA CATEGORY filter returns about 20 records.

I was expecting the SOSL query with no DATA CATEGORY filter to return more number of records .


Can someone explain why the same SOSL query with filters applied returns more number of records
Akhil AnilAkhil Anil
Can you post your queries with AND without filters ?
Nitish Singh 22Nitish Singh 22
With DATA CATEGORY filter (returns 50 records):

FIND { tax invoice}  IN ALL FIELDS RETURNING  WKArticleType__kav(Id,Category__C, Topic__C, Input_Method__c WHERE Topic__c includes ('  ***** ') AND PublishStatus='Online' AND language ='en_US' AND IsVisibleInPkb = true ) With DATA CATEGORY Product_Family__c ABOVE ****

Without any filter (returns about 20 records):

FIND { tax invoice}  IN ALL FIELDS RETURNING  WKArticleType__kav(Id,Category__C, Topic__C, Input_Method__c WHERE Topic__c includes ('  ***** ') AND PublishStatus='Online' AND language ='en_US' AND IsVisibleInPkb = true )
Nitish Singh 22Nitish Singh 22
***** represent the values that i am searching for. For some security concerns i have not specifying the values , but this is what thequery looks like