I am having problem in searching the results.
If the foreign key store_id in the orders table is greater than
999, then returns the empty results. But it returns the correct result
set
when the its <=999.
How to make it working when the store_id is greater than 999?
I’m not quite sure what the problem is by your description - I’m
guessing you’re searching on the Order model? What’s the index
definition for Order? And what’s the query you’re running that isn’t
working as you expect?