Is there a way to Simulate Multi-Value Relationship with ExecuteSQL?
I am using ExSQL to create a dashboard that shows counts of various searches in tables. I have SalesAgents in my solution that are one of the requirements in the ExSQL statement. I'd like to be able to have a Global Field setup as checkboxes so that administrators can choose multiple Sales agents to include in the calculation. How can I accomplish this with Executive SQL?
Example of one of my current search calcs..
SP = DASHBOARD::_gfkSalesAssociate ;
"SELECT COUNT(*) \"_pkDeals\" FROM \"Deals_777\" WHERE Status='Contracts Out' AND \"_pkSalesAssociate\" ='" & SP & "'" ; "" ;""