I have two types called 'install' and 'events' in one index 'postbacks'. Now I need to select the event counts from events types for every day for the users who has entry in install for the particular day. Now what I am doing is, I am first fetching the ids from install for the day and using bool filter and specifying the date in must and using Ids in term . I will get around 2000 ids for a day and using it directly in should condition. So there will be 2000 terms there.
I just read about terms lookup filter. Can I use it here in this situation. I have seen in the example that we only can specify one id and path to it. But is there any possibility to use it like a subquery?
Please check the following link to see the code that I have done in PHP for this.
Thanks in advance.
