exclude issues with the same start and end dates using jql

[전종우]

I would like to ask if there is any way to exclude issues with the same start and end dates using jql. If there is a way, I would appreciate it if you could tell me.
I uesd ""Start date" != "End date"", but returnd error..

[Fazila Ashraf · Accepted solution]

@전종우  , It is not possible to compare 2 fields in JIRA by default.

Do you have scriptrunner? If yes, you can look at https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_datecompare

[전종우]

If I use scriptrunner, is it possible to create a JQL that can compare two fields (start date, end date)?

[전종우]

If you can do it using dateCompare, I would also appreciate the actual query. ㅠㅠ

[Fazila Ashraf]

issueFunction in dateCompare("project = SRCLOUD", "customfield_10080!= customfield_10081")

Replace the customfield ids with your instance cf ids.