AnsweredAssumed Answered

NSQL INPUT PARAMTER

Question asked by georges.barakeh on Oct 15, 2014
Latest reply on Oct 16, 2014 by georges.barakeh

In my filter I have a project ID parameter. When nothing selected I would like to pass all projects available into my nsql statement. Is there a way to do so?

right now my code reads as follow:

AND COSTPLAN.OBJECT_ID=@WHERE:PARAM:USER_DEF:integer:project_id@

 

 

When nothing selected it's passing null and therefore it's messing my data result. Please help.

thanks,

-Georges

Outcomes