Stores knowledge-base articles and troubleshooting guides used by support teams to resolve 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 the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.

The provider 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 provider.

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 of the solution.
Solution_Number	String	True	Reference number assigned to the solution.
Owner_Id	String	False	Identifier of the user who owns the solution.
Owner_FirstName	String	True	First name of the solution owner.
Owner_LastName	String	True	Last name of the solution owner.
Owner_Email	String	True	Email address of the solution owner.
Solution_Title	String	False	Title of the solution.
Published	Bool	False	Indicates whether the solution is published.
Status	String	False	Current status of the solution.
Product_Name_Id	String	False	Identifier of the related product.
No_of_comments	Int	True	Number of comments added to the solution.
Created_By_Id	String	False	Identifier of the user who created the solution.
Modified_By_Id	String	False	Identifier of the user who last modified the solution.
Modified_By_FirstName	String	True	First name of the user who last modified the solution.
Modified_By_LastName	String	True	Last name of the user who last modified the solution.
Modified_By_Email	String	True	Email address of the user who last modified the solution.
Created_Time	Datetime	False	Date and time when the solution was created..
Modified_Time	Datetime	False	Date and time when the solution was last modified.
Tag	String	False	Tags associated with the solution.
Question	String	False	Question or problem statement addressed by the solution.
Answer	String	False	Answer or resolution provided in the solution.
Add_Comment	String	False	New comment added to the solution.
Id_CustomModule	Long	True	Record identifier used internally.
Locked__s	Bool	True	Indicates whether the record is locked for editing.
Last_Activity_Time	Datetime	False	Date and time of the last activity related to the solution.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.