How do I change a date field to BOLD RED when date is older than 12 months?

Mo Daniels, Ph.D.

I am in an industry requiring lots of date compliance/certifications.  How do I change a date field, when viewing an issue, to BOLD RED when the date is older than 12 months?

I am very new to JIRA, but I did build my entire system in 100 hours (1 week)... lol.  What I mean to say is, please assume I am starting with no knowledge, but I can get technical very quickly and easily.

Thank you so much!

Mo

I have not heard from anyone in the community on this.  ANYTHING?

Joe Pitt

You can't out of the box. Being in the cloud you have a limited selection of plugins, but one of them may do that. As you're new, here are some tips to avoid issues that many new JIRA users have. 

First, by default JIRA has a horrible permission scheme that violates security best practices by allowing everyone that can logon to do just about everything.

 

JIRA works by GRANTING access. You can't restrict access. By default, it grants access to the group used to logon (see Global permissions to see the "can use" groups and admin groups).  This is where users are getting their access.

 

1. The FIRST thing you need to do to get control is to remove any groups with logon privileges from the permission scheme unless you absolutely want everyone to have that permission.
2. Then I suggest you setup Project Roles for the various functions like, tester, QA, Browse Only, etc.
3. By using project roles, one permission scheme will cover all projects. The project admin controls project role membership
4. If the project leads want everyone that can logon access to the project they can add the logon group to a project role with the desired permissions.

 

This may be a big effort, but it will pay off down the road by making it easy to control access.

 

Most of the 'old timers' use project roles. It meets the best practice for security and gives complete control to the project lead for access to their project. JIRA comes with many project roles, but you can add more if you have a special need.

 

Do not delete issues. When you delete it is GONE. Hardly a week goes by without someone wanting to restore an issue. Deleting issues will come back and bite you when it is the most inconvenient. I suggest closing with a resolution value of Deleted anything you want to delete. I implement a special transition only the project lead can execute and it requires filling in a reason field from a select list (such as entered in error, OBE, Duplicate, Other) and explanation text.

Deleting issues destroys historical data. Missing issue numbers will eventually cause a question about what it was and why was it deleted even if it was done properly. Missing data always brings in the question of people hiding something that may have looked bad.

 

The only viable way to restore an issue is to create a new instance of JIRA and restore a backup that has the issues. Then export them to a csv file and import them to your production instance. You will lose the history.

 

 

Do not delete users

Users should be made inactive not deleted. JIRA uses a pointer to the user’s DB entry to display user information. If you delete a user when you open a JIRA issue the user worked on anywhere the user that would be displayed will cause a SQL error. Even if the user never logged on or were assigned a ticket the history of the ticket will get an error when you display it.

 

Put JIRA under CR

 I STRONGLY suggest you treat JIRA like a production system and put it under change control (CR) and track all requests for any updates, especially new projects, new custom fields, changes in any of the schemes, etc. That way at least the reporter will know when the actions happen and you'll have a audit trail. I've worked many similar tools to JIRA and too many times no one knows anything about why they are configured why they are because there is no requirements or CR. Things are just done based on emails that have disappeared and hallway or lunch conversations.  

 

If you don't already have a separate change control tool create a JIRA project. I use a basic workflow with a few custom issue types:

 

Custom field: with a select list of create, update. The description would be to create a new field or modify a current select list, buttons, etc. of a current one

 

Create Project: I would have text fields for issue types, custom fields, select list/values, per issue types

 

New Issue Type: description would include all fields and workflow desired.

 

Workflow: Select list of Create, update, delete. Description of what needed.

 

Other: Select list of Notification Scheme, permission scheme, field configuration, other

 

This should get you started. If you aren't familiar with your CR process there should be a configuration management person to talk to.