Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Bullhorn CRM Views
| Name | Description |
| CandidateCustomSearchLayout | Read data of the 'CustomSearch' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateFasterFindLayout | Read data of the 'FasterFind' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateListExpandedLeftLayout | Read data of the 'ListExpandedLeft' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateListRowLayout | Read data of the 'ListRow' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateMobileDetailsLayout | Read data of the 'Mobile Details' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateMobileEditLayout | Read data of the 'Mobile Edit' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateOverviewBottomLayout | Read data of the 'OverviewBottom' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateOverviewMiddleLeftLayout | Read data of the 'OverviewMiddleLeft' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateOverviewMiddleRightLayout | Read data of the 'OverviewMiddleRight' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateOverviewTopLayout | Read data of the 'OverviewTop' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateProfileHeaderLayout | Read data of the 'ProfileHeader' layout of the 'Candidate' entity in BullhornCRM system. |
| CandidateProfileRightSideBarLayout | Read data of the 'ProfileRightSideBar' layout of the 'Candidate' entity in BullhornCRM system. |
| EntityFiles | List the attached files to an entity. |
| Find | Execute a raw text search against the entities, ClientContact, JobOrder, Candidate, ClientCorporation, Lead, Opportunity. |
| JobOrderFasterFindLayout | Read data of the 'FasterFind' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderListExpandedCenterLayout | Read data of the 'ListExpandedCenter' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderListExpandedLeftLayout | Read data of the 'ListExpandedLeft' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderListExpandedRightLayout | Read data of the 'ListExpandedRight' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderListRowLayout | Read data of the 'ListRow' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderMobileDetailsLayout | Read data of the 'Mobile Details' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderMobileEditLayout | Read data of the 'Mobile Edit' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderOverviewBottomLayout | Read data of the 'OverviewBottom' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderOverviewMiddleLeftLayout | Read data of the 'OverviewMiddleLeft' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderOverviewMiddleRightLayout | Read data of the 'OverviewMiddleRight' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderProfileHeaderLayout | Read data of the 'ProfileHeader' layout of the 'JobOrder' entity in BullhornCRM system. |
| JobOrderProfileRightSideBarLayout | Read data of the 'ProfileRightSideBar' layout of the 'JobOrder' entity in BullhornCRM system. |
| SavedSearches | List the available saved searches. |
| SavedSearch_AA_pipeline | Query records of the 'AA - pipeline' saved search on 'CANDIDATE' entity. |
| SavedSearch_AK_06_26_19_NEW_DAI_search | Query records of the 'AK 06/26/19 NEW DAI search' saved search on 'CANDIDATE' entity. |
| SavedSearch_AK_BROAD_Controls | Query records of the 'AK BROAD Controls' saved search on 'CANDIDATE' entity. |
| SavedSearch_Alex_Bruno_Candidates | Query records of the 'Alex Bruno Candidates' saved search on 'CANDIDATE' entity. |
| SavedSearch_Anna_Allen_Prospect_and_Pipeline | Query records of the 'Anna Allen- Prospect and Pipeline' saved search on 'CANDIDATE' entity. |
| SavedSearch_Anna_W_Pipeline | Query records of the 'Anna W Pipeline' saved search on 'CANDIDATE' entity. |
| SavedSearch_assembler_tearsheets | Query records of the 'assembler tearsheets' saved search on 'CANDIDATE' entity. |
| SavedSearch_Chandlers_Pipeline | Query records of the 'Chandlers Pipeline' saved search on 'CANDIDATE' entity. |
| SavedSearch_Kroger_Recruiter_Admin | Query records of the 'Kroger Recruiter Admin' saved search on 'CANDIDATE' entity. |
| SavedSearch_mandy_pros_pipe | Query records of the 'mandy pros/pipe' saved search on 'CANDIDATE' entity. |
| SavedSearch_Mechanical_Designer | Query records of the 'Mechanical Designer' saved search on 'CANDIDATE' entity. |
| SavedSearch_QE_KY_search | Query records of the 'QE KY search' saved search on 'CANDIDATE' entity. |
| SavedSearch_Scott_s_targets | Query records of the 'Scott's targets' saved search on 'CLIENTCONTACT' entity. |
| SavedSearch_Sourced | Query records of the 'Sourced' saved search on 'CANDIDATE' entity. |
| SavedSearch_Taylor_Hunt_Prospects_Pipeline | Query records of the 'Taylor Hunt Prospects/ Pipeline' saved search on 'CANDIDATE' entity. |
| SavedSearch_Test_favorites | Query records of the 'Test favorites' saved search on 'CANDIDATE' entity. |
| SavedSearch_Wiring_Tech_Fairfield | Query records of the 'Wiring Tech. Fairfield' saved search on 'CANDIDATE' entity. |