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

Table 21.1. 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