Ordering Jira connector by rank
We want to be able to display in smartsheets our backlog by rank. Meaning we want it displayed in the order the product owner has arranged it in. We also need to use JQL to get the detail we need. Here is the query that works as expected in Jira:
project = HU AND issuetype = Story AND resolution = Unresolved AND (Sprint = EMPTY OR Sprint not in (openSprints(), futureSprints())) ORDER BY rank
Note the attached screenshot. See how the connector prepends the query with:
project = 'HU' and (
then it appends it with:
) order by id
Is this typical behaviour? How can I get the the connector to respect the "order by rank" in the query?