Search for Individuals
The search form offers a user friendly way to locate individuals
.png)
The search box offers the users 4 options when searching for specific individuals.
1.By Name
2.By Employee ID
3.By Grade (drop-down box selector)
4.By Location (drop-down box selector)
.png)
SMART will then filter the record-set according to the criteria specified in the users search and return and records found.
When selecting search criteria by date SMART uses a standard date selector box.
This helps to ensure that there are no errors introduced by the date format set on users PC's i.e. mm/dd/yy (US) against dd/mm/yy (GB) would otherwise give different results if a user inputs dates such as 02/03/11, 03/08/11, 10/02/12 etc.
The following table shows how you can use Like to test expressions for different patterns. (wild cards, wild characters)
|
|
|
Match |
No match |
|
Multiple characters |
a*a |
aa, aBa, aBBBa |
aBC |
|
|
*ab* |
abc, AABB, Xab |
aZb, bac |
|
Special character |
a[*]a |
a*a |
aaa |
|
Multiple characters |
ab* |
abcdefg, abc |
cab, aab |
|
Single character |
a?a |
aaa, a3a, aBa |
aBBBa |
|
Single digit |
a#a |
a0a, a1a, a2a |
aaa, a10a |
|
Range of characters |
[a-z] |
f, p, j |
2, & |
|
Outside a range |
[!a-z] |
9, &, % |
b, a |
|
Not a digit |
[!0-9] |
A, a, &, ~ |
0, 1, 9 |
|
Combined |
a[!b-m]# |
An9, az0, a99 |
abc, aj0 |
The the example above the user has set the search criteria for the name field to "lin"
When clicking apply filter any records found will be load into the Employees details form. In the example below the search criteria returned 7 records.
Note: You can apply criteria to multiply search fields to further narrow your search.
.png)
The search form can also be loaded directly from the employee selectors form.
On Safe Lines QHSE Software Help file v1.07 : Copyright © 2018 On Safe Lines QHSE Software Ltd
|
Affordable QHSE Business Software |