invantive documentation
Invantive Support ForumsLog In / Sign Up

AbsenceRequestAbsenceRequestLines: Gripp CRM Absence Request Lines

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Absence Request Lines

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 AbsenceRequestAbsenceRequestLines 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
absencerequest_discr varchar2 itgen_gripp_absencerequest_discr writable, absencerequest.discr
absencerequest_id int32 Absence Request ID writable, absencerequest.id
absencerequest_searchname varchar2 Absence Request Search Name writable, absencerequest.searchname
absencerequeststatus_discr varchar2 itgen_gripp_absencerequeststatus_discr writable, absencerequeststatus.discr
absencerequeststatus_id int32 Absence Request Status ID writable, absencerequeststatus.id
absencerequeststatus_searchname varchar2 Absence Request Status Search Name writable, absencerequeststatus.searchname
amount double Amount writable
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
description varchar2 Description writable
extendedproperties varchar2 Extended Properties writable
id int32 ID writable
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id
searchname varchar2 Search Name writable
startingtime datetime Starting Time writable, startingtime.date
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
AbsenceRequestAbsenceRequestLines_parent_id_fk parent_id AbsenceRequests.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..AbsenceRequestAbsenceRequestLines is renamed to GrippCrm.GrippCrm.AbsenceRequestAbsenceRequestLines

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