Configure a Boolean Billboard Parameter

Boolean parameters represent binary inputs or values that are in one of two possible states: true or false. Boolean parameters are used to toggle specific conditions or filters.

Copy

Example: If the boolean parameter {Error} is set to true (that is, 1), then only despatch orders with an error message in the DespatchOrderState table are returned.

select do.DespatchOrderID 'ID', 
    do.Name 'Despatch Order Name',
    dos.ErrorMessage 'Error Message'
from DespatchOrderState dos,
    DespatchOrder do
where dos.DespatchOrderID = do.DespatchOrderID
    and (case isnull(dos.ErrorMessage, '') when '' then 0 else 1 end) in (1, {Error})

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 » Bool 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.
    • Default Value—Default value of the parameter, used to display a preview of the SQL query.
  5. Click Save.