The following fields are available for use in SQL statements:
access
- accessid
- name
- show_issues_tab
- show_techsupport_tab
- show_clients_tab
- show_reports_tab
- show_admin_tab
- show_only_users_items
- show_messagecenter_tab
- show_knowledgebase_tab
- allow_editing
- new_user
reports
- reportid
- type
- reportname
- fields
- filters
- hiddenfields
- ordering
- sorting
- data
- sql
- dograph
- parameters
attachments
- attachmentid
- issueid
- filename
- filesize
- realfilename
- file
comments
- commentid
- issueid
- comment
- owner
- datestarted
- dateended
- totaltime
category
- categoryid
- name
- base
box
- boxid
- name
base
- baseid
- name
completion
- completionid
- amount
defaults
- defaultsid
- name
- table
- field
- default
displayfields
- displayname
- displayfields
issues
- issueid
- base
- originator
- assignedto
- software
- type
- priority
- estimatetime
- module
- category
- owner
- datereported
- datecompleted
- description
- solution
- completion
- status
- hasattachments
- clientid
- starttime
- endtime
- totaltime
- versionfoundin
- versionfixedin
- versionscheduledfor
clients
- clientid
- account_number
- clientname
- address
- suburb
- zipcode
- phone
- fax
- modem
- contact1
- contact2
- software
- registration_key
- type
- notes
- username
- password
- status
- salesperson
- managed_by
issuetype
- issuetypeid
- name
- base
members
- memberid
- software
- projectuser
messages
- messageid
- sent
- fromuser
- touser
- message
- relateditem
- subject
- box
users
- userid
- name
- username
- password
- access
- records_per_page
- newmessages
- preferences
- photo
milestones
- milestoneid
- software
- milestonename
- duedate
software
- softwareid
- name
- information
- currentversion
- currentmilestone
status
- statusid
- name
- base
- complete
versions
- versionid
- software
- versionname
priority
- priorityid
- name
Workflow
- workflowid
- statusfrom
- statusto