...

Description

The tile shows how many expired documents - Competence, Travel, Medical and Passports - exist in the system as of today based on the Standard Expiry crew list view.

Tile Preview

Data-source

Should be added in Setup > General Codes Table > Start Page > Datasource:

...

select 
count (PIN) 
from PW001SRV7
where DOC='Competence' and VALID< (Getdate()+30)

select 
count (PIN) 
from PW001SRV7
where DOC='Medical' and VALID< Getdate()

select 
count (PIN) 
from PW001SRV7
where DOC='Travel' and VALID< (Getdate()+60)

select 
count (PIN) 
from PW001SRV7
where DOC='Passport' and VALID< (Getdate()+90)

Tile Setup

See example of the setup for Expired Competences. Other document types can be set up in a similar way.

...

Frame Setup

Select the corresponding Datasource code in Text Area > Data Source.

...