Duties

An Outreach-suggested role or job duty played by a user in their organization.

Select

The 本製品 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 本製品.

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

For example, the following query is processed server side:

SELECT * FROM Duties WHERE Id = 1

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

SELECT * FROM Duties WHERE Id >= 1

SELECT * FROM Duties WHERE Id <= 4

SELECT * FROM Duties WHERE Id > 1

SELECT * FROM Duties WHERE Id < 4

Columns


Name	Type	Description
Id [KEY]	Integer	Id of duty.
DutyType	String	The polymorphic type of the duty.
SymbolicName	String	The string constant used to refer to this duty which can be internationalized on the client.
Type	String	Type.

SSIS Components for Outreach

Duties

Select

Columns