Skip to main content
Deskpro Support
Eesti keel
Bahasa Indonesia
Bălgarski
Čeština
Cymraeg
Cрпски
Dansk
Deutsch
English
English (UK)
Español
Français
Gaelic
Hrvatski
Íslenska
Italiano
Latviešu valoda
Lietuvių kalba
Magyar
Malti
Nederlands
Norsk
Polski
Português (Brasil)
Português (Europeu)
Pусский
Română
Slovenčina
Slovenian
Suomen Kieli
Svenska
Tiếng Việt
Türkçe
Ελληνικά
македонски
الإنجليزية
فارسی
日本語
英语(美国)
영어
Võtke meiega ühendust
Log in
Kas Deskpro Support on teile uus?
Registreeru konto loomiseks
Kas soovite jääda sisselogituks?
Kas soovite salasõna meeldetuletust?
Help Center
Juhised
Reports Guide
DPQL Field Reference Tables
DPQL Field Reference
Products
WARNING You're browsing the documentation for an old version of Deskpro. Consider updating to
Deskpro Horizon
.
Legacy - Sysadmin Guide
Legacy - Admin Guide
Legacy - Agent Guide
Developers
Reports Guide
On-Premise Controller
Agent Guide
Admin Guide
Reports Guide
Admin Guide
Agent Guide
On-Premise Controller
Reports Guide
Developers
Legacy - Agent Guide
Legacy - Admin Guide
Legacy - Sysadmin Guide
View all Guides
Reports Overview
Accessing Reports
Built-In Overview
Using Reports
Using the Stat Builder
Billing Reports
Agent Activity
Agent Hours
Ticket Satisfaction
DPQL Reference
Making a Report
Anatomy of a DPQL query
SELECT
FROM
WHERE
SPLIT BY
ORDER BY
LIMIT / OFFSET
LAYER WITH
IN
UNION
General Expression Format
Aliasing Expressions with AS
Archived Status
Date and Time Operations
Absolute Dates and Times
Relative Dates with Placeholders
Dates from Custom Fields
Finding an Interval between Two Date/Times
List of Date Placeholders
List of Functions
DPQL_COUNT
DPQL_COUNT_DISTINCT
DPQL_MATRIX
DATE_FORMAT
DPQL_ALIAS
SUM
AVG
DPQL_PERCENT
IN
Using the LIKE Operator and Wildcards
REPLACE
Accessing Custom Fields
Pull-Down Menus
Date Ranges
Ticket Statuses
Field Groups
Ordering
Cross-referencing Table Fields
Example Reports
Querying Custom Fields
Chat Widget Feedback
Exclude Tickets Created by Agents
Exporting User Data
List Tickets Created on the Weekend
Links to all Tickets each Agent resolved Last Month
Reports on Billing and Time Log Changes
Reports using Ticket Logs
Count times Tickets were Moved into a Department
Snippet usage by Agent
Ticket Backlog with a Custom Timeframe
Ticket Messages per Agent excluding Notes
DPQL Field Reference Tables
DPQL Field Reference
Agent Team
Articles
Blobs
Chat Conversations
Community
Custom Data
Departments
Downloads
Download Subscriptions
Emails
Feedback
Labels
Language
News
Organizations
People
Plugins
Products
Session
SLAs
Tasks
Tables
Tickets
Usersource
Voice
Products
in DPQL Field Reference
Authors list
Avaldatud:
16. märts 2017
|
Last updated:
16. märts 2017
Product (table: products)
Copy link to Product (table: products) to clipboard
Field Name
Data Type
depth
number
display_order
number
id
number
parent_id
number
root
number
title
string
children
Product
parent
Product
Sain abi
Ei saanud abi
next page
Session
previous page
Plugins
Please log in or register to submit a comment.
Kas soovite jääda sisselogituks?
Log in
Page sections
Product (table: products)
Please log in or register to submit a comment.