Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

~ , !~ , WAS, WAS IN, WAS NOT, WAS NOT IN, CHANGED

Syntax

Code Block
CSAT Score

Field Type

CSAT Score

Auto-complete

No

Supported operators

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

Unsupported operators

Supported functions

None

Examples

  • Find issues that has rating greater than 3:
    "CSAT Score[Number]" > 3

Example:

...

CSAT Recipient

Search for issues that has CSAT Recipient.

Syntax

Code Block
CSAT Recipient

Field Type

CSAT Recipient

Auto-complete

No

Supported operators

=, !=
IS, IS NOT, IN, NOT IN

Supported functions

None

Examples

  • Find issues that has rating greater than 3recipient is user account:
    "CSAT Score" > 3

...

  • Recipient[User Picker (single user)]" = 557058:ca99106c-551a-42f7-8c85-7649a9a79657

Example:

...

CSAT Trigger Date

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

Use one of the following formats:

"yyyy/MM/dd"

"yyyy-MM-dd"

"yyyy/MM/dd hh:mm"

"yyyy-MM-dd hh:mm"

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

Syntax

Code Block
"CSAT RatingTrigger Date"

Field Type

DATE TIME

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 Trigger Date[Time stamp]" < "2010/12/31"

  • Find all issues rating on or before 31st December 2010:
    "CSAT Trigger Date[Time stamp]" <= "2011/01/01"

  • Find all issues rated yesterday:
    "CSAT Trigger Date[Time stamp]" = "-1d"

  • Find all issues rated in January 2011:
    "CSAT Trigger Date[Time stamp]" >= "2011/01/01" and due <= "2011/01/31"

  • Find all issues rated on 15 January 2011:
    "CSAT Trigger Date[Time stamp]" = "2011/01/15"

  • Find all issues rated today:
    "CSAT Trigger Date[Time stamp]" > startOfDay()

  • Find all issues rated last week > startOfWeek(-1)

Example:

...

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 time.

Use one of the following formats:

"yyyy/MM/dd"

"yyyy-MM-dd"

"yyyy/MM/dd hh:mm"

"yyyy-MM-dd hh:mm"

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

Syntax

Code Block
"CSAT Rating Date"

Field Type

DATE TIME

Auto-complete

No

Supported operators

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

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[Time stamp]" < "2010/12/31"

  • Find all issues rating on or before 31st December 2010:
    "CSAT Rating Date[Time stamp]" <= "2011/01/01"

  • Find all issues rated yesterday:
    "CSAT Rating Date[Time stamp]" = "-1d"

  • Find all issues rated in January 2011:
    "CSAT Rating Date[Time stamp]" >= "2011/01/01" and due <= "2011/01/31"

  • Find all issues rated on 15 January 2011:
    "CSAT Rating Date[Time stamp]" = "2011/01/15"

  • Find all issues rated today:
    "CSAT Rating Date[Time stamp]" > startOfDay()

  • Finda Find all issues rated last week > startOfWeek(-1)

Example:

...

CSAT Rating Comment

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

...