How to export candidates from multiple CSW and Status using a single export script

Hello,

We are in situation to export candidates who are in CSWs "X" AND "Y" and their status in CSW "X" is "A" and "B" and their status in CSW "Y" is "C" and "D".

Simple filters are not pulling any data once I add all the CSWs and Statuses in simple filter. Any suggestion or anyone can help with sample script will be very helpful.

Thanks

Guru