IssueComments

Fetch comments for the issue.

Select

IssueId is required to retrieve Issue Comments.

Columns that support server-side ORDER BY: Id, Comment, CreatedTime, LastModifiedTime

For example, the following query is processed server side:

SELECT * FROM IssueComments WHERE IssueId = '123456000000045005'

Insert

To add a Issue Comment specify the IssueId and Comment fields.

INSERT INTO IssueComments (IssueId, Comment) VALUES ('123456000000045005', 'Test Comment #1')

Delete

Issue Comments can be deleted by providing the Id and issuing a DELETE statement.

DELETE FROM IssueComments WHERE IssueId = '123456000000045005' AND Id = '123456000000045042'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Long	False	Issue Comment Id.
IssueId [KEY]	Long	False	Issue Id.
Comment	String	False	Issue Comment Content.
AddedById	Long	True	Issue Comment Added By Id.
AddedByBusinessHoursId	Long	True	Issue Comment Added By Business Hours Id.
AddedByFirstName	String	True	Issue Comment Added By First Name.
AddedByLastName	String	True	Issue Comment Added By Last Name.
AddedByName	String	True	Issue Comment Added By Name.
AddedByFullName	String	True	Issue Comment Added By Full Name.
AddedByEmail	String	True	Issue Comment Added By Email.
AddedByZpuid	Long	True	Issue Comment Added By Zpuid.
AddedByIsClientUser	Boolean	True	Issue Comment Added By Is Client User.
AddedVia	String	True	Issue Comment Added Via.
CreatedTime	Datetime	True	Issue Comment Created Time.
CanDeleteComment	Boolean	True	Can Delete Comment.
CanEditComment	Boolean	True	Can Edit Comment.
LastModifiedById	Long	True	Issue Comment Last Modified By Id.
LastModifiedByBusinessHoursId	Long	True	Issue Comment Last Modified By Business Hours Id.
LastModifiedByFirstName	String	True	Issue Comment Last Modified By First Name.
LastModifiedByLastName	String	True	Issue Comment Last Modified By Last Name.
LastModifiedByName	String	True	Issue Comment Last Modified By Name.
LastModifiedByFullName	String	True	Issue Comment Last Modified By Full Name.
LastModifiedByEmail	String	True	Issue Comment Last Modified By Email.
LastModifiedByZpuid	Long	True	Issue Comment Last Modified By Zpuid.
LastModifiedByIsClientUser	Boolean	True	Issue Comment Last Modified By Is Client User.
LastModifiedTime	Datetime	True	Issue Comment Last Modified Time.

Pseudocolumns

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