id

text

[en] The ID of the board

self

text

[en] The URL of the board

location__displayname

text

location__name

text

location__projectid

text

    Projects > > id

location__projecttypekey

text

location__projectname

text

location__projectkey

text

type

text

[en] The type the board

name

text

[en] The name of the board

name

text

[en] Name of the board

board_id

text

[en] ID of the board

    Boards > > id

board_id

text

[en] ID of the board (Kondado: inherited from top-level table)

column_name

text

[en] Name of the board (Kondado: inherited from top-level table)

statuses__self

text

[en] URL of the status

statuses__id

text

[en] ID of the status

    Status > > id

issue_id

text

[en] The ID of the issue

    Issues > > id

board_id

text

[en] The ID of the board that contains the issues

    Boards > > id

issue_key

text

[en] The key of the issue

board_id

text

[en] The ID of the board that contains the requested sprints

    Boards > > id

originboardid

text

[en] The ID of the board that contains the requested sprints (returned when board_id is missing)

startdate

timestamp

[en] The start date of the sprint

state

text

[en] The state of the sprint (ie: active, closed, etc)

enddate

timestamp

[en] The end date of the sprint

name

text

[en] The name of the sprint

goal

text

[en] The goal of the sprint

self

text

[en] The URL of the sprint

id

text

[en] The ID of the sprint

completedate

timestamp

[en] The date the sprint was completed

id

text

[en] The ID of the changelog

created

text

[en] The date on which the change took place - formated as a text with timezone

idissue

text

[en] The ID of the issue

    Issues > > id

author__active

boolean

[en] Whether the author (The user who made the change) is active

author__displayname

text

[en] The display name of the author (The user who made the change). Depending on the user's privacy settings, this may return an alternative value

author__emailaddress

text

[en] The email address of the author (The user who made the change). Depending on the user's privacy settings, this may be returned as null

author__name

text

changelog_id

text

[en] The ID of the changelog (kondado: inherited from main table)

items__from

text

[en] The details of the original value

items__to

text

[en] The details of the new value

items__fromstring

text

[en] The details of the original value as a string

items__tostring

text

[en] The details of the new value as a string

items__field

text

[en] The name of the field changed

items__fieldtype

text

[en] The type of the field changed

items__fieldid

text

[en] The ID of the field changed

issueid

float

[en] The ID of the issue this worklog is for

    Issues > > id

id

float

[en] The ID of the worklog record

comment

text

[en] A comment about the worklog in Atlassian Document Format

updateauthor__displayname

text

[en] The display name of the user who last updated the worklog. Depending on the user's privacy settings, this may return an alternative value

updateauthor__name

text

updateauthor__accounttype

text

[en] The type of account represented by this user who last updated the worklog. This will be one of 'atlassian' (normal users), 'app' (application user) or 'customer' (Jira Service Desk customer user)

updateauthor__key

text

updateauthor__active

boolean

[en] Whether the user who last updated the worklog is active

updateauthor__timezone

text

[en] The time zone specified in the user who last updated the worklog's profile. Depending on the user's privacy settings, this may be returned as null

updateauthor__accountid

text

[en] The account ID of the user who last updated the worklog, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5

timespent

text

[en] The time spent working on the issue as days (#d), hours (#h), or minutes (#m or #

author__displayname

text

[en] The display name of the user who created the worklog. Depending on the user's privacy settings, this may return an alternative value

author__name

text

author__accounttype

text

[en] The type of account represented by this user who created the worklog. This will be one of 'atlassian' (normal users), 'app' (application user) or 'customer' (Jira Service Desk customer user)

author__key

text

author__active

boolean

[en] Whether the user who created the worklog is active

author__timezone

text

[en] The time zone specified in the user who created the worklog's profile. Depending on the user's privacy settings, this may be returned as null

author__accountid

text

[en] The account ID of the user who created the worklog, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5

started

timestamp

[en] The datetime on which the worklog effort was started

created

timestamp

[en] The datetime on which the worklog was created

timespentseconds

float

[en] The time in seconds spent working on the issue

updated

timestamp

[en] The datetime on which the worklog was last updated

id

int

[en] The ID of the issue

key

text

[en] The key of the issue

fields__duedate

date

[en] The date by which this issue is scheduled to be completed

fields__labels

text

[en] Labels to which this issue relates

fields__progress__progress

float

fields__progress__total

float

fields__statuscategorychangedate

timestamp

[en] Reflects changes to the statuscategory

fields__resolution__description

text

[en] A description of the issue's resolution, if the issue has been resolved or closed

fields__resolution__id

int

[en] ID of the issue's resolution, if the issue has been resolved or closed

fields__resolution__name

text

[en] Name of the issue's resolution, if the issue has been resolved or closed

fields__status__id

int

[en] The Id of the status the issue is currently at in its lifecycle (workflow)

    Status > > id

fields__status__statuscategory__id

int

fields__status__statuscategory__key

text

fields__status__statuscategory__name

text

fields__status__description

text

[en] The description of the status the issue is currently at in its lifecycle (workflow)

fields__status__name

text

[en] The name of the status the issue is currently at in its lifecycle (workflow)

fields__updated

timestamp

[en] The time and date on which this issue was last edited.

fields__description

text

[en] A detailed description of the issue.

fields__creator__displayname

text

fields__creator__name

text

fields__creator__emailaddress

text

fields__creator__key

text

fields__creator__active

boolean

fields__creator__accountid

text

fields__assignee__accountid

text

fields__assignee__displayname

text

fields__assignee__emailaddress

text

fields__lastviewed

timestamp

fields__summary

text

[en] A brief one-line summary of the issue

fields__reporter__displayname

text

fields__reporter__name

text

fields__reporter__emailaddress

text

fields__reporter__key

text

fields__reporter__active

boolean

fields__reporter__accountid

text

fields__aggregatetimespent

float

fields__votes__hasvoted

boolean

fields__votes__votes

int

[en] The number shown indicates how many votes this issue has

fields__aggregatetimeoriginalestimate

text

[en] The Original Estimate of the total amount of time required to resolve the issue, as estimated when the issue was created

fields__created

timestamp

[en] The time and date on which this issue was entered into Jira

fields__resolutiondate

timestamp

[en] A record of the issue's resolution, if the issue has been resolved or closed.

fields__timeestimate

float

[en] A record of the issue's resolution, if the issue has been resolved or closed.

fields__project__projecttypekey

text

fields__project__id

int

    Projects > > id

fields__project__key

text

fields__project__name

text

fields__timespent

float

fields__issuetype__subtask

boolean

fields__issuetype__id

int

fields__issuetype__name

text

fields__issuetype__description

text

fields__workratio

float

fields__priority__name

text

fields__priority__id

int

parent_issue_id

int

[en] The ID of the parent issue

parent_issue_key

text

[en] The key of parent the issue

issue_id

int

[en] The ID of the issue

    Issues > > id

issue_key

text

[en] The Key of the issue

custom_field_key

text

[en] The ID or key of the custom field, for example customfield_10000

custom_field_value

text

[en] The value for the custom field (coerced to text by Kondado)

id

text

[en] The ID of the internal issue link

source_issue_id

text

[en] The ID of the source issue that contains this link

    Issues > > id

type_id

text

[en] The ID of the link type

type_name

text

[en] The name of the link type (e.g., Blocks, Relates to, Duplicates)

type_inward

text

[en] The inward description of the link type

type_outward

text

[en] The outward description of the link type

inwardissue_id

text

[en] The ID of the inward issue

    Issues > > id

inwardissue_key

text

[en] The key of the inward issue

outwardissue_id

text

[en] The ID of the outward issue

    Issues > > id

outwardissue_key

text

[en] The key of the outward issue

id

int

[en] The ID of the issue link

issue_id

text

[en] The ID of the source issue

    Issues > > id

application_type

text

[en] The type of the application that created the link

application_name

text

[en] The name of the application that created the link

object_url

text

[en] The URL of the linked object

object_title

text

[en] The title of the linked object

object_summary

text

[en] The summary of the linked object

object_icon_url16x16

text

[en] The 16x16 icon URL of the linked object

object_status_resolved

boolean

[en] Whether the linked object is resolved

object_status_icon_url16x16

text

[en] The 16x16 status icon URL of the linked object

id

int

[en] The key of the project

key

text

[en] The key of the project

description

text

[en] A brief description of the project

simplified

boolean

[en] Whether the project is simplified.

style

text

[en] The type of the project.

name

text

[en] The name of the project.

lead__displayname

text

[en] The display name of the project lead. Depending on the user's privacy setting, this may return an alternative value.

lead__active

boolean

[en] Whether the project lead is active.

lead__accountid

text

[en] The account ID of the project lead, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5.

projecttypekey

text

[en] The project type of the project.

isprivate

boolean

[en] Whether the project is private.

sprint_id

text

[en] The ID of the sprint

    Boards: sprints > > id

issue_id

text

[en] The ID of the issue

    Issues > > id

id

int

[en] The ID of the status

statuscategory__name

text

[en] The name of the status category

statuscategory__id

int

[en] The ID of the status category

statuscategory__key

text

[en] The key of the status category

description

text

[en] The description of the status

name

text

[en] The name of the status