I've a scenario where the lucene query depends on the result of another lucene
For example, find all the employees of the department where one of its
employee's email address = 'a...@email.com'
SQL would be like:
select * from employee where dept_no in(
select dept_no from employee where email = 'a...@email.com'
Please note that employee is a huge data and inner query can result into 5
Any thoughts how to replicate this scenario using core lucene?