Running the search query - returns 18 results in Statatics tab.
Running the search query with outputlookup command - returns 18 results in Statatics tab.
But when trying to query using inputlookup - returns 15 results in Statatics tab.
What could be the reason?
Shot in the dark. Check your query for duplicate results on anything that might be a key.
If that's not it, then please show the actual results, or a dummy version of what you see, so we can look further.
Updated the screenshots for sample data. Their are other fields , which doesnt have the same value for every record.
inputlookup - RecordNo missing "5e940a21a0c53f0837420063"
outputlookup - xtime missing "2020-04-08T00:12:00.809"