How to give a sequence number while generating report or Jql

Question

Please can you help me how to add a custom field while doing JQL and the custom field should be having a counter or sequence number or serial number from 1st row to last row..

If i have 20 rows as output, the first record should be with #1 and last record should have @20.

Pls help.

Hannes Obweger - JXL for Jira · Answer

Just to expand on my last point, this is how this would look in the app that my team and I are working on, JXL for Jira:

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Plus, you can optionally show a row number, as shown above. This just works - so there's no scripting or automation whatsoever required.

Every JXL sheet is powered by either a saved filter or a JQL statement, so you can easily use it as a "supercharged" alternative to the built-in filter views.

Any questions just let me know.

Hannes Obweger - JXL for Jira · Answer

Hi @praveen koduru

if I understand you correctly you essentially want a row number in your JQL search result - is this correct?

I don't think that a custom field would help here, as a custom field would always have a particular value for each issue (like "1", "7", or "42") - so even if it would have the correct value for a very specific JQL search result, it would be the wrong value for another JQL search result.

I can't really think of a native solution here. I don't know if the problem justifies additional tooling for you, but if it does, you'll find options in the Atlassian Marketplace. I'll provide a concrete example below.

Hope this helps,

Best,

Hannes