Search for Individual

On Safe Lines Welcome Logo

QHSE Business Software
Click HERE to Learn More

 

 

 

Search for Individuals

 

The search form offers a user friendly way to locate individuals

 

 

 

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)

 

 

 

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)

 


Kind of match


Pattern

Match
(returns True)

No match
(returns False)

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.

The search form can also be loaded directly from the employee selectors form.

 


On Safe Lines QHSE Software Help file v1.08 : Copyright © 2019 On Safe Lines QHSE Software Ltd


On Safe Lines Welcome Logo

FREE to Try QHSE Business Software

click <here> to learn more...