TaskPriorities

Descriptor of importance used for categorizing tasks.

Select

The component 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 component.

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

For example, the following query is processed server side:

SELECT * FROM TaskPriorities WHERE Id = 1

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

SELECT * FROM TaskPriorities WHERE Id >= 1

SELECT * FROM TaskPriorities WHERE Id <= 1

SELECT * FROM TaskPriorities WHERE Id > 1

SELECT * FROM TaskPriorities WHERE Id < 2

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

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

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

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

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

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

SELECT * FROM TaskPriorities WHERE Name = 'test'

SELECT * FROM TaskPriorities WHERE Weight > 10

SELECT * FROM TaskPriorities WHERE Weight = 10

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

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

Columns


Name	Type	Description
Id [KEY]	Integer	Id of task priority.
Color	Long	The color the task priority label will be highlighted in the interface specified as a hexadecimal value.
CreatedAt	Datetime	The date and time the task priority was created.
Name	String	The name of the task priority.
UpdatedAt	Datetime	The date and time the task priority was last updated.
Weight	Integer	A relative value used for display order value task priorities are listed from lowest to highest weight.
LinksSelf	String	Links self.
SequenceStepsLinks	String	The associated sequence steps.
TasksLinks	String	The associated tasks.
Type	String	Type.

SSIS Components for Outreach

TaskPriorities

Select

Columns