Custom Fields

List of custom fields support in CSAT Cloud:

CSAT Score

The custom field is used to store the rating for a survey

CSAT Recipient

The custom field is used to store the recipient who sending feedback

CSAT Comment

The custom field is used to store the comment in a survey

CSAT Trigger Date

The custom field is used to store the date time of survey sent

CSAT Rating Date

The custom field is used to store the date time of user rated

Custom fields view:

 

CSAT Score

Search for issues that has CSAT Score.

Syntax

CSAT Score

Field Type

CSAT Score

Auto-complete

No

Supported operators

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

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

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

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.

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

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.

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

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: