invantive documentation
Invantive Support ForumsLog In / Sign Up

TaskCalendarItems: Gripp CRM Task Calendar Items

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Task Calendar Items

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.

Table Columns

The columns of the table TaskCalendarItems 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
_ordering int32 Sorting Order writable
calendaritememployee_discr varchar2 itgen_gripp_calendaritememployee_discr writable, calendaritememployee.discr
calendaritememployee_id int32 Calendar Item Employee ID writable, calendaritememployee.id
calendaritememployee_searchname varchar2 Calendar Item Employee Search Name writable, calendaritememployee.searchname
completedon_date datetime Completed on (Date) writable, completedon.date
completedon_timezone varchar2 Completed on (Time Zone) writable, completedon.timezone
completedon_timezone_type int32 Completed on (Time Zone Type) writable, completedon.timezone_type
createdon_date datetime Created on Date writable, createdon.date
createdon_timezone varchar2 Created on Time Zone writable, createdon.timezone
createdon_timezone_type int32 Created on Time Zone Type writable, createdon.timezone_type
date_date datetime Date Date writable, date.date
date_timezone varchar2 Date Time Zone writable, date.timezone
date_timezone_type int32 Date Time Zone Type writable, date.timezone_type
extendedproperties varchar2 Extended Properties writable
hours double Hours writable
id int32 ID writable
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id
searchname varchar2 Search Name writable
subject varchar2 Subject writable
task_discr varchar2 itgen_gripp_task_discr writable, task.discr
task_id int32 Task ID writable, task.id
task_searchname varchar2 Task Search Name writable, task.searchname
time datetime Time writable, time.date
timelineentry_discr varchar2 itgen_gripp_timelineentry_discr writable, timelineentry.discr
timelineentry_id int32 Timeline Entry ID writable, timelineentry.id
timelineentry_searchname varchar2 Timeline Entry Search Name writable, timelineentry.searchname
updatedon_date datetime Updated on Date writable, updatedon.date
updatedon_timezone varchar2 Updated on Time Zone writable, updatedon.timezone
updatedon_timezone_type int32 Updated on Time Zone Type writable, updatedon.timezone_type

Keys

Key Column Refers to Kind Description
TaskCalendarItems_parent_id_fk parent_id Tasks.id Key

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 GrippCrm..TaskCalendarItems is renamed to GrippCrm.GrippCrm.TaskCalendarItems

A statement that names GrippCrm..TaskCalendarItems fails after the upgrade; use GrippCrm.GrippCrm.TaskCalendarItems. The table 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

All changes of the driver, 26.0 to 27.0