nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How with "JQL search" find my cf SLA?

Alex_2nfdtf

Hello everyone! Tell me please, i can how get all issues , where value ("SLA OK") with JQL ?

Accepted answers

Nic Brough -Adaptavist-

So, with a scripted field, they have two things we need to look at, and probably three for this question.

Scripted fields have an output "template", which tells Jira roughly what the content is and hence how to work with it. You can find this at the bottom of the screen in which you write the script for the field. It'll be text, date, number, etc.
Fields all have to be indexed to enable searching and sorting, and the indexers work differently for different types of data. Go to custom fields, find your field and use "edit", you'll see the name, description and searcher for the field there. The searcher should be set to a type that can understand the type of data the template is telling Jira the issue is (but it might not be by default - you can imagine the sort of junk you get if you set a filed template to text and a searcher to number-range). Can you check what that is? It determines what JQL you can use.
We may also need to know what exactly you are putting into the results - your screenshot suggests that you've got html-formatted text as the result - is that right?

Alex_2nfdtf

SOLUTION!

In the (admin panel) "custom field" I found my field and edited the value

from "none" to "free text search" in the "search template" field and after indexing my field started showing up in jql search. Thanks a lot!

My my final JQL search script :
project = MRCHNT AND "MRCHNT Handling" ~ "SLA FAILED"

All comments

Alex Koxaras -Relational-

Hi @Alex

Why type is this field?

Nic Brough -Adaptavist-

What type of field is your SLA field?

Alex_2nfdtf

@Nic Brough -Adaptavist- hi! scripted field

Alex_2nfdtf

@Alex Koxaras -Relational- HI! type of field - scripted field

Phill Fox

For the benefit of others who find this page when looking for answers on standard JSM functionality.

If you use standard SLA fields in Jira Service Management you can use the JQL explained at https://confluence.atlassian.com/servicemanagementserver/using-jql-queries-specific-to-slas-939926424.html

In this particular example I would use the JQL
"MRCHNT Handling" > remaining("1m")

This should return any issues with more than 1 minute remaining in the SLA.

Joseph Chung Yin

@Alex -

As per your reply to @Nic Brough -Adaptavist- / @Alex Koxaras -Relational- -

If it is a scripted field, you can just use it in JQL as any regular field. Question for you is why you are not using the using the SLAs which are part of your JSM project?

If you are using the out of the box SLAs setup of JSM, then you can just use the guide provided in the following link - https://support.atlassian.com/jira-service-management-cloud/docs/use-jira-query-language-jql-to-create-service-level-agreements-slas/

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Alex_2nfdtf

@Phill Fox Hi! unfortunately it doesn't work..

Nic Brough -Adaptavist-

So, with a scripted field, they have two things we need to look at, and probably three for this question.

Scripted fields have an output "template", which tells Jira roughly what the content is and hence how to work with it. You can find this at the bottom of the screen in which you write the script for the field. It'll be text, date, number, etc.
Fields all have to be indexed to enable searching and sorting, and the indexers work differently for different types of data. Go to custom fields, find your field and use "edit", you'll see the name, description and searcher for the field there. The searcher should be set to a type that can understand the type of data the template is telling Jira the issue is (but it might not be by default - you can imagine the sort of junk you get if you set a filed template to text and a searcher to number-range). Can you check what that is? It determines what JQL you can use.
We may also need to know what exactly you are putting into the results - your screenshot suggests that you've got html-formatted text as the result - is that right?

Phill Fox

@Alex That is because my answer was specifically for folks using Standard JSM who came across this question. NOT for your specific challenge of having used Custom Fields.

Alex_2nfdtf

@Nic Brough -Adaptavist-

Specifically, this sla ("MRCHNT Handling") counts time only when the issue in status "in progress"

Alex_2nfdtf

@Nic Brough -Adaptavist-

Nic Brough -Adaptavist-

Ok, so the template is text and your output is text. (Presumably, your searcher is text based as well)

This means you won't be able to search it numerically or exactly, but "Mrchnt handling ~ SLA OK" should find issues with that coming out of the field.

Alex_2nfdtf

SOLUTION!

In the (admin panel) "custom field" I found my field and edited the value

from "none" to "free text search" in the "search template" field and after indexing my field started showing up in jql search. Thanks a lot!

My my final JQL search script :
project = MRCHNT AND "MRCHNT Handling" ~ "SLA FAILED"

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-server

jira-service-management

jira-service-management-server