Stores knowledge-base articles and troubleshooting guides used for resolving support cases.

Table-Specific Information

The Solutions table is only accessible when connected to a ZohoCRM Enterprise Edition account. If using a different edition, this table may not be available.

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 supported columns and operators. The remainder of the filter is executed client-side within the connector.

Insert

The following example demonstrates a basic insert operation:

-- Insert a new solution with a title and initial status
INSERT INTO Solutions (SolutionTitle, Status) VALUES ('Converting from XML to JSON', 'Created')

Required fields: SolutionTitle is required. It provides the title of the solution being documented.

Any field which is not read-only (ReadOnly = false in the table schema) can be inserted.

Delete

You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:

-- Delete a solution by its unique ID
DELETE FROM Solutions WHERE Id = '3152079000000153079'

Update

You must specify the Id column in the WHERE clause to update a record. The following example demonstrates an update operation:

-- Update the question field for a specific solution using its ID
UPDATE Solutions SET Question = 'Changed from the API.' WHERE Id = '3152079000000492018'

Required fields: Id is required. The update must target a specific record.

Any field which is not read-only (ReadOnly = false in the table schema) can be updated.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier for the solution.
SolutionNumber	String	False	Number assigned to the solution.
SolutionOwner_Id	String	False	Identifier of the user who owns the solution.
SolutionOwner_FirstName	String	True	First name of the solution owner.
SolutionOwner_LastName	String	True	Last name of the solution owner.
SolutionOwner_Email	String	True	Email address of the solution owner.
SolutionOwner_Name	String	True	Full name of the solution owner.
SolutionTitle	String	False	Title or headline of the solution.
Published	Bool	False	Indicates whether the solution has been published.
Status	String	False	Current status of the solution.
ProductName_Id	String	False	Identifier of the associated product.
ProductName_Name	String	True	Name of the associated product.
No.ofcomments	Int	True	Number of comments associated with the solution.
CreatedBy_Id	String	False	Identifier of the user who created the solution.
CreatedBy_FirstName	String	True	First name of the creator.
CreatedBy_LastName	String	True	Last name of the creator.
CreatedBy_Email	String	True	Email address of the creator.
CreatedBy_Name	String	True	Full name of the creator.
ModifiedBy_Id	String	False	Identifier of the user who last modified the solution.
ModifiedBy_FirstName	String	True	First name of the user who last modified the record.
ModifiedBy_LastName	String	True	Last name of the user who last modified the record.
ModifiedBy_Email	String	True	Email address of the user who last modified the record.
ModifiedBy_Name	String	True	Full name of the user who last modified the record.
CreatedTime	Datetime	False	Date and time the solution was created.
ModifiedTime	Datetime	False	Date and time the solution was last modified.
Tag	String	False	Tags associated with the solution.
Question	String	False	Question or issue that the solution addresses.
Answer	String	False	Answer or resolution provided by the solution.
AddComment	String	False	Field for adding a new comment to the solution.
Comments	String	True	List of comments associated with the solution.
Locked	Bool	True	Indicates whether the solution is locked from editing.
LastActivityTime	Datetime	False	Date and time of the most recent activity on the 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	Fields used to check for duplicates during an upsert. The REST API supports multiple fields; the BULK API supports only one.
Trigger	String	Indicates whether to trigger automation rules during record insertion.
CustomViewId	Long	Custom view identifier used to filter this record when the useCOQL parameter is set to false.