Solutions

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 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 of the solution.
SolutionNumber	String	False	Reference 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 of the solution.
Published	Bool	False	Indicates whether the solution is published.
Status	String	False	Current status of the solution.
ProductName_Id	String	False	Identifier of the related product.
ProductName_Name	String	True	Name of the related product.
No.ofcomments	Int	True	Number of comments added to the solution.
CreatedBy_Id	String	False	Identifier of the user who created the solution.
CreatedBy_FirstName	String	True	First name of the user who created the solution.
CreatedBy_LastName	String	True	Last name of the user who created the solution.
CreatedBy_Email	String	True	Email address of the user who created the solution.
CreatedBy_Name	String	True	Full name of the user who created the solution.
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 solution.
ModifiedBy_LastName	String	True	Last name of the user who last modified the solution.
ModifiedBy_Email	String	True	Email address of the user who last modified the solution.
ModifiedBy_Name	String	True	Full name of the user who last modified the solution.
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.
Question	String	False	Question or problem statement addressed by the solution.
Answer	String	False	Answer or resolution provided in the solution.
AddComment	String	False	New comment added to the solution.
Comments	String	True	List of comments associated with the solution.
RecordId	Long	True	Record identifier used internally.
Locked	Bool	True	Indicates whether the record is locked for editing.
LastActivityTime	Datetime	False	Date and time of the last activity related to the solution.

Pseudo-Columns

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


Name	Type	Description
DuplicateCheckFields	String	The fields to use when checking for duplicate records during upsert. The REST API supports multiple fields, but the BULK API supports only one.
Trigger	String	Used to trigger workflow rules during record insertion into the CRM.
CustomViewId	Long	Custom view identifier for filtering this record. Works only when the useCOQL parameter is false.

Tableau Connector for Zoho CRM