AnsweredAssumed Answered

Investment Security

Question asked by Atul.K on Jan 11, 2010
Latest reply on Jan 13, 2010 by Dave
I have created a query to compare the Benefits and Cost recorded on each project summarized for each Division. This query works fine but will also add the numbers for investments which the user doesn't have security too. So the total Benefit and Cost is a bit misleading.  I was looking at some CA queries and I see they have the following statement in the WHERE clause which I think to select only investments which I have security too.       "AND @WHERE:SECURITY:INV:I.ID@"   I tried adding this but get 501 error.  Can someone please advise how I can handle investment security within NSQL queries.  Thanks  

Outcomes