Is there a default fields return on DQL

[henk_stobbe]

Hello,

Sometimes I need to do a Fieldsadd, to get extra fields from my query. So I assume there are default fetched fields, and extra?

Who can enlighten me?

KR Henk

[ChadTurner]

I don't think there is a repo for all the fields present. What I typically do is pull an API call form the target entities and extract the metadata so I can then add in all the desired fields for the ADD Command. 

[DanielS]

Hi @henk_stobbe what I do is to click on options and then I see the Visibility and order section under Columns. For me is the easy way to verify all fields returned.

[p_devulapalli · Accepted solution]

@henk_stobbe You can use the describe to extract the fields that are available for a data object

https://docs.dynatrace.com/docs/shortlink/data-source-commands#describe

From what I understand if you run a fetch against an object like "fetch dt.entity.host" or "dt.entity.kubernetes_cluster" it would by default fetch the entity.name and id fields . If you need the additional fields extracted , we would do a fieldsAdd of the needed fields . 

I guess this is to ensures that only the most needed info is included in the initial query results, reducing unnecessary data transfer and to improve query performance ( Just my understanding, not a official DT statement)