Query template's Parameter tab in V11.5

[former_member182065]

hello,

the above mentioned tab shows 32 count parameters available. is this the limitation? are there any method for adding more parameters?

Sincerely, Shiroh Kinoshita - SAP Japan

[Former Member · Accepted solution]

You can always just build your query dynamically and pass it to a fixed query.

[jcgood25 · Accepted solution]

Christian - thanks for clarifying that the supposed 'limitation' really only exists with the ability and/or creativity of the developer

Shiroh you can easily use the [Param.x] tokens to define portions of your statements, such as:

SELECT [Param.1] FROM [Param.2] WHERE.....ORDER BY [Param.x]

Best Regards,

Jeremy

[former_member182065]

Christian, Jeremy, thanks for clarifying. we will proceed with the Fixed query or external file.

Best Regards, Shiroh Kinoshita - SAP Japan

[Former Member]

Yaa this is the limitation.In V11.5 we can not pass more than 32 parameters to a Query template.If we want to add more parameters,then we need to change in code of V11.5.So we need permission from SAP.

Manisha