Sorting the topics by colums day in the columns in the project

[Gökay Kazdal]

Hello,

My problem,
sorting the topics that last longer than 1 day among the topics in the project columns according to the column day.

My JQL;

created < startOfDay(-1) ORDER BY (.......) ??

Could jql be faulty?

[Bill Sheboy · Accepted solution]

Hi @Gökay Kazdal -- Welcome to the Atlassian Community!

The days in column values appear to be computed dynamically for the boards, and so are not a sortable field for JQL.

As possible work-arounds, you could investigate the Atlassian Marketplace to learn if there are JQL addons to do this...or you could add a custom field and scripting/automation rule to calculate the value and then use JQL to sort on it.

Kind regards,
Bill

[Gökay Kazdal]

Thank u.