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; } } }

How to filter for "updated > somedate"

Bruno Machioni Leitão

I'm bringing data from Jira to a database, I have a connector for that. But when I try filtering for the "updated" field, I get some errors like the following:

The value "2025/11/12 13:18" for field updated is invalid

The value "2025-11-12" for field updated is invalid

I tried following the Jira docs for that, but no help
Also tried "updatedDate"
https://support.atlassian.com/jira-service-management-cloud/docs/jql-fields/

For instance, I'm able to filter "project = 'ABCD'"
But not "updated < '2025-11-12'"

What is the correct way to filter this field?

HOW TO MAKE IT WORK:
USE A DATE FORMAT LIKE THE FOLLOWING "2025-09-10T12:06:09.172-0300"

Accepted answers

Charlie Misonne

Hi Bruno,

Where are you filtering? On which page?

A screenshot would be helpful.

For me the following JQLs work perfectly fine:

updated > "2025/11/12 13:18"
updated > "2025-11-12"

All comments

Charlie Misonne

Hi Bruno,

Where are you filtering? On which page?

A screenshot would be helpful.

For me the following JQLs work perfectly fine:

updated > "2025/11/12 13:18"
updated > "2025-11-12"

Bruno Machioni Leitão

Hi,

It's outside of Jira interface. I'm filtering directly in the connector that extracts the data.

Here's a code example that fetches data from Jira:

 JiraCloudData = glueContext.create_dynamic_frame.from_options(connection_type="jiracloud", connection_options={"connectionName": "jira", "API_VERSION": "v3", "ENTITY_NAME": "issue", "FILTER_PREDICATE": project = 'ABCD'}, transformation_ctx="JiraCloudData")

In the filter predicate I'm able to filter for the specific project I'm interested in, but I'm not able to use those updated filters.

Charlie Misonne

Hi Bruno,

Ok interesting. I'm absolutely not familiar with AWS Glue but here is what I found on Jira Cloud connection options - AWS Glue

FILTER_PREDICATE(String) - Default: empty. Used for Read. It should be in the Spark SQL format.

It looks like this expects "Spark SQL" and not JQL. If you can include the "updated" field in this parameter it might expect another notation for the date.

I assume there must be more documentation on this?

Bruno Machioni Leitão

Hi,

Yes, I read that documentation and am using Sparl SQL in the filter, but it still doesn't work for filtering the "updated" column. Also doesn't work with the "created" column.

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-cloud

jira-service-management