analytics/templates/ps/portal/iPrompting/logicsheets/query-datasource.xslt

<?xml version="1.0" encoding="UTF-8"?>
<!--
    Licensed Materials - Property of IBM

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2011

    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->
<!--
   Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
   Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
-->
<xsl:stylesheet version="1.0" 
		xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
		xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" 
		xmlns:xts="http://developer.cognos.com/schemas/xts/"
		xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" 
		xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
		exclude-result-prefixes="xsl cm xts send xtsext">
	<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
	<xsl:variable name="parameters" select="/root/parameters"/>
	<xsl:template match="/">
		<xts:sequence>
			<xsl:if test="/root/credentialParameters/credential/dataSourceConnection != ''">
				<xts:append>
					<dataSources>
						<xts:transform src="transforms/CM/post-process.xslt" processor="XSLT">
							<send:request provider="cm">
								<xts:transform src="transforms/CM/pre-process.xslt" processor="XSLT">
									<cm:query>
										<cm:requests>
											<xsl:for-each select="/root/credentialParameters/credential[./dataSourceConnection != '']">
												<cm:query>
													<cm:search>
														<xsl:value-of select="dataSourceConnection"/>
													</cm:search>
													<cm:properties>
														<cm:property name="defaultName"/>
														<cm:property name="parent"/>
													</cm:properties>
													<cm:options>
														<cm:refProps>
															<cm:refProp refPropName="parent">
																<cm:properties>
																	<cm:property name="defaultName"/>
																</cm:properties>
															</cm:refProp>
														</cm:refProps>
													</cm:options>
												</cm:query>
												<xsl:if test="dataSourceSignon!=''">
													<cm:query>
														<cm:search>
															<xsl:value-of select="dataSourceSignon"/>
														</cm:search>
														<cm:properties>
															<cm:property name="defaultName"/>
														</cm:properties>
													</cm:query>
												</xsl:if>
											</xsl:for-each>
										</cm:requests>
									</cm:query>
								</xts:transform>
							</send:request>
						</xts:transform>
					</dataSources>
				</xts:append>
			</xsl:if>
			
			<!-- This is used for jobSteps where we might have prompts set on the job and on the runnable. We have
			to query for both sets of data source prompts since the user can toggle the override checkbox -->
			<xsl:if test="/root/runnableParameters/credentialParameters/credential/dataSourceConnection != ''">
				<xts:append>
					<defaultDataSources>
						<xts:transform src="transforms/CM/post-process.xslt" processor="XSLT">
							<send:request provider="cm">
								<xts:transform src="transforms/CM/pre-process.xslt" processor="XSLT">
									<cm:query>
										<cm:requests>
											<xsl:for-each select="/root/runnableParameters/credentialParameters/credential[./dataSourceConnection != '']">
												<cm:query>
													<cm:search>
														<xsl:value-of select="dataSourceConnection"/>
													</cm:search>
													<cm:properties>
														<cm:property name="defaultName"/>
														<cm:property name="parent"/>
													</cm:properties>
													<cm:options>
														<cm:refProps>
															<cm:refProp refPropName="parent">
																<cm:properties>
																	<cm:property name="defaultName"/>
																</cm:properties>
															</cm:refProp>
														</cm:refProps>
													</cm:options>
												</cm:query>
												<xsl:if test="dataSourceSignon!=''">
													<cm:query>
														<cm:search>
															<xsl:value-of select="dataSourceSignon"/>
														</cm:search>
														<cm:properties>
															<cm:property name="defaultName"/>
														</cm:properties>
													</cm:query>
												</xsl:if>
											</xsl:for-each>
										</cm:requests>
									</cm:query>
								</xts:transform>
							</send:request>
						</xts:transform>
					</defaultDataSources>
				</xts:append>			
			</xsl:if>
		</xts:sequence>
	</xsl:template>
</xsl:stylesheet>