Why can I not use the Created field in the List View in JIRA discovery project

[Samantha Barnes]

I am trying to filter a view in jira product discovery by the created date but that field does not show up as an option to filter by.

[Bill Sheboy · Accepted solution]

Hi @Samantha Barnes 

That field appears not to be supported yet for filters, grouping, or calculations.  When I tried to copy the value using a custom-formula field, I got this error message:

Field "Created" is not supported yet

A couple of workarounds would be:

1. to sort by the field (as you have done in that image) or
2. to use an automation rule to copy to a custom field, and then filter on that custom field instead.

The second approach would count as a rule usage for every Idea created, so please check with your Jira Site Admin to determine the impact upon usage limits.

Kind regards,
Bill

[Samantha Barnes]

Thanks for the response @Bill Sheboy ! I actually tried #2 but the automation isn't working.

This is the rule I set up.

And in the Audit log it says it is successful and in the History on the object it says it does it but it doesn't actually show up in the field.

I think it might have something to do with the type of date field is is tough because when I go and manually set the Created Date field this is what the history looks like

Any thoughts on what I might be doing wrong?

[Bill Sheboy]

The JPD team created a new date format to span a range of date values.  To copy the created field value to your custom field, you will need to use advanced edit with JSON:

• identify the custom field id for your Created Date field, using this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/
• remove the Created Date selection from the dropdown list in the Edit Issue action
• select "More options" at the bottom of the action
• enter this in the "Additional Fields" section, using your custom field id

{
  "fields": {
    "customfield_12345":"{\"start\":\"{{issue.created.jiraDate}}\",\"end\":\"{{issue.created.jiraDate}}\"}"
  }
}

• select Next to save your changes
• test the results

If you have older Ideas you want to update for the Created Date field:

• got just a few of them...
  • set the field manually
• got a lot of them
  • copy this rule to a new one, changing to a scheduled trigger with JQL, testing if the Created Date field is empty, and then setting it.  Run the rule until all caught up, and then disable the rule.

[Samantha Barnes]

That worked! Thanks so much @Bill Sheboy 

[Hannes Obweger - JXL for Jira]

Hi @Samantha Barnes

I don't know if this justifies additional tooling for you, but just to put it out there: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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 long list of advanced features - including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - and works across any number of projects.

Plus, it supports all issue fields, including the created field.

This is how it looks in action:

This just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes