Custom fields not available in "Copy Value From Other Field" post function

[Juan Raven]

Hello!

Am I going crazy?

Using a post function on transition, I want to copy the value of my custom field, Resolver, to the Assignee field.

I thought I used to be able to copy values from custom fields to other custom fields with a post function on a workflow transition. I'm not able to do that now. Only a few system fields are available.

Please help.

Thanks!

[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