Lookup objects order by

[Kostiantyn Syvachenko]

Hello everyone!

The automation generates a report on laptops by stock, sending it to email as an HTML table. I need to sort it by start date. But the start date is an object in a different asset  schema - employee. An object from the Employee schema to whom the laptop was issued. The employee schema has an attribute called Start Date. I want to organize it by that.

AQL query

objectType = Laptops AND "Asset Status" IN ("In Use", "In Stock") AND Stock = "{{userInputs.Stock}}" order by Assignee."Start Date" DESC

Sorting doesn't work 

[Marc -Devoteam-]

Hi @Kostiantyn Syvachenko 

You need to use the reference name of the attribute where you access the data from the other schema

See documentation on AQL, https://support.atlassian.com/assets/docs/use-assets-query-language-aql/#Ordering 

[Kostiantyn Syvachenko]

I think that's what I do

Hardware scheme

Employee scheme

The Assignee attribute in the equipment schema is linked to the employee object. Accordingly, Assignee.Start Date

Or did I miss something?

[Marc -Devoteam-]

Hi @Kostiantyn Syvachenko 

I think this should be Employees."Start Date" or Employee.Start Date

[Kostiantyn Syvachenko]

In this case, even the Lookup objects doesn't work...

[Marc -Devoteam-]

Hi @Kostiantyn Syvachenko 

You might need to raise this with Atlassian Support, as the ordering might not be possible using object information from different schmes.

[Daniel Vest]

@Kostiantyn Syvachenko do the laptop object have the users as an Inbound or Outbound reference?

or have your tried creating a variable from the look and seeing if advance branching can help?

[Kostiantyn Syvachenko]

@Daniel Vest 

Yes, in Outbound reference. I haven't tried variables yet. I'm hoping for a simpler method))