Asset Compare dates in 2 attributes

[Michael Frade]

Trying to sync up 2 date attributes in different Object types.  Want to find the ones that do not match.  Object type A has Refresh date attribute and Object type B has End date attribute. Object type A references Object type B thru an attribute in A called Model.  Tried doing "Model"."End Date" != "Refresh Date" and it is not working. Still getting object that have matching dates. 

Any tips?

[Michael Frade]

Reached out to Atlassian Support and it seems this is not currently possible. Made a sync date attribute which gets populated in the automation and the query checks if that date is past a 1 week for it to try and run on that object.  It gets me by for now.

[Trudy Claspill]

Hello @Michael Frade 

Where are you trying to use that comparison? An automation rule? A search?

[Michael Frade]

It would be in a Branch AQL component in automation but testing the AQL query in the filter in Assets itself as I was not getting the desired results. It's the same in both places,  I am getting results where the dates do match.

[Trudy Claspill]

At the moment I'm stumped, but I'm going to keep working on it...

I get the same results as you.

[Bill Sheboy]

Hi @Michael Frade and @Trudy Claspill 

I do not believe that is possible with the built-in features of AQL: as with JQL, the left-side of an expression must be a field / attribute and not the value of one.

What do you want to do when a match to the condition is found?  Knowing that may suggest alternatives.

Kind regards,
Bill

[Michael Frade]

I got it to populate the destination attribute with each respective date. I'm looking to have it only run if there is a change and the dates do no longer match. At this point it continues to run for all the objects.

Back up plan is to switch it to a schedule to run like once every couple weeks or something vs when objects update.

[Trudy Claspill]

Can you share with us the rule you have constructed?

Which date change are you monitoring for; Refresh date or End date or both?

Do you want to update Refresh date when End date changes, or vice versa?

Is the Model attribute limited to selecting one Object B, or does it support selecting multiple Object B's?

Can an Object B be referenced by more than one Object A?

[Michael Frade]

Right now it is a scheduled trigger but looking to change it to update object trigger.

Then it goes into a branch Aql where it is looking for all the objects in Object type A. ( here is were I would like to be able to excluded the ones where attribute in A and attribute in B match.)

then it would go into an edit object attribute where it is updating Object type A refresh date based on the Model.End of Support date.

Refresh date is what needs to get updated when Object type A is updated 

Model  can be in multiple objects in Object type A but each object would have only one value in Model attribute

Object type B would be referenced by more than one object type A.

Hope that helps. Thanks for the interest