Advanced searching - CSAT fields reference

Owned by Joseph Huynh
Nov 14, 2017


CSAT Rate

Search for issues that has CSAT Rating.

Syntax
CSAT Rate
Field TypeCSAT Rating
Auto-completeNo
Supported operators=, !=, > , >= , < , <=
IS, IS NOT, IN, NOT IN
Unsupported operators~ , !~ , WAS, WAS IN, WAS NOT, WAS NOT IN, CHANGED
Supported functionsNone
Examples

  • Find issues that has rating greater than 3:
    "CSAT Rate" > 3

CSAT Rating Date

Search for issues that were rated on, before, or after a particular date (or date range). Note that the rating date relates to the date only (not to the time).

Use one of the following formats:

"yyyy/MM/dd"
"yyyy-MM-dd"

Or use "w" (weeks) or "d" (days) to specify a date relative to the current date. Be sure to use quote-marks (").

Syntax
"CSAT Rating Date"
Field TypeDATE
Auto-complete

No

Supported operators

= , != , > , >= , < , <=
IS , IS NOT , IN , NOT IN

Unsupported operators~ , !~ 
WAS, WAS IN, WAS NOT, WAS NOT IN , CHANGED
Supported functions

When used with the EQUALS, NOT EQUALS, GREATER THAN, GREATER THAN EQUALS, 
LESS THAN or LESS THAN EQUALS operators, this field supports:

  • currentLogin()
  • lastLogin()
  • now()
  • startOfDay()
  • startOfWeek()
  • startOfMonth()
  • startOfYear()
  • endOfDay()
  • endOfWeek()
  • endOfMonth()
  • endOfYear()
Examples
  • Find all issues got rated before 31st December 2010:
    "CSAT Rating Date" < "2010/12/31"
  • Find all issues rating on or before 31st December 2010:
    "CSAT Rating Date" <= "2011/01/01"
  • Find all issues rated yesterday:
    "CSAT Rating Date" = "-1d"
  • Find all issues rated in January 2011:
    "CSAT Rating Date" >= "2011/01/01" and due <= "2011/01/31"
  • Find all issues rated on 15 January 2011:
    "CSAT Rating Date" = "2011/01/15"
  • Find all issues rated today:
    "CSAT Rating Date" > startOfDay()
  • Finda all issues rated last week > startOfWeek(-1)

CSAT Rating Comment

Search for issues where the customer satisfaction comments contains particular text. 

Syntax
CSAT Rating comment
Field TypeTEXT
Auto-complete

No

Supported operators

~ , !~ 
IS , IS NOT

Unsupported operators= , != , > , >= , < , <= 
IN , NOT IN , WAS, WAS IN, WAS NOT, WAS NOT IN , CHANGED
Supported functions

None

Examples
  • Find issues where there are CSAT comments
    "CSAT Rating Comment" is not EMPTY