JQL Query To Capture ID 3000 and Higher

Question

We are attempting to integrate Jira and Smartsheet using the Connector utility.  We only want IDs that are 3000 or greater.  Here is the query:

project = WCP AND "Workday Product[Dropdown]" = Finance AND key >= WCP-3000 order by Key ASC

I am receiving an error which states:  Please fix the following error either by editing the query in JIRA Filters section or by redefining the query in JIRA. The sort field 'id' is referenced multiple times in the JQL sort. Field 'id' is an alias for field 'Key'.

Any thoughts on how to fix this?

Diatta Harris · Answer

Thank you.  Unfortunately I need that dropdown because it filters out the other erroneous values in that field since apparently this board is shared with another team.  I am thinking this needs to be broken out because it is causing a bit of heartache.

Laurie Sciutti · Answer

@Diatta Harris ~ odd.  That works for me (without the field dropdown portion of the JQL).  Can you try removing that and see if you still get the error?  Did you try removing the sort order altogether?