Zum Hauptinhalt springen
Deskpro Support
Deutsch
Bahasa Indonesia
Bălgarski
Čeština
Cymraeg
Cрпски
Dansk
Eesti keel
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
Ελληνικά
македонски
الإنجليزية
فارسی
日本語
英语(美国)
영어
Kontakt
Anmelden
Neu bei Deskpro Support?
Einen Account anlegen
Angemeldet bleiben?
Benötigen Sie eine Passwort-Erinnerung?
Hilfe-Center
das Handbuch
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
Alle Anleitungen anzeigen
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
Autorenliste
veröffentlicht:
16. März 2017
|
Letzte Aktualisierung:
16. März 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
Hilfreich
Nicht hilfreich
nächste Seite
Session
vorherige Seite
Plugins
Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.
Angemeldet bleiben?
Anmelden
Seitenabschnitte
Product (table: products)
Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.