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"

[Charlie Misonne · Accepted solution]

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.

[Bruno Machioni Leitão]

Hey @Charlie Misonne

I was finally able to break through. The thing is that the date format must be specificaly like this to work with that Glue-Jira connection:
"2025-09-10T12:06:09.172-0300"

Thanks for your help!

[Charlie Misonne]

Ok! I'm glad you found out.

I suspected a date formatting issue. In Jira's JQL several formats are supported but for Glue it's different.

[Aias Martakis]

@Bruno Machioni Leitão I have the exact same issue, however I've tried to filter with your datetime string on the same updated column (and several variations) and still receive that it can't parse it:

the value "2025-09-10T12:06:09.172-0300" for field updated is invalid, Please retry with valid input.. 

would you be so kind to provide your full FILTER_PREDICATE?

[Aias Martakis]

this worked for me:

updated >= '2025-01-01T00:00:00.000Z' AND updated < '2026-01-01T00:00:00.000Z' AND project != 'A' AND project != 'B' AND project != 'C'

note that it seems only 'AND' works, not 'OR' so yea its very limited