Resource Queries Folder

The Catalog folder \\Public\Meridium\Modules\Inspection\Resource Queries contains the following items.

Query	Behavior and Usage
All Human Resources	Returns a list of all the Human Resource records in the database. This query contains the following URL Fields: Manage Resource Roles (Field Alias: Manage Roles): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record. Manage Resource Certifications (Field Alias: Manage Certifications): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.
Human Resources with Certification	Returns a list of Human Resource records that are linked to a Personnel Certification record. This query contains the following URL Field: Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.
Human Resources with Roles	Returns a list of Human Resource records that are linked to a Resource Role record. This query contains the following URL Field: Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record.

Query

Behavior and Usage

All Human Resources

Returns a list of all the Human Resource records in the database.

This query contains the following URL Fields:

Manage Resource Roles (Field Alias: Manage Roles): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record.
Manage Resource Certifications (Field Alias: Manage Certifications): Displays the Human Resource record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.

Human Resources with Certification

Returns a list of Human Resource records that are linked to a Personnel Certification record.

This query contains the following URL Field:

Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Personnel Certification records that are linked to the Human Resource record.

Human Resources with Roles

Returns a list of Human Resource records that are linked to a Resource Role record.

This query contains the following URL Field:

Last Name: Displays the Human Resource Record in the master/detail datasheet. The detail grid lets you view and create Resource Role records that are linked to the Human Resource record.