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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,558,125
Community Members
 
Community Events
184
Community Groups

JQL using JIRA API in Python

Harshita G
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 10, 2023

Hi I am trying write a JQL using the API in python to get the data from the tickets from a particular board, I want to add date variables so that we can get the data for user entered dates. I am new to using the API so unable to figure out how to do this. I will be grateful for any help, Thanks in advance. I tried using the following which is giving me error -:

 

project_issues_specific = jira_instance.get_all_project_issues(project="MED", fields=["description", "summary"])

 

the above is working but giving me the first 1000 when the board was created, I also tried 

 

jira_instance_1 = jira_instance.jql(project = "PROJ1" AND "Epic Link" = EPIC-123 AND issuetype = Story ORDER BY priority DESC, updated DESC)

 

jql_query = project = MED AND issuetype in (Task,Story) AND "Epic Link" = "MED-098" AND updated >="-6M"

 

both of these are giving me syntax errors.

1 answer

1 accepted

0 votes
Answer accepted

I think the JQL should be in a string and I don't see any quotes around them, is it a python syntax error?

Something like "project = \"PROJ1\" AND \"Epic Link\" = EPIC-123 AND issuetype = Story ORDER BY priority DESC, updated DESC"

I could be misunderstanding but hope that helps!

Harshita G
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 14, 2023 • edited

Thanks Jared, yes it was a syntax error, thanks for helping me out. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events