Query for issues in a Structure that are descendants of a folder that is manually reordered

[Ariel Malamud]

I query a structure for issues in a specific folder using the following query:

issue in structure("My Structure", "descendant of folder(MyFolder)")

The folder in the original Structure "My Structure" uses the Manual Reordering sort generator and contains issues under that folder that indeed have been reordered by the user.

Problem: My query above returns the MyFolder issues in their original order and not in their current order. I need to see an exact reflection of the folder contents sorted exactly like the containing folder.

One workaround is to create a 2nd structure that Inserts the first one and filters on folder(MyFolder), but this is very time-intensive and hits performance significantly.

Any way to do this directly with the "issue in structure()" query?

Thanks

Ariel

[Vlad Lessage]

Hi Ariel, 

Thanks for posting.

Inserting the structure into another is the best way to proceed for your use case. We would like to look into the performance to see if there's a way we could improve that in the future.

Would you be able to send us a Performance Audit Log at support@almworks.com by any chance?

To collect it, please go to Administration|Structure|Support. In the Performance Audit Log section click the View Performance Audit Log link. A list of all Generators and Synchronizers per structure will be displayed. Please scroll down to the bottom of the page and click the *Save to File* button.

Please note, that for the Data Center edition of Jira, the Performance Audit log would need to be collected from each node separately.

Since the file contains sensitive data such as structure names and saved filters, we advise you to review the info before sending and remove sensitive data, if any.

I look forward to hearing back from you.

Best Regards,

Vlad

ALM Works

[Ariel Malamud]

Hi Vladimir,

Thanks for you reply. Unfortunately this is a Data Center edition managed by our IT dept. so that as a user I don't have the privileges to run the audit log and don't have much leverage with the IT dept. I will nevertheless try to open a ticket on them. I could also open a ticket with ALM works and perhaps they can be in contact with our IT.  

In the meantime, referring back to my original trial of using S-JQL: issue in structure("My Structure", "descendant of folder(MyFolder)")

Is there any meta-data or attribute that Manual Ordering sets in the original structure that could use in the resulting structure to maintain the same order?

Thanks again

Ariel