DQL - How do I enable the ability to have the record open in 'Hosts'?

[badgerfifteen]

Hi, I have made a DQL query containing disk metrics. Under the 'Host Name' column, if I navigate to either 'Open Record With' or 'Open Value with', nothing shows up. What I intend to have, is it will open up in 'Hosts' or 'Infrastructure & Operations'. Any ideas? 

[p_devulapalli]

@badgerfifteen If "dt.entity.host" is the field that you are using for Host Name you should be able to have the 'Open Record With' option enable .  Here is an example query that works for me 

timeseries avg(dt.host.disk.used.percent), by: { dt.entity.disk, dt.entity.host } 
| fieldsAdd Host = entityName(dt.entity.host), Disk = entityName(dt.entity.disk),
 Usage = arrayLast(`avg(dt.host.disk.used.percent)`)
| sort Usage desc
| limit 10

[badgerfifteen]

Interestingly, I have had a look at my code and this code here removes the ability to have the value open in 'Hosts'. If I comment it out, it works as expected. 

| fields Host, `Disk Name`, Utilisation, `Department`, Application

[TomLichti]

You have to have a field in the output that has the entity id. Add it at the end of your list of fields and 'Open With' will then work.

[Fin_Ubels · Accepted solution]

Adding on to this, you need to have that ID, but you can also hide the ID using the visualisation options but still retain the "Open With" features allowing you to create clean and functional dashboards/reports.

Showing ID is specified in the query but hidden using options on the right:

Showing "Open With" still working: