Troubleshooting
Problem
This document details one possible way to ensure that you are prompted to select a Content Manager data source and/or database schema prior to executing queries.
Resolving The Problem
1. Create a new table in your database that contains the names of the Content Manager data sources (e.g. TestDB1, TestDB2 etc...).
2. In Framework Manager create a new query subject based on that references the table from step 1. E.g., [Tables].[DataSource_Selection].[cmDataSource]
3. Add the prompt macro expressions below as the values for the Content Manager Datasource and Schema properties of the data source in Framework Manager.
Content Manager Datasource: #prompt('Data Source', 'token', '', 'Select a Datasource: ', '[Tables].[DataSource_Selection].[cmDataSource]')#
Schema: #prompt('Schema Name:','token')#
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21374654