TaskCalendarItemsByTaskId: Gripp CRM Task Calendar Items by Task ID
read only REST
- Catalog:
GrippCrm - Schema:
GrippCrm - Label: Task Calendar Items by Task ID
Can only retrieve data.
API Source
- Endpoint:
api3.php
Performance Characteristics
| Characteristic | Value |
|---|---|
| Write rows per minute | 8,930 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
task. |
`` |
Table Columns
The columns of the table TaskCalendarItemsByTaskId are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
_ |
int32 |
Sorting Order | writable | ||
calendaritememployee_ |
varchar2 |
itgen_gripp_calendaritememployee_discr | writable, calendaritememployee. |
||
calendaritememployee_ |
int32 |
Calendar Item Employee ID | writable, calendaritememployee. |
||
calendaritememployee_ |
varchar2 |
Calendar Item Employee Search Name | writable, calendaritememployee. |
||
completedon_ |
datetime |
Completed on (Date) | writable, completedon. |
||
completedon_ |
varchar2 |
Completed on (Time Zone) | writable, completedon. |
||
completedon_ |
int32 |
Completed on (Time Zone Type) | writable, completedon. |
||
createdon_ |
datetime |
Created on Date | writable, createdon. |
||
createdon_ |
varchar2 |
Created on Time Zone | writable, createdon. |
||
createdon_ |
int32 |
Created on Time Zone Type | writable, createdon. |
||
date_ |
datetime |
Date Date | writable, date. |
||
date_ |
varchar2 |
Date Time Zone | writable, date. |
||
date_ |
int32 |
Date Time Zone Type | writable, date. |
||
extendedproperties |
varchar2 |
Extended Properties | writable | ||
hours |
double |
Hours | writable | ||
id |
int32 |
ID | writable | ||
parent_ |
int32 |
itgen_gripp_parent_id | filters on the platform, writable, ::ancestor. |
||
searchname |
varchar2 |
Search Name | writable | ||
subject |
varchar2 |
Subject | writable | ||
task_ |
varchar2 |
itgen_gripp_task_discr | writable, task. |
||
task_ |
int32 |
Task ID | writable, task. |
||
task_ |
varchar2 |
Task Search Name | writable, task. |
||
time |
datetime |
Time | writable, time. |
||
timelineentry_ |
varchar2 |
itgen_gripp_timelineentry_discr | writable, timelineentry. |
||
timelineentry_ |
int32 |
Timeline Entry ID | writable, timelineentry. |
||
timelineentry_ |
varchar2 |
Timeline Entry Search Name | writable, timelineentry. |
||
updatedon_ |
datetime |
Updated on Date | writable, updatedon. |
||
updatedon_ |
varchar2 |
Updated on Time Zone | writable, updatedon. |
||
updatedon_ |
int32 |
Updated on Time Zone Type | writable, updatedon. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
Table function GrippCrm..TaskCalendarItemsByTaskId is renamed to GrippCrm.GrippCrm.TaskCalendarItemsByTaskId
A statement that names GrippCrm..TaskCalendarItemsByTaskId fails after the upgrade; use GrippCrm.GrippCrm.TaskCalendarItemsByTaskId. The table function has 29 columns. The driver registered its objects without a schema in release 26.0; from 27.0 the schema is GrippCrm.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 5