Find
Executes a raw text search across multiple Bullhorn CRM entities. This view supports global search workflows by returning records that match free-text criteria across entities such as candidates, client contacts, job orders, leads, and opportunities.
View Specific Information
Except the pseudo columns, no filters are handled server-side on this view. The 'Query' pseudo column must be specified when querying this view.
SELECT * FROM Find WHERE query = 'My search'
Columns
| Name | Type | Description |
| EntityId [KEY] | Int | Represents the unique identifier (Id) of the entity that is returned by the find operation. This value supports cross-referencing and enables downstream workflows to retrieve or manipulate the correct record. |
| EntityType | String | Indicates the type of entity that is returned by the find operation. This value supports result classification and determines which entity-specific workflows can act on the result set. |
| ByLine | String | Captures the line-oriented summary that is generated for the search result. This value supports user-interface display and provides an at-a-glance reference when reviewing multiple matching entities. |
| Location | String | Captures the location information that is associated with the returned entity. This value supports filtering, sorting, and distance-based evaluation in search and discovery workflows. |
| Title | String | Captures the title or primary label that is associated with the result entity. This value supports user recognition and enhances readability when reviewing or selecting from search results. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Query | String | Captures the raw search text that is provided to the find operation. This value supports dynamic, free-form search behavior and enables the system to match partial or unstructured user input. |