How to retrive selective attributes from Object in Assets

Question

I have an object where it has 4 attributes. When i provided AQL for retriving the result, the result fetching all attributes of object.

Example:  Sample AQL's which i using to retriving the information

objectId(4)

Name="ITISM"

Key="ITISM-100"

Key                   Name          Updated        Created

ITISM-100         ITSIM          Date()            Date()

I want the AQL to fetch only specific columns which having the details.

Key, Name from objectId(4). I am looking this kind AQL help. Is there a way to fetch specific columns

Peter Miklian_wsipmy · Answer

There’s a feature request for returning only selected asset attributes in REST API reply, you can vote 
" title=":wink: " width="20" height="20" />

Assets public API returns selected object attributes [JSDCLOUD-11464]

Dharma Teja _Appfire_ · Answer

Hi @Kris Dewachter :- Thanks for the input. We actually implemented some UI to user provide AQL query language, where we can process it using Assets rest API's and share the result with customer.

I just expected that, is there any other way to get specific columns from object. But as you confirmed it, there is no way to do with Assets. Thank for clarification.

Can i have AQL realtime samples or videos on how to use Functions and

Reference functions

I was following this doc https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/, but good to have some realtime scenario session video's.

Kris Dewachter · Answer

Hi @Dharma Teja _Appfire_ ,

Where are you using this AQL ?

There is no way to specify specific columns (like you can in sql). You can change your view to display the columns you need.

Best regards,

Kris