Here is a list of queries you can generate for each of the different types of content in the helpdesk. These can also help you to understand queries are constructed.
Ticket
Title | Description | FQL |
|---|---|---|
Resolved | Returns all resolved tickets | ticket.status IN ('resolved') |
Archived | Returns all archived tickets | ticket.status IN ('archived') |
Recycle Bin | Returns all tickets in the recycle bin | ticket.status IN ('hidden.1') |
Spam | Returns all tickets that have been marked as Spam | ticket.status IN ('hidden.2') |
User
Title | Description | FQL |
|---|---|---|
All agents | Returns all people in the CRM who are agents | person.is_agent = 1 |
All agents with name John | Returns all people in the CRM who are both agents AND their name is John | person.is_agent = 1 AND person.name = 'John' |
All agents with name Steve | Returns all people in the CRM who are both agents AND their name is Steve | person.is_agent = 1 AND person.name = 'Steve' |
Organization
Title | Description | FQL |
|---|---|---|
All Organizations with Inc in their name | Returns all Orgs where their name CONTAINS the string 'Inc' | organization.name = 'Inc' |
All Organizations with Ltd in their name | Returns all Orgs where their name CONTAINS the string 'Ltd' | organization.name = 'Ltd' |
Publish
Articles
Title | Description | FQL |
|---|---|---|
All articles where title contains 'Example' | Returns all articles where the article title CONTAINS the string 'example' | article.title = 'Example' |
All articles published last day by Los Angeles timezone | Returns all articles that were published within the last day based on the Los Angeles timezone | article.date_published < DATE("+1 day", "America/Los_Angeles") |
All articles published last month | Returns all articles that were published in the last month | article.date_published < DATE("+1 month") |
All articles published last three months | Returns all articles that were published in the last three months | article.date_published < DATE("+3 month")' |
News
Title | Description | FQL |
|---|---|---|
All news posts where title contains 'Example' | Returns all news posts where the title CONTAINS the string 'example' | news.title = 'Example' |
All news posts published last day by UTC timezone | Returns all news posts that were published within the last day based on the UTC timezone | news.date_published < DATE("+1 day", "UTC") |
All news posts published last month by UTC timezone | Returns all news posts that were published in the last month based on the UTC timezone | news.date_published < DATE("+1 month", "UTC") |
All news posts published in the last three months by UTC timezone | Returns all news posts that were published in the last three months based on the UTC timezone | news.date_published < DATE("+3 month", "UTC") |
Files
Title | Description | FQL |
|---|---|---|
All files with title containing 'Example' | Returns all files where the title CONTAINS the string 'example' | download.title = 'Example' |
All files uploaded today | Returns all files that were uploaded today | download.date_created = DATE("today") |
All files uploaded yesterday | Returns all files that were uploaded yesterday | download.date_created = DATE("yesterday") |
Community
Title | Description | FQL |
|---|---|---|
All community topics with title containing 'Example' | Returns all community topics where the title CONTAINS the string 'example' | community_topic.title = 'Example' |
All community topics published today | Returns all community topics that were uploaded today | community_topic.date_published = DATE("today") |
All community topics published yesterday | Returns all community topics that were uploaded yesterday | community_topic.date_published = DATE("yesterday") |
Please log in or register to submit a comment.