invantive documentation
Invantive Support ForumsLog In / Sign Up

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.id ``

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
_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

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

All changes of the driver, 26.0 to 27.0