How to sort by "Customer Requested Due Date"

[Noam Guttman]

Hi,

I'm looking to write a short JQL query which will sort the JIRA tickets according to their "Customer Requested Due Date".

Currently it's sorted by the updated date: "project = PLATNEWPG AND issuetype = "New Feature" AND Labels = AX and status = new order by updateddate"

Best,

 -Noam

[Stephen Crandell · Accepted solution]

@Noam Guttman is this for Jira Service Desk? Is the customer requested due date a custom field you created? 

You may want to try using the due date field. 

[Noam Guttman]

@mrcrandell.sw  It's for a confluence table with a JQL query for filtering JIRA tickets.

It is a customized field.

[Stephen Crandell]

you Should be able to reference it just the same as you do in Jira. I would try the following in Jira and if it looks correct, then save it as a filter and reference that filter in the Confluence macro or copy/paste the actual filter query into the macro. 

project=PLANTEWPG and issuetype=“New Feature” and labels=AX and status=new ORDER BY “Customer Requested Due Date”

[Noam Guttman]

@mrcrandell.sw 

It works, thanks!

[Stephen Crandell]

@Noam Guttman @No problem. Glad I could help. If it worked please accept the answer