parameter question

[jnel]

Hi all,

I am new to Actaute had have read through the manual and found where/how to create a parameter in the Graphical SQL editor. The only problem I am having is becuase I have entered a parameter into the clause, this basically forces a need to have the parameter entered. For example one of the parameters shoots a 7 digit user id into the where clause, but if someone does not want to have their query limited and leaves it blank nothing is returned. I have tried *, % and . as the defaults. Nothing is working. Any suggestions?
Thanks,
John

 

[ASG0856]

First, what version of Actuate?

Second, are you saying you have created you parameter under tools, parameters, and are now trying associate a field with a parameter?
If So, in conditions (in graphical query) you want the Field to be like the parameter

So the parameter is defaulted to %

In conditions,
select field in column name,
and arameterName in Query Expression.

 

[jnel]

I am using Actuate 7. I have created the parameter by using a "aram" in the select statement and then when I view the parameter from the tools menu, I am entering the %, *, etc in the "defaults" box.

thanks,
john

 

[jnel]

I mean "aram" in the where statement. Sorry for the confusion.

-John

 

[ASG0856]

When you state "aram", do you mean that literally (ie with the quotes). If so, dump the quotes. By the way, you haven't got a dash in the parameter name have you (param-name), because to Query Builder that means 'between'

 

[jnel]

The true name of the param is roject. I figured out the solution. I built a query with a WHEN THEN and the THEN uses a " as a wildcard once the column has been converted.
Thanks!
-John