topic Rename result of a DQL in DQL

Rename result of a DQL

Etienne1 — Fri, 11 Apr 2025 14:38:25 GMT

Hello,

Is it possible to rename the result of a DQL query?

I would like to display SQL instead of ‘SP00’ for example

Re: Rename result of a DQL

MaximilianoML — Fri, 11 Apr 2025 15:05:15 GMT

Hello @Etienne1

How is going? I can help you with that 🙂

You can simply add this code snippet to yours:

| fieldsAdd Name = replaceString(entityName(dt.entity.host), "SP00", "SQL") | fields arrayLast(availability), Name

and should work as you want.

Re: Rename result of a DQL

Etienne1 — Mon, 14 Apr 2025 08:26:01 GMT

Hello,

Thank you for your help.

After having tried a number of methods I can't manage to ensure that there is a single column with the name of all the renamed servers and not lots of different columns.

Example of a column I would like to have :

Host

App
SQL
Web
edit

Re: Rename result of a DQL

MaximilianoML — Mon, 14 Apr 2025 09:31:15 GMT

Hello, @Etienne1 !

Yeah, make sense, the fieldsadd creates a new Field (Column), so putting all in the same Field name as "Host", must work. But I'm not sure what you want, could you share your full example (Change the data of course), and your purpose with this query.

Best regards,

Maximiliano Lopes

Re: Rename result of a DQL

Etienne1 — Mon, 14 Apr 2025 09:39:45 GMT

Hello,

Even when I use the Fields function and not FieldsAdd, it still creates other columns

Re: Rename result of a DQL

Etienne1 — Mon, 28 Apr 2025 07:17:39 GMT

Hello,

I managed to rename my servers by parsing the tags, if that helps anyone

here is the result

Re: Rename result of a DQL

susmita_k — Thu, 14 Aug 2025 18:07:33 GMT

Is there a way to rename a field dynamically ? I am creating a comparison dashboard, and need to show the column like column_prod, column_cap. But the environment is a variable and chosen by user. I am not able to rename the column using a variable. Any help is really appreciated.