| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 6 |
|---|
| outline | false |
|---|
| styletype | defaultflat |
|---|
| typeseparator | flatpipe |
|---|
| printable | false |
|---|
|
| Page Properties |
|---|
|
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. | Keywords | Documents, expiry |
|---|
Category | Start Page |
|---|
|
...
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:
...
| Expand |
|---|
|
| Code Block |
|---|
select
count (PIN)
from PW001SRV7
where DOC='Competence' and VALID< (Getdate()+30) |
|
| Expand |
|---|
|
| Code Block |
|---|
select
count (PIN)
from PW001SRV7
where DOC='Medical' and VALID< Getdate() |
|
| Expand |
|---|
|
| Code Block |
|---|
select
count (PIN)
from PW001SRV7
where DOC='Travel' and VALID< (Getdate()+60) |
|
| Expand |
|---|
|
| Code Block |
|---|
select
count (PIN)
from PW001SRV7
where DOC='Passport' and VALID< (Getdate()+90) |
|
Tile Setup
See the example of the setup for Expired Competences. Other document types can be set up in a similar way.
...
Type the text that should be shown on the tile in the Display Text field.
...
