Unable to display a subset of results using nested search

[former_member720805]

Hello,

I'm trying to output a list of patients with certain insurances. Of these, I also need to know which patients have an "POLST or ADHC" clinical event. I have tried many group iterations but I don't get the desired outcome.

The way I believe it should work (attached screen shot) not only outputs a shorter list of patients that would qualify on the insurance filter but all clinical events tied to the patient appear on the output as well. Any suggestions?

Example

Query Filters:

insurance in (uhc, aet, bs, ahc)

clinical event in (polst, adhc)

patient insurance clinical event a uhc polst b aet c bs adhc c bs polst d ahc e uhc adhc f aet

[former_member199945]

Hi,

May be data doesn't exist with the combination of applied query filters.

Try to run the report without applying filters and see the output.

If data is coming for all the query filter columns then apply filters at report level and if this is working then apply same filters at query level.

Thanks