I have a main query which returns below 4 columns:
rule, result, name, department
Now i have to add another query as subsearch where i want to get column address for all the name returned from 1st result. I have fullname column in subsearch index which is same as name from 1st query . how to achieve this .