SLA stores Due datetime as per SLA. Which column I can use in Search filter to see same

[Praveen Bansal]

In screenshot below I can see Due date time as 11/28/2024, 11:30 pm.

Which column I should sue to see this in my Search filter

[Hannes Obweger - JXL for Jira]

Hi @Praveen Bansal

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this is easy to do using 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 so-called smart columns that aren’t natively available, including the breach time (a.k.a. due date) of your SLAs.

This is how it looks in action:

As you can see above, you can easily sort and filter by your SLA columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Of course, you can also export your data to Excel or CSV in just two clicks.

Any questions just let me know,

Best,

Hannes

[Praveen Bansal]

Thanks but as of now looking for free tools/solution. Have noted anyway for future

[Alina Kurinna _SaaSJet_]

Hi @Praveen Bansal!
If you're open to using add-ons from the Atlassian Marketplace to address this issue, I have a solution that can help you. My team has developed the SLA Time and Report add-on for defining and monitoring SLAs. With this add-on, you can configure and add custom fields to tickets, such as Due date.

Here’s a step-by-step guide on how you can do this:

To add custom fields, such as SLA Status, Due date, Target Date, etc., to a ticket to show SLA in real-time, you need:

1. Go to your service project.
   
2. Then, navigate to the SLA settings, click the "SLA Manager" button, and create a configuration for your project by selecting "+ Add new configuration."
3. Choose the type of SLA Goal for the new SLA configuration based on a time limit or a negotiated date.
   
4. Next, fill in the following parameters:

• Name
• Project
• Calendar
• Start/Pause/Stop conditions
• SLA Reset
• Multi-Cycle option
• SLA Goals settings with automated actions
  
  
  

5. In the SLA goals settings menu, specify SLA goals and select an Automate action for issues that exceed their limits. A critical step here is to enable the Custom Field button.
   
6. Now you’re done! When an issue is created, you’ll see the custom fields in the ticket:
   
7. Also, you can see information about SLA configurations, SLA status, time to resolution, and other details related to the SLA status for this ticket on the SLA Time and Report panel:
   

I hope I was able to help you with your request. If you have any questions, feel free to reach out to me. I’ll be happy to assist!

[Praveen Bansal]

Thanks but as of now looking for free tools/solution. Have noetd anyway for future

[Callum Carlile _Automation Consultants_]

Hi @Praveen Bansal , unfortunately it is only possible to display the time goal of the SLA on the search page, and not the date/time when this will reach zero

[Ajay _view26_]

Hi @Praveen Bansal 

Welcome to the community! You can add the SLA column ( in your case - "Time to resolution") as a column in the Search column as shown below.

You need to go to Filters->View all Issues-> and select the table columns as shown below. Note that you will get the total elapsed time for the SLA in the column and not the remaining time.

[Praveen Bansal]

Thanks Ajay but I'm aware of this. I am looking for if there is some way I can see Due date time as you see in screenshot