Solutions

Stores internal solution records such as help articles or knowledge base entries used for case resolution.

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 本製品 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 本製品.

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 record.
SolutionNumber	String	False	Automatically generated number assigned to the solution.
SolutionOwner_Id	String	False	Unique identifier of the user who owns this 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 subject of the solution.
Published	Bool	False	Indicates whether the solution is published and visible to users.
Status	String	False	Current status of the solution (for example, Draft, Published, or Archived).
ProductName_Id	String	False	Unique identifier of the product this solution is associated with.
ProductName_Name	String	True	Name of the product linked to this solution.
No.ofcomments	Int	True	Number of comments added to this solution.
CreatedBy_Id	String	False	Unique identifier of the user who created this solution.
CreatedBy_FirstName	String	True	First name of the user who created this record.
CreatedBy_LastName	String	True	Last name of the user who created this record.
CreatedBy_Email	String	True	Email address of the user who created this record.
CreatedBy_Name	String	True	Full name of the user who created this record.
ModifiedBy_Id	String	False	Unique identifier of the user who last modified this solution.
ModifiedBy_FirstName	String	True	First name of the user who last modified this record.
ModifiedBy_LastName	String	True	Last name of the user who last modified this record.
ModifiedBy_Email	String	True	Email address of the user who last modified this record.
ModifiedBy_Name	String	True	Full name of the user who last modified this record.
CreatedTime	Datetime	False	Date and time when the solution was created.
ModifiedTime	Datetime	False	Date and time when the solution was last modified.
Tag	String	False	Tags associated with the solution for easier categorization.
Question	String	False	The problem or question the solution is addressing.
Answer	String	False	The proposed answer or resolution to the question.
AddComment	String	False	Field to store new comments related to the solution.
Comments	String	True	Collection of comments made on this solution.
Locked	Bool	True	Indicates whether this solution is locked from editing.
LastActivityTime	Datetime	False	Timestamp of the last activity related to this solution.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
DuplicateCheckFields	String	The fields 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.
CustomViewId	Long	The custom view Id to be used for filtering this record. Works when the useCOQL parameter is false.

SSIS Components for Zoho CRM