Using JWT calculated text field in a JQL query

[Brett Palmer]

I have a custom JWT calculated text field called "Work Type". The value is either "Product" or "Support". I tried using "Work Type" = "Product" but I get and empty set. I verified some of the values of the calculated field are indeed "Product". How do I use the custom calculated field in a JQL Query? 

[Thorsten Letschert _Decadis AG_ · Accepted solution]

Hi @Brett Palmer ,

while the hint from @Mirco Fabris is definitely correct as well - please use ~ instead of = - I'd like you to note that after adding this field to an issue, running a JQL statement against the actual value isn't working before another issue updated event or project/Jira reindex has taken place.

Cheers
Thorsten

[Brett Palmer]

I tried this too. I did perform a full reindex thinking that might be an issue. Still cannot use the field in a query. I have reverted to an single picker field with a triggered calculation instead of a real-time calculated field. This is not ideal fix though.

[Thorsten Letschert _Decadis AG_]

Hi @Brett Palmer , 

in order to to do further troubleshooting I probably need 'the full picture', e.g. the exact expression used. Are you able to share?

[Mirco Fabris]

I suppose the outcome of your calculated field is a string field?

Try: "Work Type" ~  "Product"

[Brett Palmer]

I tried that operator and = and != and in and not in. None of them worked. 

[Brett Palmer]

It did a full reindex and it started working. I know I did a reindex before too. Anyway, it works now. Thanks.

[Thorsten Letschert _Decadis AG_]

Hi @Brett Palmer ,

thanks for the feedback. Would you mind accepting my answer then? Thanks in advance!