Find
Execute a raw text search against the entities, ClientContact, JobOrder, Candidate, ClientCorporation, Lead, Opportunity.
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 | The unique identifier of an entity. |
| EntityType | String | The type of the entity. |
| ByLine | String | The results by line. |
| Location | String | Location of the entity. |
| Title | String | The title of the result. |
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 | A raw text you want to search for. |