Solutions
Create, update, delete, and query information regarding solutions.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
The connector uses the Zoho CRM API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
Insert
INSERT INTO Solutions (SolutionTitle, Status) VALUES ('Converting from XML to JSON', 'Created')
Required fields: SolutionTitle.
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM Solutions WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Solutions SET Question = 'Changed from the API.' WHERE Id = '3152079000000492018'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier for this record. |
| SolutionNumber | String | False |
The number of the solution. |
| SolutionOwner_Id | String | False |
The Id of the owner of the solution. |
| SolutionOwner_FirstName | String | False |
The First Name of the owner of the solution. |
| SolutionOwner_LastName | String | False |
The Last Name of the owner of the solution. |
| SolutionTitle | String | False |
The title of the solution. |
| Published | Bool | False |
Whether the solution is published or not. |
| Status | String | False |
The status of the solution. |
| ProductName_Id | String | False |
The Id of the product concerning this solution. |
| No_ofcomments | Int | True |
The number of different comments in this solution. |
| CreatedBy_Id | String | False |
The Id of the User who created the record. |
| ModifiedBy_Id | String | False |
The Id of the User who modified the record. |
| ModifiedBy_FirstName | String | False |
The First Name of the User who modified the record. |
| ModifiedBy_LastName | String | False |
The Last Name of the User who modified the record. |
| CreatedTime | Datetime | False |
The time when the record was created. |
| ModifiedTime | Datetime | False |
The time when the record was modified. |
| Tag | String | False |
A list of tags related to this record. |
| Question | String | False |
The question which was asked that led to the creating of this solution. |
| Answer | String | False |
The answer given for this solution. |
| AddComment | String | False |
An additional comment give for this solution. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String |
The field/s to be used for checking in an upsert. |
| CustomViewId | Long |
The custom view Id to be used for filtering this record. Will work when useCOQL=false. |