9

In the Azure Kusto query system, I can add columns by manually typing them in using project :

AzureDiagnostics
| project TimeGenerated, httpMethod_s

or by selecting them with the "columns" button:

enter image description here

But when I select the columns I want visually, the query does not get updated and if I save the query, the choice of columns is not saved.

How can I update the query text to include the columns I've just selected?

Improve this question
3
  • You select/include columns with “project” (, which you already state so I don’t fully understand your problem/question? (Project Timegenerated,httpmethod_s,OperationName, Category
    – Jarnstrom
    Commented Aug 30, 2019 at 7:11
  • @Jarnstrom If I adjust the list of columns using the visual selector, the query text does not get updated. Is there any way to update the query to match what has been selected?
    – Glen Little
    Commented Aug 31, 2019 at 16:21
  • It's a microsoft product. The behavior you describe, Glen, would be intuitive. The two will never match
    – aaaaaa
    Commented Apr 6, 2023 at 23:17

1 Answer 1

Reset to default
8

You have to specify the columns you want in the query, like I have done on the last line below.

[AzureDiagnostics
| where ResourceProvider =="MICROSOFT.DBFORPOSTGRESQL" 
| where Category == "PostgreSQLLogs"
and not (Message contains "connection")
and not (Message contains "does not exist") 
 | sort by TimeGenerated desc
 | project TimeGenerated, Message
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .