Advanced transition settings (conditions, triggers) are not available

[Victor Grischenko]

Hi all,

I'm trying to configure conditions for my workflow according to this document: https://confluence.atlassian.com/adminjiraserver070/advanced-workflow-configuration-749383189.html#Advancedworkflowconfiguration-conditions.

And I can't find no links on properties panel:

1454532128085.png

I am administrator according to my permissions:

1454532326089.png

How to activate advanced settings for transitions?

[Udo Brand · Accepted solution]

If I got you correct you want to select issues where all comments does not contain the word "Test".

Hmm, I think this can not be achieved with advanced JQL. As you mentioned as soon as you have in one comment "Test" the 'does not contain' condition becomes true.

Sorry

[Pat Cullen]

This can be achieved by building two queries:

1) Build a query that gives you all tickets that contain your text "Test":

project = "MYPROJ"  AND comment ~ "test"

2) Save that query and note the filter id. We'll pretend the filter id is 1234

3) Reference that query to get the opposite of it:

project = "MYPROJ" AND filter != 1234

[Florian K]

You mean

comment ~ "test"

instead of

project = "MYPROJ" AND comment ~ "test"

, right?

[Cory Bonneau]

That did exactly what I needed! 

Thanks you so much

[Amir Katz (Outseer)]

See the answer by Ignacio Pulgar (May 9, 2018) in this thread:

https://community.atlassian.com/t5/Jira-Core-questions/Search-for-issues-that-do-not-contain-text/qaq-p/455633

The secret ingredient is how to use the filter:

<some-criteria-here> AND FILTER NOT IN (<filter-ID>)

Definitely counter-intuitive IMO...

[Carolina Rodriguez]

Hi @Pat Cullen, I am trying to use your suggestion with two queries but getting error "causes a cyclical reference" when executing the second one. Specifically, I created this first query: 

type = "Enhancement Request" AND comment ~ housekeeping ORDER BY created ASC

Saved it with filter ID: 27613

Then use filter in second query:

type = "Enhancement Request" AND filter !=27613

I am trying to get all tickets without comment that includes the text" Housekeeping". Any help would be very much appreciated! 

[Mark Gaz]

Hi @Carolina Rodriguez,

The trick is to not use similar expressions in both (here it's the 'type' term), per @Florian K's message above.

If you save only this part as your first filter: 'comment ~ housekeeping'

then your second query should then work.

Mark

[Tarun T]

How can i search for string not containing # character in comments. above solution is not valid here as # being reserved character in JQL