https://community.dynatrace.com/t5/DQL/Order-of-columns/m-p/213676#M13 <P>Hi Stefan,</P> <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">the<SPAN>&nbsp;</SPAN><CODE class="c-mrkdwn__code" data-stringify-type="code">fields</CODE> command can be used to set the order of the fields. Please have a look at the following sample</DIV> <DIV class="p-rich_text_section"><LI-CODE lang="markup">fetch logs | fields timestamp, log.source, content</LI-CODE></DIV> <DIV class="p-rich_text_section">With the fields command you not only specify which fields should be displayed, but also its order. So you need to specify all fields which you want to be visible&nbsp;</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">For further info, please have a look at the documentation of the command:&nbsp;<A href="https://www.dynatrace.com/support/help/shortlink/dql-commands#fields" target="_blank" rel="noopener">https://www.dynatrace.com/support/help/shortlink/dql-commands#fields</A></DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--light c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">&nbsp;</DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--light c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">Best,<BR />Sini</DIV> Thu, 01 Jun 2023 14:39:58 GMT sinisa_zubic 2023-06-01T14:39:58Z https://community.dynatrace.com/t5/DQL/Order-of-columns/m-p/213654#M1 <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">Can we set the order of columns?</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">I want following order in the table:</DIV> <UL> <LI class="p-rich_text_section">timestamp</LI> <LI class="p-rich_text_section">log.source</LI> <LI class="p-rich_text_section">then the column order can be random</LI> </UL> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-files_container" role="none"> <DIV class="c-message_kit__file__meta">&nbsp;</DIV> </DIV> Wed, 31 May 2023 13:38:53 GMT https://community.dynatrace.com/t5/DQL/Order-of-columns/m-p/213654#M1 stefan_eggersto 2023-05-31T13:38:53Z https://community.dynatrace.com/t5/DQL/Order-of-columns/m-p/213676#M13 <P>Hi Stefan,</P> <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">the<SPAN>&nbsp;</SPAN><CODE class="c-mrkdwn__code" data-stringify-type="code">fields</CODE> command can be used to set the order of the fields. Please have a look at the following sample</DIV> <DIV class="p-rich_text_section"><LI-CODE lang="markup">fetch logs | fields timestamp, log.source, content</LI-CODE></DIV> <DIV class="p-rich_text_section">With the fields command you not only specify which fields should be displayed, but also its order. So you need to specify all fields which you want to be visible&nbsp;</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">For further info, please have a look at the documentation of the command:&nbsp;<A href="https://www.dynatrace.com/support/help/shortlink/dql-commands#fields" target="_blank" rel="noopener">https://www.dynatrace.com/support/help/shortlink/dql-commands#fields</A></DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--light c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">&nbsp;</DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--light c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">Best,<BR />Sini</DIV> Thu, 01 Jun 2023 14:39:58 GMT https://community.dynatrace.com/t5/DQL/Order-of-columns/m-p/213676#M13 sinisa_zubic 2023-06-01T14:39:58Z