* id isactive ipaddr apikey can_create_tickets can_exec_cron notes updated created

* id object_id type file_id name inline lang

* canned_id dept_id isenabled title response lang notes created updated

* id namespace key value updated

* id isactive type name body notes created updated

* id pid tpl_id sla_id schedule_id email_id autoresp_email_id manager_id flags name signature ispublic group_membership ticket_auto_response message_auto_response path updated created

* id staff_id namespace body extra created updated

* email_id noautoresp priority_id dept_id topic_id email name notes created updated

* id email_id type auth_bk auth_id active host port folder protocol encryption fetchfreq fetchmax postfetch archivefolder allow_spoofing num_errors last_error_msg last_error last_activity created updated

* id tpl_id code_name subject body notes created updated

* tpl_id isactive name lang notes created updated

* id name description

* faq_id category_id ispublished question answer keywords notes created updated

* category_id category_pid ispublic name description notes created updated

* faq_id topic_id

* id ft bk type size key signature name attrs created

* file_id chunk_id filedata

* id execorder isactive flags status match_all_rules stop_onmatch target email_id name notes created updated

* id filter_id sort type configuration updated

* id filter_id what how val isactive notes created updated

* id pid type flags title instructions name notes created updated

* id form_id object_id object_type sort extra created updated

* entry_id field_id value value_id

* id form_id flags type label name configuration sort hint created updated

* id role_id flags name notes created updated

* topic_id topic_pid ispublic noautoresp flags status_id priority_id dept_id staff_id team_id sla_id page_id sequence_id sort topic number_format notes created updated

* id topic_id form_id sort extra

* id name name_plural sort_mode masks type configuration notes created updated

* id list_id status value extra sort properties

* lock_id staff_id expire code created

* id pid staff_id ext_id body status sort created updated

* id name manager status domain extra created updated

* org_id name address phone website notes

* id name install_path isphar isactive version notes installed

* id plugin_id flags name notes created updated

* id parent_id columns_id sort_id flags staff_id sort title config filter root path created updated

* id flags name primary secondary filter truncate annotations conditions extra

* queue_id column_id staff_id bits sort heading width

* queue_id staff_id setting updated

* id queue_id path heading sort

* id root name columns updated

* queue_id sort_id bits sort

* id flags name permissions notes created updated

* id flags name timezone description created updated

* id schedule_id flags sort name repeats starts_on starts_at ends_on ends_at stops_on day week month created updated

* id name flags next increment padding updated

* session_id session_data session_expire session_updated user_id user_ip user_agent

* id schedule_id flags grace_period name notes created updated

* staff_id dept_id role_id username firstname lastname passwd backend email phone phone_ext mobile signature lang timezone locale notes isactive isadmin isvisible onvacation assigned_only show_assigned_tickets change_passwd max_page_size auto_refresh_rate default_signature_type default_paper_size extra permissions created lastlogin passwdreset updated

* staff_id dept_id role_id flags

* log_id log_type title log logger ip_address created updated

* id object_id object_type number dept_id staff_id team_id lock_id flags duedate closed created updated

* task_id title

* team_id lead_id flags name notes created updated

* team_id staff_id flags

* id object_id object_type extra lastresponse lastmessage created

* id flags thread_id user_id role created updated

* id pid thread_id staff_id user_id type flags poster editor editor_type source title body format ip_address extra recipients created updated

* id thread_entry_id email_id mid headers

* id thread_entry_id data

* id thread_id thread_type event_id staff_id team_id dept_id topic_id data username uid uid_type annulled timestamp

* id thread_id object_id object_type created

* ticket_id ticket_pid number user_id user_email_id status_id dept_id sla_id topic_id staff_id team_id email_id lock_id flags sort ip_address source source_extra isoverdue isanswered duedate est_duedate reopened closed lastupdate created updated

* priority_id priority priority_desc priority_color priority_urgency ispublic

* id name state mode flags sort properties created updated

* ticket_id subject priority

* id object_hash type flags revision agent_id lang text source_text updated

* id org_id default_email_id status name created updated

* id user_id status timezone lang username passwd backend extra registered

* id user_id flags address

* user_id email name phone notes

* object_type object_id title content

select table ost_api_key ost_attachment ost_canned_response ost_config ost_content ost_department ost_draft ost_email ost_email_account ost_email_template ost_email_template_group ost_event ost_faq ost_faq_category ost_faq_topic ost_file ost_file_chunk ost_filter ost_filter_action ost_filter_rule ost_form ost_form_entry ost_form_entry_values ost_form_field ost_group ost_help_topic ost_help_topic_form ost_list ost_list_items ost_lock ost_note ost_organization ost_organization__cdata ost_plugin ost_plugin_instance ost_queue ost_queue_column ost_queue_columns ost_queue_config ost_queue_export ost_queue_sort ost_queue_sorts ost_role ost_schedule ost_schedule_entry ost_sequence ost_session ost_sla ost_staff ost_staff_dept_access ost_syslog ost_task ost_task__cdata ost_team ost_team_member ost_thread ost_thread_collaborator ost_thread_entry ost_thread_entry_email ost_thread_entry_merge ost_thread_event ost_thread_referral ost_ticket ost_ticket_priority ost_ticket_status ost_ticket__cdata ost_translation ost_user ost_user_account ost_user_email ost_user__cdata ost__search . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table ost_api_key ost_attachment ost_canned_response ost_config ost_content ost_department ost_draft ost_email ost_email_account ost_email_template ost_email_template_group ost_event ost_faq ost_faq_category ost_faq_topic ost_file ost_file_chunk ost_filter ost_filter_action ost_filter_rule ost_form ost_form_entry ost_form_entry_values ost_form_field ost_group ost_help_topic ost_help_topic_form ost_list ost_list_items ost_lock ost_note ost_organization ost_organization__cdata ost_plugin ost_plugin_instance ost_queue ost_queue_column ost_queue_columns ost_queue_config ost_queue_export ost_queue_sort ost_queue_sorts ost_role ost_schedule ost_schedule_entry ost_sequence ost_session ost_sla ost_staff ost_staff_dept_access ost_syslog ost_task ost_task__cdata ost_team ost_team_member ost_thread ost_thread_collaborator ost_thread_entry ost_thread_entry_email ost_thread_entry_merge ost_thread_event ost_thread_referral ost_ticket ost_ticket_priority ost_ticket_status ost_ticket__cdata ost_translation ost_user ost_user_account ost_user_email ost_user__cdata ost__search .	select column