Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Hi, I have problems with JQL querys

I'm trying to run the following query:   

  • project = MCM AND worklogComment ~ "TESTE"

I want to filter the issues from the project MCM that contain logged time as "TESTE" in the plugin "Tempo". Please look at the following issue. It contains logged time with the description "TESTE" and it is part of the project MCM. Unfortunately, my JQL query does not return anything. 

tempo.PNG

1 answer

Hi @Hugo Villamizar

Tempo on Cloud resides in its own system and uses its own database. 
When a user logs work with Tempo, the Tempo Timesheets plugin updates Jira’s time spent field on the issue, as many Reports, functionalities and more are relying on this field. 
The information that is synced to JIRA does not include the worklog owner or the worklog description. 
By informing Jira of which user created a Worklog and the description, we may be breaking the View All Worklog / View Team Worklogs permission as once this information is within Jira it might be visible to users without these permissions.
As JIRA has no information about the worklog description, using jql to filter by it is not possible.

Regards,
Susanne Götz
Tempo team

@Susanne Götz thank you so much for your quickly reply. 

Is there another way to get this information? 

Abs,

Hi @Hugo Villamizar

There is currently no simple workaround for this as filtering by worklog description is not possible within Tempo.

It can be done by Filtering the Tempo Report by the MCM and selecting the required timeframe. Then export the report to excel and use the excel filtering option to filter by the "Teste" description.

Regards,
Susanne

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,469 views 22 32
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