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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Query | String | A raw text you want to search for. |