# Search staff

Advanced staff filtering with custom GraphQL where clauses and dynamic ordering

Provides flexible, enterprise-grade filtering for staff directory queries with boolean logic,
relationship traversal, and multi-field ordering.

Key capabilities include boolean operators (_and, _or, _not), text matching (_ilike),
comparison operators (_gt, _gte, _lt, _lte, _eq, _neq), array operators (_in, _nin),
and nested/related filtering (e.g., by office or manager).

Real Example:
bash
curl --location 'https://{{host}}/v1/staff/search' \
--header 'Authorization: bearer {{token}}' \
--header 'Content-Type: application/json' \
--data '{
  "pageSize": 1,
  "where": {
    "_and": [
      {
        "_or": [
          {
            "firstName": {
              "_ilike": "%john%"
            }
          },
          {
            "lastName": {
              "_ilike": "%doe%"
            }
          }
        ]
      },
      {
        "active": {
          "_eq": true
        }
      },
      {
        "createdAt": {
          "_gte": "1900-01-01T00:00:00Z"
        }
      },
      {
        "deptId": {
          "_in": [
            1,
            2,
            3
          ]
        }
      }
    ]
  },
  "orderBy": [
    {
      "lastName": "asc"
    },
    {
      "firstName": "asc"
    }
  ]
}'

Endpoint: POST /gql/v1/staff/search
Version: 1.0.0
Security: BearerAuth

## Request fields (application/json):

  - `limit` (integer)
    Maximum number of staff to return
    Example: 1

  - `where` (object)
    GraphQL-style where clause for complex staff filtering
    Example: {"_and":[{"_or":[{"firstName":{"_ilike":"%john%"}},{"lastName":{"_ilike":"%doe%"}}]},{"active":{"_eq":true}},{"createdAt":{"_gte":"1900-01-01T00:00:00Z"}},{"deptId":{"_in":[1,2,3]}}]}

  - `orderBy` (array)
    Dynamic ordering specifications with multiple fields
    Example: [{"lastName":"asc"},{"firstName":"asc"}]

## Response 200 fields (application/json):

  - `staff` (array)

  - `staff.id` (integer)
    Unique staff identifier
    Example: 202

  - `staff.pmsRef` (string)
    PMS reference identifier
    Example: "2254"

  - `staff.firstName` (string)
    Staff member first name
    Example: "Holley"

  - `staff.lastName` (string)
    Staff member last name
    Example: "Abbott"

  - `staff.email` (string)
    Primary email address
    Example: "ena.toy@hotmail.com"

  - `staff.active` (boolean)
    Whether the staff member is active
    Example: true

  - `staff.deptId` (integer)
    Department identifier
    Example: 8

  - `staff.jobTitle` (string,null)
    Job title of the staff member

  - `staff.type` (string,null)
    Staff member type or category

  - `staff.officeId` (integer)
    Office identifier where the staff member is based
    Example: 2

  - `staff.staffManagerId` (integer,null)
    Identifier of the staff member's manager

  - `total` (object)

  - `total.aggregate` (object)

  - `total.aggregate.count` (integer)
    Total number of staff records matching criteria
    Example: 1


## Response 400 fields

## Response 401 fields

## Response 500 fields