sorting custom date fields

[Mazin Alton]

HI I am using NextGen tickets i have added a datetime field, but it seems like that i cannot sort by the field in the filter view.

i have tried both advanced or basic filter sorting, no matter what i do it does not sort by date.

my custom field is set to be used to display production dates, but i cannot sort to see all the newest dates at first.

it works if i sort by due date, but not this custom field.

the field is not text field it is a datetime field.

[Brant Schroeder]

@Mazin Alton 

Does your custom field have a search template associated with it?

[Mazin Alton]

not sure where you can set that?

[Mazin Alton]

here is code 

issuetype = "Project Info" ORDER BY cf[10092] ASC

and image of the date field

[Brant Schroeder]

@Mazin Alton In order to look at the custom fields settings you will need to go to the Jira settings in the upper right hand corner (it is a cog / gear) and click it.  In the drop down select issues.  Then from the left hand side select custom fields.  Search for your custom field.  When you see it in the list on the right hand side there will be three dots, click the dots and select edit details.  On this page you will see the search template, what is it set to?

[Mazin Alton]

okay, i am making an assumption that because this is a next-gen project i cannot find the custom field in the area you mentioned above. 

[Mazin Alton]

i can see all other non net-gen fields but not this particular one.

[Brant Schroeder]

@Mazin Alton 

I am not able to recreate the issue on my instance. Does it give you any type of error when you run the filter search?

[Mazin Alton]

no errors, it just does not filter shows a few in order and the rest not in order let me show you a screenshot.

[Brant Schroeder]

The screenshot looks like it is allowing sorting but the sorting just is not happening.  How long has the custom field been in place?  Also when is the last time you cleared your browser cache?

[Mazin Alton]

i noticed this too... looks like for the same custom field there is a different ID... now this would make sense but why is it like that? 

[Mazin Alton]

i tried this issuetype = "Project Info" ORDER BY "LIVE DATE" DESC

no go still

[Brant Schroeder]

Mazin,

  Looks like you have tons of live date fields. Can you just run your query without the order by and then sort on row?  Does that work?  Also when did you create the field?

[Mazin Alton]

still doesnt work... a few weeks ago field was created... and i dont think there is a way to use same field id across other projects

[Brant Schroeder]

Can you search by project and only have that as the search criteria then do the order by clicking on the column heading, does that work?

[Mazin Alton]

i bet that would work let me try.

[Mazin Alton]

nope no go.. i have two results, and when i click on the column to sort the date does not move

project = "2021 General Tours" AND issuetype = "Project Info" ORDER BY cf[10092] DESC

[Brant Schroeder]

I am at a loss and not being able to see your instance does not help.  Atlassian support will be able to see everything and I would suggest submitting a support ticket with them.  https://support.atlassian.com/contact/

[Mazin Alton]

that makes both of us, yesi created a ticket waiting for their reply.