Loading...

RE: Unable to implement drilldown for qSIChartView web part

RE: Unable to implement drilldown for qSIChartView web part

Home Forums QuickApps Forum Unable to implement drilldown for qSIChartView web part RE: Unable to implement drilldown for qSIChartView web part

#6860
Anonymous
Anonymous
Participant

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