How to give a sequence number while generating report or Jql

praveen koduru
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 27, 2024

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.

1 answer

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 27, 2024

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

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 27, 2024

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:

row-number.gif

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events