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?
Hi @Brett Palmer ,
while the hint from @mfabris 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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It did a full reindex and it started working. I know I did a reindex before too. Anyway, it works now. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Brett Palmer ,
thanks for the feedback. Would you mind accepting my answer then? Thanks in advance!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I suppose the outcome of your calculated field is a string field?
Try: "Work Type" ~ "Product"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I tried that operator and = and != and in and not in. None of them worked.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.