JQL search text containing .com

[Yulia Zhyliaieva]

Hi,

When I search for tickets containing text "conferento.com" it does not return any results.

When I search for tickets containing text "conferento" the result is returned.

Originally I thought that it was because of the dot.

But the search for "branchen-info.com" DID return results.

I know that I have tickets containing exactly that text in the SUMMARY

What is wrong?

EXAMPLE:

I have 2 tickets, both having full stop in the summary:

1) https://www.conferceento.com/listings/bla-bla-bla

2) yp-http://www.branchichen-info.net/bla-bla-bla.php

We need to include the url into the tickets, this is a webscraping project.

When I search by text:

1) conferceento.com - JIRA provides no resuts

2) branchichen-info.net - JIRA returns the result

[Valerie Knapp]

Hi @Yulia Zhyliaieva , I don't know if you saw this but Atlassian are rolling out more changes to the JQL search from October, maybe this might help?

Search for an exact phrase with JQL - Atlassian Community

[Tom Lister]

HI @Yulia Zhyliaieva 

This should work. I have similar queries that do text searches.

Is the summary check the only clause in your JQL?
Are there any special characters or spaces in your summaries?

More details on text searching can be found here https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/

Does the same behaviour happen using

text ~ "\"conferento.com\""

[Yulia Zhyliaieva]

thanks!

This search does not provide results either.

The summary check is the only element in my JQL indeed.

So, I have 2 tickets, both having full stop in the summary:

1) https://www.conferceento.com/listings/bla-bla-bla

2) yp-http://www.branchichen-info.net/bla-bla-bla.php

We need to include the url into the tickets, this is a webscraping project.

When I search by text:

1) conferceento.com - JIRA provides no resuts

2) branchichen-info.net - JIRA returns the result

Can't understand what is different between these two queries in terms of syntax?!

Thanks

[Tom Lister]

Hi @Yulia Zhyliaieva 

I tested this with conferceento.com in the summary and it worked. However when I put the full URL in the summary it stopped working.

Changing the test to confrerceento.net in the URL does not work either

I have seen reports of searches not working on text containing the "/" character.

Strangely if i search for www.conferceento.com it works

If I search for www.conferceento it fails again.

Even more odd if change to summary and search to test www.confer-ceento it works again.

That sort of explains what there is a difference in results. But the parsing logic seems unfathomable.
-contains a - works
- .com works if another . is in the search e.g. www. is included

One to report to atlassian?

[mauricio.groth]

Hi @Yulia Zhyliaieva 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the issues that have “conferento.com” in the summary

issue in exactTextMatch("conferento.com")

Check out the documentation for more examples. 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Saralie S.]

@mauricio.groth Hello Mauricio. Please ensure that you have thoroughly read our Marketplace and Solution Partner guidelines. 

Although you are welcome to offer your product as a solution when appropriate, this doesn't mean posting links everywhere that you can find or promoting your app in threads that are not relevant. 

Your content should be 99% practical information, and 1% promoting your product or service. And make sure the user is aware you are affiliated with the app by mentioning that in the body of your post. 

[Valerie Knapp]

Hi @Yulia Zhyliaieva . I don't know if the JQL is treating the full stop / period as a separator.

Have you tried the advanced searching - Advanced search reference - JQL operators | Jira Software Cloud | Atlassian Support?

like this: 

summary ~ "\"conferento.com\""

[Yulia Zhyliaieva]

@Valerie Knapp thanks!

However, as I noted in the message, it DOES search for other issues that contain a full stop.

Same conditions: full stop in the summary of the ticket.

In one case it returns the results, in the other one - does not.

summary ~ "\"conferento.com\"" also did not return results, but the ticket is there

[Valerie Knapp]

@Yulia Zhyliaieva Hmm, there are some open tickets with Atlassian about JQL searches in the Cloud I found in another Atlassian Community articles -

How do you search for an exact phrase in JIRA? (atlassian.com)

[JRACLOUD-69263] JQL Contains "Exact Phrase" does not return the result as expected - Create and track feature requests for Atlassian products.

[JRACLOUD-21372] Allow exact-text searching in JQL - Create and track feature requests for Atlassian products.

So I'm not sure what to suggest, other than that you can vote for these issues. Sorry and good luck!