Unconfirmed Sign On/ Off Tiles
- Daria Chebotaieva
- Sigrid Kviteberg
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_CLIENTIDNote: 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
Unconfirmed Sign On
Unconfirmed Sign Off