invantive documentation
Invantive Support ForumsLog In / Sign Up

AbsenceRequestAbsenceRequestLinesByAbsenceRequestId: Gripp CRM Absence Request Lines by Absence Request ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Absence Request Lines by Absence Request 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
absencerequest.id ``

Table Columns

The columns of the table AbsenceRequestAbsenceRequestLinesByAbsenceRequestId 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

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

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