Rename result of a DQL

[Etienne1]

Hello,

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

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

[MaximilianoML]

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.

[Etienne1]

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

[MaximilianoML]

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

[Etienne1]

Hello,

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