Ticket becoming due email reminder

[philipf]

Hello,

I thought his was a simple one but having issues.

I used the template to send an alert when near due. But getting issues when I update the JQL to send an email for things only in progress. 

Do I need quotation marks. Is there more wrong. 

Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 621e23f8c4d0fe0069523ac5) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 5a7c73eb857e333eafe76caf) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 5e83879fcaa47a0c19905f5e) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 5e84d0610716a60c1baa1945) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 5e7907960c8c030c3988caa3) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 62d9e56b5eceb19617cc633a) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 557058:23d402de-e9b0-429d-a606-a004f1b25f64) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 615b1b202f6aed006896cf74) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 557058:989a2bb9-f272-474d-98c0-478cab0a2cae) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46), Custom Smart Value JQL Search: "(duedate <= endOfDay(1) AND statusCategory = in progress AND assignee = 5e835da6467ac20c1d7d8bca) AND (project in (10122))" - Error in JQL Query: Expecting either a value, list or function but got 'in'. You must surround 'in' in quotation marks to use it as a value. (line 1, character 46)

[Trudy Claspill · Accepted solution]

Hello @philipf 

You need quotes around in progress

statuscategory="in progress"

[philipf]

thanks