Task table

Column Type

Project_Id

String

Task_Id

String

Currency_Id

String

Customer_Id

String

Task_Name

String

Project_Name

String

Customer_Name

String

Billed_Hours

String

Log_Time

Timestamp

Un_Billed_Hours

String

Is_Billable

Boolean

Description

String

Rate

Number

Status

String

Task_Custom_Fields

Array

Zohopeople_Job_Id

String

Examples

INSERT INTO
    Task (Project_Id, Task_Name, Description)
values
    (
        '579676000000093167',
        'QA Test',
        'Test the source code developed'
    )

UPDATE Task
SET
    description = description + '.'
WHERE
    Project_Id = '579676000000093167'
    AND Task_Id = '579676000000160004'

DELETE FROM Task
WHERE
    Project_Id = '579676000000093167'
    AND Task_id = '579676000000164003'