Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

relative date doesn't work for Asset date attribute

YY哥 Yang December 4, 2022

Hi,

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

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

 

image.png

2 answers

0 votes
Pascal Hamar
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 17, 2023

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

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

0 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 4, 2022

@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 December 4, 2022

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

Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 4, 2022

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

Best, Joseph

Yong December 5, 2022

no record returned.

Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 7, 2022

 "Next Charge Date" is a custom field from JSM?

Yong December 8, 2022

No,  "Next Charge Date" is an Asset CMDB attribute, but not jira custom fields.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events