Versions Compared

Key

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

...

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 recipient is user account:
    "CSAT Recipient[User Picker (single user)]" = 557058:ca99106c-551a-42f7-8c85-7649a9a79657

Example:

...

CSAT Rating Comment

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

Syntax

Code Block
CSAT Rating Comment

Field Type

CSAT Rating Comment

Auto-complete

No

Supported operators

~, !~
IS, IS NOT

Supported functions

None

Examples

  • Find issues that has comment:
    "CSAT Rating Comment[Paragraph]" ~ testing

Example:

...

CSAT Trigger Date

Search for issues that were survey sent, before, or after a particular date (or date range). Note that the trigger date relates to the date time.

...

Syntax

Code Block
"CSAT Trigger 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 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.

...

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()

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

Example:

...

CSAT Rating Comment

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

...

Syntax

...

Code Block
CSAT Rating comment

...

Field Type

...

TEXT

...

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