Docstoc

IntelliVIEW SDK - Passing runtime filter in Query String

Document Sample
IntelliVIEW SDK - Passing runtime filter in Query String Powered By Docstoc
					                                                  IntelliVIEW SDK
                                                            Passing runtime filter in Query String




Revision History                                          Product Name: IntelliVIEW SDK


V.No.    Creation /   Description                      Product       Prepared by      Reviewed   Approved by   Remarks
         modificati                                    Version                        by
         on Date
1.0      9 August     Documentation on passing         IntelliVIEW   Srinivas Reddy
         2007         runtime filter in Query String   SDK 3.6.1     Kaila




      Confidential
      Synaptris Inc., 37, Sterling Road, Nungambakkam Chennai 34                                               Page 13
Overview:

During the publishing process of a report from IntelliVIEW Designer to IntelliVIEW SDK,
Designer will return a URL that end user can use to see the report in browser.

IntelliVIEW SDK prompts the user a generic page to enter the runtime filter values.

This document explains how to pass these runtime filters in Query String of the published-
URL when the “runtime” setting is turned off in the Web.config file.

The URL http://10.60.8.212:8081/websdk/viewivwr.aspx?filename= followed by a name in
the following examples is the Published URL that is returned by Designer at the time of
publishing.

Applies to:
IntelliVIEW SDK 3.6.1               (Only query-based reports)
IntelliVIEW SDK 3.7
IntelliVIEW Reporter 3.6.1          (Only query-based reports)
IntelliVIEW Reporter 3.7

Audience:
This document is intended for developers of any business application in which IntelliVIEW is
being integrated.

Passing runtime filters in Query String

         Analysis (Grid) - Query based report:

http://10.60.8.212:8081/websdk/viewivwr.aspx?filename=titles_gridreport&RsQid=gridquer
y&params=type='business' and royalty=10


RsQid: Pass the value as “gridquery” in case of Analysis (Grid) Report.
Params: Pass the filter condition. All valid SQL logical operators are allowed in case of using
more than one condition.

         Standard (Freeform) report with Single Query:

http://10.60.8.212:8081/websdk/viewivwr.aspx?filename=titles_freeformreport&RsQid=qu
ery1&params=type='business' and royalty=10

RsQid: Pass the name of the Query.
Params: Pass the filter condition. All valid SQL logical operators are allowed in case of using
more than one condition.

         Standard (Freeform) report with Multiple Queries:




Confidential
Synaptris Inc., 37, Sterling Road, Nungambakkam Chennai 34                               Page 23
http://10.60.8.212:8081/websdk/viewivwr.aspx?filename=multiplequeryreport&RsQid=quer
y1;query2&params=type='business';title_id='BU1032'

RsQid: Pass the semi-colon (;) separated names of the Queries.
Params: Pass the semi-colon (;) separated filter conditions. All valid SQL logical operators
are allowed in case of using more than one condition.

Filter conditions will be applied to the Queries respectively. i.e., Filter1 on Query1 and
Filter2 on Query2 and so on.

         Analysis (Grid) - SP based report:

http://10.60.8.212:8081/websdk/viewivwr.aspx?filename=sp_gridreport&RsQid=gridquery
&params=[@type~business~varchar~input]~[@royalty~24~int~input]
       ~[@pub_id~0736~varchar~input]

RsQid: Pass the value as “gridquery” in case of Analysis (Grid) Report.
Params: Pass the parameter information enclosed in square-braces ([]) with ~ separators.
Each parameter’s information should contain name, value, datatype and direction (input,
output or inout) – each of these again separated with ~.

         Standard (Freeform) – SP based report:

http://10.60.8.212:8081/websdk/viewivwr.aspx?filename=sp_gridreport&RsQid=query&par
ams=[@type~business~varchar~input]~[@royalty~24~int~input]
       ~[@pub_id~0736~varchar~input]

RsQid: Pass the value as “gridquery” in case of Analysis (Grid) Report.
Params: Pass the parameter information enclosed in square-braces ([]) with ~ separators.
Each parameter’s information should contain name, value, datatype and direction (input,
output or inout) – each of these again separated with ~.

Note:

While passing varchar type parameters to a query report, it should be enclosed with single
quotes. But the same type parameter should not be enclosed with single quotes for SP
report.

Limitation:

Designer does not support for creating multiple SPs in free form report.




Confidential
Synaptris Inc., 37, Sterling Road, Nungambakkam Chennai 34                                   Page 33

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:47
posted:11/19/2011
language:English
pages:3