Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,781
Community Members
 
Community Events
165
Community Groups

Lookup issue » custom field with URL

Hi!

I'm trying to set up a JQL to search and compare a custom field with an URL with the same custom field from other tickets with an URL.

Example: 

"cf[11300]" = {{issue."cf[11300]"}}

cf[11300] is the field I want to compare and its name is "Chat Link[Short text]". I've tried on both formats, "cf[11300]" and "Chat Link[Short text]", but I always get the result:

Custom Smart Value JQL Search: "("cf[11300]" =) - Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 15)

The field after "=" is empty, looks like it can't get the info from the cf[11300] field. This field is always an URL, is that what's stopping the JQL from finding it? Or am I missing something?

Thank you for your help!

1 answer

0 votes

Hi @Tiago Leite 

for reasons of deeper analyze and overview: could you please provide a screenshot of your automation rule and the special components that contain the jql and/or smart value?

Furthermore: could you try to add a "audit log" action to see if the value of the used smart value can be read.

And:
Did you also try a notation of smart value without "" --> eg. with

  • id ---> {{issue.customfield_13300}} or
  • name --> {{issue.Chat Link[Short text]}}

 

Best
Stefan

Hi @Stefan Salzl !

Thank you for your reply!

Here's a screenshot of the main core of this automation: 

Screenshot 2022-06-22 16.12.07.png

I've tried ID and name without "", both still got the same error, it's blank after the "=".

I've also tried "=" and "IS", instead of "~", but got the same outcome.

Stefan Salzl Community Leader Jun 24, 2022

Hi @Tiago Leite ,

What kind of type is your custom field? is it text or URL field?

Could you maybe share a screenshot of an issue with that field for having a better overview?

Best
Stefan

Stefan Salzl Community Leader Jun 24, 2022

Hi @Tiago Leite ,

guess I could figure out the problem:
I have no idea why the field type is added in jql search but as far as I could find out it´s no problem within the issue search but the smart value can´t resolve the [Short Text].

Following lookupIssue search worked on my side:

"Chat Link" ~ {{issue.Chat Link}} and id != {{issue.id}}

 

Please let me know if this was helpful.

Best
Stefan

Hi @Stefan Salzl ! Thank you, once again, for your reply!

I can't share the field itself, since it has internal information, but it's an URL. Before that field, when the ticket is created, the field has "${ChatURL}", but that information is not shown on the ticket itself.

When I tried the ""Chat Link" ~ {{issue.Chat Link}} and id != {{issue.id}}" I got the same outcome:

Custom Smart Value JQL Search: "("Chat Link" ~ and id != 5628902) AND (project in (12854))" - Error in JQL Query: Expecting either a value, list or function but got 'and'. You must surround 'and' in quotation marks to use it as a value. (line 1, character 17) 

Before that field, when the ticket is created, the field has "${ChatURL}"

 

What exactly do you mean with „before“? when exactly does this action happen? Is the field/url set in a previous step of your rule? Could you please share the whole automation rule?

Furthermore could you please add a „log action“ action that only prints the value of the field to the audit log via smart value of the issue {{issue.Chat Link}} and check the result?

Best
Stefan

Stefan Salzl Community Leader Jun 28, 2022

@Tiago Leite 

could you share a screenshot of your entire automation rule as well as the detailed configuration/settings of your lookupissues action?

This would help to get a better understanding of the whole context in order to find the right solution.

Best
Stefan

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Atlassian Automation

Jira Automation: Sum Up Story Points Roundup (Initiatives -> Epics -> Story/Tasks -> Subtasks)

Hi Everyone, In this roundup we combine all the jira automation rules to sum up story points across different issue types. We start from the lowest level, summing up story points from sub-tasks t...

1,859 views 2 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you