OpportunityProspectRoles

Get details of prospect roles and associated with an opportunity.

Select

The driver will use the Outreach API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.

For example, the following query is processed server side:

SELECT * FROM OpportunityProspectRoles WHERE Id = 1

SELECT * FROM OpportunityProspectRoles WHERE Id IN (1, 2)

SELECT * FROM OpportunityProspectRoles WHERE Id >= 1

SELECT * FROM OpportunityProspectRoles WHERE Id <= 1

SELECT * FROM OpportunityProspectRoles WHERE Id > 1

SELECT * FROM OpportunityProspectRoles WHERE Id < 2

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM OpportunityProspectRoles WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

Columns


Name	Type	Description
Id [KEY]	Integer	Id of opportunity prospect role.
CreatedAt	Datetime	The date and time the role was created.
Primary	Boolean	A boolean value indicating if this prospect is the primary contact within an opportunity.
Role	String	A string value representing the role.
UpdatedAt	Datetime	The date and time the role was last updated.
ProspectId	Integer	Prospect's Id.
OpportunityId	Integer	Opportunity's Id.

ODBC Driver for Outreach

OpportunityProspectRoles

Select

Columns