1 Description | 2 Tile Preview | 3 Data-source | 4 Tile and Frame Setup

Summary	Shows the number of crew with unconfirmed sign on/off.
Keywords	Sign On/ Off

Description

The tile shows the number of the crew with an unconfirmed sign-on/off. The view is based on the crew list Unconfirmed Sign On/ Off and works only if you have it in your system.

Tile Preview

Data-source

The data-source should be added under the General Codes before setting up the tile. It defines the selection for the tile.

Unconfirmed Sign On

select 
  count (PIN) 
from VIEWID 
where Issue='Unconfirmed Sign ON'

Note: VIEWID should be substituted with the crew list view ID: e.g PW001SRV51 . The crew list view ID can be checked in the General Codes.

Unconfirmed Sign Off

select 
  count (PIN) 
from VIEWID where Issue='Unconfirmed Sign OFF' 
--and NUMORGID=:P_CLIENTID

Note: VIEWID should be substituted with the crew list view ID: e.g PW001SRV51 . The crew list view ID can be checked in the General Codes.

Tile and Frame Setup

The tile should be set up in the following way, with the link to the Unconfirmed Sign On/ Off crew list view. The rest of the settings are up to your preferences.

The frame should be set up with the link to the proper data-source. The rest of the settings are up to your preferences.

In our example we use:

Tile Color: 14588416 (blue) and Grey
Font Size: 11
Font Name: Arial
Align: MiddleCenter