Configure a BTTextList Billboard Parameter

BTTextList parameters create selection criteria for string fields where the value comes from one of the predefined MineMarket Text Lists.

The BTTextListItem table must be joined in SQL queries that include BTTextList parameters.

Copy

Example: Return all organisations where the organisation status matches the value specified for the {OrgStatus} BTTextList parameter, which is based on the Organisation Status text list.

select o.Name 'Organisation', 
    o.OrgCode 'Code'
from Organisation o, 
    BTTextListItem b
where o.OrganisationStatus = b.BTTextListItemID
    and b.ItemValue = {OrgStatus}

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 Parameters tab.
  3. Right-click in the Parameters field group and select New » BTTextList Parameter from the menu.
  4. Complete the following fields.
    • Name—Case-sensitive name of the parameter that is used in the query.
    • Caption—Caption used when prompting for the parameter value.
    • Required—Whether the parameter must be defined before data can be retrieved.
    • Force Refresh—Whether the parameter is refreshed if its value is dynamic.
    • BTTextList—Predefined drop-down list from which the parameter value is selected.
    • Default Value—Default value of the parameter, used to display a preview of the SQL query.
  5. Click Save.