Obtain Billboard Data Using a SQL Query

See Billboard Parameters for examples of parameters used in SQL queries.

If a list of values returned from the SQL query is used directly inside the SQL statement, the semicolon character needs to be replaced with a comma character. For billboards that use a SQL query, MineMarket does this just before the query is executed.

Security Note: You need the Allow billboard maintenance security right in the Billboards domain security rights group for this activity.

Activity Steps

1. Open the Billboard (configuration).
2. Select the Data Set Editor tab.
3. Select the Data node in the Data Tables field group.
4. Set the Data Source Type to SQL Query.
5. If a billboard parameter is to be inserted into the SQL query:
   1. Configure the billboard parameter.
   2. Right-click in SQL Query and select Add Billboard Parameter from the menu.
   3. Select the required billboard parameter from the configured billboard parameters.

      In the SQL Query string, the parameter displays in curly brackets {}. For example:

      select * from Product where ProductCode like {ParameterX}

   Note: The query string itself does not have to include quotes around the parameter (that is, {Parameter} and not '{Parameter}') because the quotes are automatically added when the actual value is substituted.

6. Complete the following fields.
   • Database Connection
   • SQL Query
7. Click Save.