21. Search Advanced

21.1. Rationale

  • JQL - JIRA Query Language

21.2. Where to find?

  • Issues -> Search for Issues

  • Basic -> Advanced

  • Detail View -> List View

  • Konfiguracja kolumn wyświetlania

21.3. Where is used?

  • Searching Issues

  • Board Configuration

  • Filters for Dashboard

  • Filters for Subscriptions

  • Bulk edit (to change limit: echo 'jira.bulk.edit.limit.issue.count = 1000' >> $JIRA_HOME/jira-config.properties)

  • jira.issue.editable = true dla statusu Done (Workflow)

21.4. Operators

  • Operators capital letter

Operators

Operator

Description

=

Equals

!=

Not equal (is different than)

>

Greater than

<

Less than

<=

Greater or equal

>=

Less or equal

~

Contains text

(...)

List

AND

Conjunction

OR

Disjunction

ORDER BY

Ordering

ASC

Ascending

DESC

Descending

21.5. View

  • Konfiguracja kolumn wyświetlania

  • Import / Export CSV

    • All fields

    • current fields

  • Limit wyświetlania wyników dla JQL (change: General Configuration -> Advanced Settings -> jira.search.views.default.max)

21.6. Select issues

project = "MYPROJECT"
status = "To Do"
assignee = "admin"
reporter = "myusername"
summary ~ "Hello"
summary ~ "Hell*"
summary ~ "*ell"
summary ~ "*ell*"
assignee != "myusername"
statusCategory = "To Do"
statusCategory != "Done"
Flagged IS NOT EMPTY

21.7. Ordering

project = "MYPROJECT"
    ORDER BY priority DESC
project = "MYPROJECT"
    ORDER BY priority DESC, key ASC

21.8. Complex queries

project = "MYPROJECT"
    AND status = "In Progress"
status = "To Do"
    OR status = "In Progress"
status IN ("To Do", "In Progress")
status NOT IN ("To Do", "In Progress")
statusCategory NOT IN ("To Do", "Done")
project = "MYPROJECT"
    AND resolution NOT IN ("Done", "Won't Do")
project = "MYPROJECT" AND (
    priority = Highest
    OR Flagged IS NOT EMPTY
    OR statusCategory = "In Progress")

21.9. Demonstration

  • Autocompletion

  • Scalar and list operators

  • Text Operators

  • Bulk-change

21.10. Assignments

21.10.1. Search Advanced Bulk Change

  1. Przejdź do wyszukiwania zadań:

    • Cloud: Z menu Filters wybrać Advanced Issue Search

    • Server: Z menu Issues wybrać Search for Issues

  2. Upewnij się, że jesteś w trybie wyszukiwania: Advanced

  3. Wyszukaj: project = MYPROJECT and due IS EMPTY (gdzie MYPROJECT to nazwa Twojego projektu)

  4. Przycisk Tools (po prawej u góry) -> Bulk Change -> all X issue(s)

  5. Zaznacz wszystkie (checkboxem do zaznaczania wszystkich na raz, nie rób tego pojedynczo)

  6. Kliknij przycisk Next -> Edit Issues -> Next

  7. Zmień Change Due Date i ustaw na 1/Nov/00

  8. Kliknij przycisk Next (na dole) -> Confirm -> Ok, got it