FixVersion in JQL

Thilaga Raguram August 8, 2021

Hi, am preparing for ACP-600 and came across a below question:

Your development team has just released their first version of a GPS tracker yesterday. The next product release is not due for another 3 months.
Which two JQL queries, when executed today, will list all features shipped in the 1.0 version? (Choose two.)
A. project = GPS AND issuetype Feature AND fixVersion = released()
B. project = GPS AND type = Feature AND fixVersion in (1.0)
C. project = GPS AND issuetype = Feature AND fixVersion(s) IS NOT EMPTY
D. project = GPS AND type = Feature AND fixVersion in releasedVersions()
E. project = GPS AND type = Feature AND fixVersion(s) = “1.0”
F. project = GPS AND issuetype = Feature AND fixVersion in 1.0

I believe the correct answer is D. 

Also, I doubt whether fixVersion(s) is a valid syntax to be used in JQL?

Could you please clarify this. 

Thanks!

3 answers

1 accepted

2 votes
Answer accepted
Piotr Zadrożny _Eyzee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2021

Hi @Thilaga Raguram Welcome to Atlassian Community!

Let's consider all the possibilities:

  • A. project = GPS AND issuetype Feature AND fixVersion = released() - This is incorrect. There is not such function as released(),
  • B. project = GPS AND type = Feature AND fixVersion in (1.0) - This is one of correct answers. Using in statement you can provide one or more values,
  • C. project = GPS AND issuetype = Feature AND fixVersion(s) IS NOT EMPTY - This is incorrect. There is not such field as "fixVersion(s)",
  • D. project = GPS AND type = Feature AND fixVersion in releasedVersions() - This is one of correct answers. As in question: "Your development team has just released their first version",
  • E. project = GPS AND type = Feature AND fixVersion(s) = “1.0” - This is incorrect. There is not such field as "fixVersion(s)",
  • F. project = GPS AND issuetype = Feature AND fixVersion in 1.0 - This is incorrect. Using in require you to provide the list of values in brackets ().

Best regards,

Piotr

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2021

No, this is wrong.  You have not read the question properly and your statement about requiring brackets is incorrect.

Piotr Zadrożny _Eyzee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2021

@Nic Brough -Adaptavist- tell me where I am wrong?

1. From question:

Your development team has just released their first version of a GPS tracker yesterday. (...) Which two JQL queries, when executed today, will list all features shipped in the 1.0 version?

So there is only 1 released version, and when we will run this query today we will receive only issues from 1.0 version.

2. From documentation

The "IN" operator is used to search for issues where the value of the specified field is one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.

3. I even created demo project with such configuration:

  • Two versions, first just released:

versions.png

  • All issues from project:

2.png

  • Answer A

a.png

  • Answer B

b.png

  • Answer C

c.png

  • Answer D

d.png

  • Answer E

e.png

  • Answer F

f.png

Kind regards,

Piotr

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2021

fixVersion in 1.0 works fine for me (as long as I have a version called 1.0 somewhere), and answer D is incorrect because it does not specify version 1.0 

The question does say "just released their first version", but D is wrong at the instant they release another version, which could be done before the questioner asks the question.

If your answers are correct, then the question is poorly written - all answers should be inarguable, and these are not.

Piotr Zadrożny _Eyzee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2021

In question you have information that there will be no release for another 3 months so dev team couldn't at the instant release another version.

But there is one ambiguity in this question. In sentence "Your development team has just released their first version" there is no information about the name of that version and of course it could be named for example "v1" not "1.0". I agree that question and all answers should be inarguable!

BTW. In terms of IN operator, I have just verified it in Cloud and Server 8.12 and on both IN operator required ( ).

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2021

The version I'm on "in" needs no (), and the fact that releasedVersion() will not show you only the version you just released means the answers are arguable and hence incorrect.

B is in fact the only inarguable answer that is correct.  (F is the other correct answer, but only for some versions of Jira, which hence breaks the question)

I really don't like that bad questions like this have been published or used in the exams.  It's exactly this sort of thing we were taught not to do when we started writing the exams, it seems more recent writers are failing.

0 votes
Thilaga Raguram August 8, 2021

Thanks Piotr for detailed demo!

I also guessed B & D as the right answers. However, was having doubt in B. 

I read in an Atlassian confluence page as below:

  • Find issues with a Fix Version of 3.14 or 4.2:
    fixVersion in ("3.14""4.2")
    (Note that full-stops are reserved characters, so they need to be surrounded by quote-marks.)

Since there were no quote marks I thought it might be wrong. If there are multiple values then it should be surrounded by quotes, and in our case, the IN operator has only one value, hence did it pass through without quotes? 

Piotr Zadrożny _Eyzee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 8, 2021

I verified and both the Cloud and Server (8.12.2) versions do not require from me quote-marks in this case, even when I provide a list of versions. I assume there may be an error in this part of documentation.

qqq.png

Naturally, if there is a version name which include comma, for example, "v1,0", quote-marks will be needed.

Thilaga Raguram August 8, 2021

Thanks for the clarification!

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2021

You are right about fixversion(s) but you need to read the question properly.  Note that it asks for a specific version, not all the released versions.  Also that it asks for you to select two of the 6.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events