Filtering For Current Staff

[Steve.Stockstill]

There are a few ways you can filter records for the current staff. Both methods utilize the <CurrentStaff> built-in token. This token will be replaced at runtime with the staff of the currently logged in MobileTM user.

This example will filter the primary staff for undone records:
archive=0 AND done <> 'Y' AND staff = <CurrentStaff>

This example will filter the primary and supporting staff:
archive=0 AND CHARINDEX( <CurrentStaff> , staff+astaff) > 0