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

relative date doesn't work for Asset date attribute

YY哥 Yang

Hi,

The below AQL returns empty, which is out of my expectation. Anyone knows the reason?

objectType = "SaaS 软件" AND "Next Charge Date" < 2w

Accepted answers

All comments

Joseph Chung Yin

@YY哥 Yang -

Welcome to the community. Are you trying to obtain object data which are 2 week ago? If so, please try "-2w".

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Yong Yang_sxvxir

I query which objects will be due/expired in 2 weeks.

Joseph Chung Yin

Did -2w in AQL returned any record for you?

Best, Joseph

Yong Yang_sxvxir

no record returned.

Pascal Hamar

I don't know exactly but maybe this AQL works for your case:

objectType = "SaaS 软件" AND "Next Charge Date" < now(-2w)

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management