nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query for History log in Work log

María Elena de León

How do I get the date when a user enters work log in a date range.

I need a query to get the list of issues where a user updated the worklog in a certain date range (from the history field)

My query in natural language would be

Project= “Project Name” AND worklogDate>”2022/09/1” AND worklogDate<”2022/09/30” AND historyDate>"2022/10/01"

I dont know how the get the "historyDate" field

Accepted answers

All comments

Trudy P Claspill

Hello @María Elena de León

Can you provide more information about what you mean by the "history" field. There is no such field natively in Jira. There is a History tab that shows all the changes to the issue, but this is not a single field. Rather it is a set of records where each record has multiple fields.

Worklogs also are a set of records, each one with multiple fields that detail a single worklog entry (date started, time spent, user logging the work, etc.).

Can you share a screen image and point out the "historyDate" field from which you are trying to get a date?

And can you explain how you are trying to use that date as it relates to work log entries?

Matt Doar_tzgiej

I read that as pseudo JQL not actual JQL

Matt Doar_tzgiej

I don't think you can do this with JQL. But you could use a JQL search to retrieve all the issues with work logged in the chosen range. Then use a script to extract just those issues and process the issue history in each one, outside Jira.

Something such as https://community.atlassian.com/t5/Jira-Software-questions/Re-Get-history-of-tickets-transitions-with-python-API/qaq-p/1460070/comment-id/93827#M93827

Trudy P Claspill

I got that it was not actually JQL. I'm not understanding what the user is trying to accomplish and how the "history date" element factors in to it.

Is the user trying to retrieve issues, or worklogs? How is the "history date" supposed to be used to constrain the results.

Yuliia_Borivets__SaaSJet_

Hi @María Elena de León

As I understand, you need to get changes for the custom field of "History Date" for a specific period. For this case, you can try Issue History for Jira app if you are ok with it. Here you can find changes for any custom or standard field. It's also possible to choose the date range.

assignee activity in jira.png

*The app is developed by my team.

Let me know if you have any questions.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud