Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am using this API call in Power BI:
path = "rest/api/3/search?maxResults=100&jql=",
jql_query = "issueType=Bug&fields=project,created,assignee,status,priority,reporter,creator&expand=changelog",
fields_query = "project,created,assignee,status,priority,creator,reporter",
Source_new = Json.Document(
Web.Contents(host,
[
RelativePath=path,
Query=[issueType="bug", fields=fields_query, expand="changelog"]
]
)
)
I want to limit the bug records returned to only bugs created this year.
Anyone has experience with Jira API and can give suggestions? Any help will be greatly appreciated! Thank you.
Solved! Go to Solution.
Hi @v-shex-msft thanks for the reply.
Anyway, I've solved the issue using:
createdDate>%3D'2020%2F01%2F01'
The date format need to be escaped apparently.
Hi @v-shex-msft thanks for the reply.
Anyway, I've solved the issue using:
createdDate>%3D'2020%2F01%2F01'
The date format need to be escaped apparently.
Hi @gggar,
Any logic date fields include in your data source to remark the created date? If that is the case, you can invoke that field with the operator in 'query' options to filter records based on date values.
Advanced search reference - JQL fields | Jira Software Cloud | Atlassian Support
Advanced search reference - JQL keywords | Jira Software Cloud | Atlassian Support
Regards,
Xiaoxin Sheng
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |