Stack Overflow
Stack Overflow

Questions tagged [jql]

JIRA Query Language (JQL) is used to perform advanced searches within JIRA.

JQL allows users to perform an advanced search using structured queries within JIRA. JIRA is a issue tracking product, developed by Atlassian, used for bug tracking, issue tracking and project management.

A simple query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions. For example, the following simple query will find all issues in the "TEST" project:

project = "TEST"

References

522 questions
0
votes
4 answers

Webservice Jira gives: Error: No such operation 'getIssuesFromJqlSearch' from Jira 4.01

When I use the Webservice of Jira, I need to use the method getIssuesFromJqlSearch to describe a certain (JQL) Query. But it returns me "No such operation 'getIssuesFromJqlSearch'". Is this method in Jira 4.01 not implemented yet? BTW: I need a…
Robert
  • 664
  • 9
  • 25
0
votes
2 answers

Getting Wget and JQL to run

We are trying to run a command wget -O xyz.xls --user=COldPolar --password=GlacierICe --ignore-length=on…
zubinmatie
  • 3
  • 4
0
votes
1 answer

How to find jira issues with componets lead by the current user?

I tried to use the following jql but it resulted in jql validation error: component in componentsLeadByUser( currentUser() ) Error in the JQL Query: Expecting ')' or ',' but got '('. When I replace the currentUser() with concrete user names, it…
László Antal
  • 3
  • 2
0
votes
2 answers

JIRA query language limit columns returned

If I have a JIRA instance with 25 columns and I only want to pull in 10 of those columns, how do I do that? I have not been able to find a command to include or exclude columns in the search.
user3280433
  • 11
  • 1
  • 1
0
votes
1 answer

JQL syntax not working with slaSearch

I am trying to create a filter that takes in all incidents that are in progress, and have less than or equal to 25% left of their SLA-timer. issuetype = Incident AND status = "In Progress" AND vertygo in slaSearch(remaining, "<",26%) The base for…
Shargarth
  • 11
  • 2
0
votes
1 answer

Sorting/Ordering the contents of a jTable before committing to a bound Java DB

Is it possible to sort/order the contents of a jTable before committing to a bound Java DB?
newToJava
  • 173
  • 1
  • 15
0
votes
1 answer

Query from a timestamp based on a date?

How do I execute a query based on date? As you can see below, I have a table with the attribute PURCHASEDATE as a timestamp. My current query is String query = "SELECT t FROM TransactionE t WHERE t.purchaseDate = '" + currentDate +…
Lawrence Wong
  • 1,129
  • 4
  • 24
  • 40
0
votes
1 answer

How to use date field in a JIRA JQL Query as a predicate

I'm trying to write a JQL query that will let me find issues where the status changed to a given status after the value entered in a date field. I want to write this query: due is not EMPTY and status changed to "MyStatus" after due This is not…
Evan Walsh
  • 1
  • 3
0
votes
1 answer

JQL update needed

I just got put onto a project where one of the requirements have changed and I was wondering if I could simply update the functionality by changing the JQL. I have the following table in our database: select * from project_organization; ID …
Dan
  • 979
  • 1
  • 8
  • 29
0
votes
1 answer

how to show a tabular result in JIRA

I can get a list of Jira tickets based on specific ticket type. Now what I am looking is to generate a report of those tickets which will be shown as table. Let say I have these tickets TC-1: myurl/to/address1 TC-2: myurl/to/address2 TC-3:…
coure2011
  • 40,286
  • 83
  • 216
  • 349
0
votes
1 answer

JQL Tricks Plug In Filtering

I'm working on developing a filter in JIRA using JQL that can allow me to pull from all of the projects my team is working on. What we would like to be able to do is be able to search using VersionMatches(""). Using VersionMatches we would like to…
Justin
  • 1
0
votes
1 answer

Java EE/SQL: Is there a significant performance lag between primary key types?

Currently I am involved in learning some basics of the Java EE technology. I encountered a particular project and took a deeper look into the underlying database structure. On server-side I investigated a Java function that creates a primary key…
John Rumpel
  • 4,535
  • 5
  • 34
  • 48
0
votes
1 answer

Get counts of values of an Enum in JQL

Is thare any way a JQL can get the counts according to the values of an Enum? For example, Enum has values as Single, Married, Divorced, etc. and get the counts of Persons Entity in a single Java Persistence Language Query?
Buddhika Ariyaratne
  • 2,339
  • 6
  • 51
  • 88
0
votes
2 answers

In JIRA, how can I create an issue filter that excludes duplicates?

I have a JIRA issue filter in which I list a set of issues that meet my criteria. Some of these have links of type duplicates. I want to exclude those duplicates issues from my query. Logically I am looking for something like: ... AND !…
jayraynet
  • 896
  • 1
  • 7
  • 24
0
votes
1 answer

in OQL, or JQL, how do you do this type of outerjoin

Say we have two completely unrelated entities EntityX and EntityY both with column age. How do I in OQL do a join like so select x,y from EntityX as x full outer join EntityY as y on x.age = y.age Is this not possible? thanks, Dean
Dean Hiller
  • 19,235
  • 25
  • 129
  • 212
1 2 3
…
34
35