There are two URL routes associated with queries: query and qdetail. The following table describes the various paths that build on the route, and the elements that you can specify for each.
Element | Description | Accepted Value(s) | Syntax |
---|---|---|---|
query: Displays the Query page. | |||
query/<EntityKey>/<WorkspaceName>: Displays the <QueryName> or New Query page. | |||
Catalog Item Key | Specifies the Catalog Item Key of the query that you want to open in the Query tool. | Numeric Catalog item key | #query/Catalog Item Key |
Catalog Item Path | Specifies the path and name of the query that you want to open in the Query tool. |
Catalog item path |
#query?path=Catalog Path\Query name |
p0, p1, p2 etc. (specifying a literal value) | Specifies a literal value that will be passed into a query containing a prompt. | Any value that is acceptable for the prompt type (e.g., numeric values for numeric prompts) |
#query/Catalog Item Key?p0=Literal Value #query?path=Catalog Path\Query name&p0=Literal Value |
p0, p1, p2 etc. (specifying a variable value) | Specifies a variable value from a specified column key in a query that will be passed from a query into a query containing a prompt. | Any value that is acceptable for the prompt type (e.g., numeric values for numeric prompts) |
#query/Catalog Item Key?p0={Column Key} #query?path=Catalog Path\Query name&p0={Column Key} |
qdetail/<Catalog Item Key>: Displays the query in a new, view-only page. | |||
Parameter Name = Parameter Value | Specifies the Parameter Name and Parameter Value of the query whose results you want to open in a new, view-only page. | Parameter Names and Parameter Values | #qdetail/Catalog Item Key?Parameter Name=Parameter Value |
Example URL | Destination |
---|---|
#query/3223198 | Opens the query with the Catalog Item Key of 3223198 in the Query tool. |
#query?path=Public\Meridium\Modules\Core\Queries\APM Query |
Opens the query named 'APM Query' in the Query tool that is found in the specified Catalog folder. |
#query/3223198?p0=Literal Value | Opens the query with the Catalog Item Key of 3223198 in the Query tool and passes the specified literal value into the first prompt in the query. |
#query?path=Public\Meridium\Modules\Core\Queries\APM Query&p0=Literal Value | Opens the query named 'APM Query' in the Query tool that is found in the specified Catalog folder and passes the specified literal value into the first prompt in the query. |
#query/3223198?p0={1} | Opens the query with the Catalog Item Key of 3223198 in the Query tool and passes the specified variable from an existing query into the first prompt of the query. |
#query?path=Public\Meridium\Modules\Core\Queries\APM Query&p0={1} | Opens the query named 'APM Query' in the Query tool that is found in the specified Catalog folder and passes the specified variable value from an existing query into the first prompt of the query. |
#qdetail/900000003707?Manufacturer=UNITED%2BPUMPS | Opens the results of the query with the Catalog Item Key 900000003707, Parameter Name Manufacturer, and Parameter Value UNITED%2BPUMPS in a new, view-only page. |
Copyright © 2018 General Electric Company. All rights reserved.