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

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

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


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.

Excel Add-In for Zoho CRM