Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: SeniorCoignos on 17 Jan 2023 08:17:35 AM

Title: How to send a ParamValue to Bind Variable in Oracle DB
Post by: SeniorCoignos on 17 Jan 2023 08:17:35 AM
Good day,

I would like to send a ParamValue directly to the Database.
However, whenever I try to use the ParamValue function in a DataItem I get an error.

Does anyone know how I would be able to do this?

Kind regards,

SeniorCoignos
Title: Re: How to send a ParamValue to Bind Variable in Oracle DB
Post by: bus_pass_man on 17 Jan 2023 05:00:05 PM
What's the error message?
Title: Re: How to send a ParamValue to Bind Variable in Oracle DB
Post by: SeniorCoignos on 19 Jan 2023 02:46:16 AM
Good day,

So I've gotten a bit further with this problem, I've been able to get the ParamValue into a DataItem that I can manipulate.

However, the ParamValue coming from the dashboard module is multiselect, but whenever I do #sq(ParamValue('P_My_Prompt'))# I only get back a single value.
How would I go about getting all the values into a DataItem?

Any help would be much appreciated.

Regards,

SeniorCoignos
Text only | Text with Images