6

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?

Glen Little
  • 455
  • 3
  • 7
  • 17
  • 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 Aug 30 '19 at 07: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 Aug 31 '19 at 16:21
  • It's a microsoft product. The behavior you describe, Glen, would be intuitive. The two will never match – aaaaaa Apr 06 '23 at 23:17

1 Answers1

6

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
screig
  • 161
  • 1
  • 4