JDBC Driver for Bullhorn CRM

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654