After update, AQL asset searches no longer work properly for Created field

[Robert Terrell]

We just updated to 11.3.4 of JSM Data Center last night. Now, any of my Asset AQL queries involving Created date are no longer working properly. Anyone seen anything like that?

The main query I want to use is to show me objects that have been created in the last 30 days. My saved query was Created >= now(-30d)

Now, when I run it, it returns every item ever created. I even tried adjusting to hours or smaller/larger dates, but it always just returns ALL items created. Other queries are working just fine, it just appears to be ones related to using the Created item.

I haven't created a ticket with Atlassian support yet, wanted to check with the community first, incase I missed something somewhere.

Thanks!

[Kunal Kanojia · Accepted solution]

We have reproduced the issue and have opened a bug ticket that includes the workaround.

https://jira.atlassian.com/browse/JSDSERVER-16549

We are also actively working on a permanent fix for this bug.

Thanks,

Kunal

Jira Service Management DC Team

[Robert Terrell]

Ah yes, this appears to be dead on. I tried one of the listed working formats and it does return the results I'm looking for. I'll have to do it that way until they release a bug fix in a future version.

Thank you Kunal!

[Marc -Devoteam-]

Hi @Robert Terrell 

In the release notes there is a statement on changes on date formats in Assets, this might cause this.

As I'm not on DC I can't test this for you.

See https://confluence.atlassian.com/servicemanagement/jira-service-management-11-3-x-release-notes-1689288960.html 

Otherwise it's best to contact Atlassian on this.

[Robert Terrell]

Thanks for the link. Looks like that might be more involved with importing vs searching. I'll hit up support.

Thanks for the help!