AnsweredAssumed Answered

Simulate Multi-Value Relationship with ExecuteSQL

Question asked by JamesPeragine on May 1, 2018
Latest reply on May 2, 2018 by beverly

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..

Let (

SP = DASHBOARD::_gfkSalesAssociate ;

ExecuteSQL (

"SELECT COUNT(*) \"_pkDeals\" FROM \"Deals_777\" WHERE Status='Contracts Out' AND \"_pkSalesAssociate\" ='" & SP & "'" ; "" ;""