invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectEmployeesByProjectId: Gripp CRM Project Employees by Project ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Project Employees by Project 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
project.id ``

Table Columns

The columns of the table ProjectEmployeesByProjectId 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
employee_id int32 Employee ID filters on the platform, writable, id
employee_searchname varchar2 Employee Search Name filters on the platform, writable, searchname
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id

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

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