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.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.