Configure a Number Billboard Parameter

Number parameters enable entry of numbers; that is, sequences of numerals such as quantities, in order to filter billboard or report results.

Copy

Example: Returns all barges that have a capacity greater than or equal to the value entered for the {MinCapacity} number parameter.

select b.Name, 
    b.LloydsNumber, 
    b.Capacity, 
    u.Symbol 'UOM'
from Barge b, 
    UOM u
where b.UOMID = u.UOMID
    and b.Capacity >= {MinCapacity}

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 » Number 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.