topic Is there a default fields return on DQL in DQL

Is there a default fields return on DQL

henk_stobbe — Tue, 16 Jul 2024 08:40:08 GMT

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

Re: Is there a default fields return on DQL

ChadTurner — Mon, 29 Sep 2025 15:17:41 GMT

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.

Re: Is there a default fields return on DQL

DanielS — Mon, 29 Sep 2025 17:05:04 GMT

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.

Re: Is there a default fields return on DQL

p_devulapalli — Tue, 30 Sep 2025 00:14:13 GMT

@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)