This content has been marked as final. Show 2 replies
any one has comment above question.
Not clear with your condition;1 person found this helpful
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