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

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

Robert Terrell_sqcpj8

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!

Accepted answers

Kunal Kanojia

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

All comments

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_sqcpj8

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

Thanks for the help!

Kunal Kanojia

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_sqcpj8

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-desk-data-center

assets

jira-service-management-server

jira-service-management-data-center

aql