[Anonymous]

Hi ,

n

I'm afraid I do not have the liberty to use a Stored Procedure. I have no control over the Database; I can only fire SQL select queries on some views in the Database.

n

~

[Anonymous]

Hi ,

n

  Have you tried using a Stored Procedure and then consume the params from the http?

n

[Anonymous]

Hello,

n

I have a page containing a qSIChartView web part configured to get data from an Oracle DB view. I use a SQL query (Method Type = Text) to get the results I need. This works well.

n

Now I want to implement a drill down feature for this chart. I have created another page with a qSIChartView web part. This one also needs to query an Oracle DB view – but needs to use values passed by the first page.

n

Page 1 – http://<site>/SitePages/mainchart.aspx

n

Page 2 – http://<site>/SitePages/drilldownlevel1.aspx

n

On clicking the chart in Page 1, I am taken to Page 2 with necessary parameters (http://<site>/SitePages/drilldownlevel1.aspx?Param1=Value1&Param2=Value2

n

I am not able to figure out how to use these parameters in the SQL query in the qSIChartView web part in Page 2. For a regular qChartView web part, I could use a CAML query with Http parameters. But for qSIChartView, I got no luck yet [:(]

n

Any help/pointers would be highly appreciated [:)]

n

n

Cheers,

n

[Anonymous]

Hi (& everyone who stumbled upon this post),

n

Great news, I managed to get this working!! Here is what I did

n

1. Modify SI configuration file to add parameters.

n

    The parameters that you want to add in 'where' clause in the query, add them inside the SI configuration file within the specific source. Do specify appropriate datatypes too.

n

2. Add required parameters in qSIChartView web part – the ones that are necessary for your SQL query.

n

n

3. Modify SQL query to use these parameters

n

    There is a particular syntax that one needs to conform to so that these parameters can be supplied in the 'where' clause.

n

    Preceed the name of the parameter with a :

n

n

 

n

Once this is done, this web part will expect the specified parameter to be supplied via. query string. SQL query will be run with the value of the querystring parameter. You could extend this to include multiple parameters if required.

n

And voila! You can have drill down feature implemented using qSIChartView web parts [Y]

n

Cheers,

n

[Author]

Posts