This content has been marked as final. Show 2 replies
Not clear with your condition;
It should be something like
CASE WHEN VALUEOF(NQ_SESSION."groupRole") = 'salerManager'
THEN MarketCoverage.MarketCoverage.dbo.OppFact2.PRJ_OWNER_ID end)
Not sure how you going to validate this ( VALUEOF(NQ_SESSION."List_of_Saler"))
I would suggest write manual sql query and apply the same logic here in where clause
Mark if helps