TDV Adapter for Outreach

Build 22.0.8462

TaskPriorities

Descriptor of importance used for categorizing tasks.

Select

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

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462