SQLTools extension fails to populate Query History

[Susja]

Select Topic Area

Question

Body

I am using mssql and sqltools extensions in VS Code 1.97.2
When I use mssql .. after I execute any sql query .. I see that it was added to Panel 'Query History'.
When I SQLTools extension with driver 'SQLTools MSSQL/Azure+ Driver' .. Panel 'Query History' is not populating.

To Reproduce
Steps to reproduce the behavior:

Go to VS Code
Click on Connection for SQLTools
Select any connection to database and click on icon 'New SQL file'
Execute query
Note that 'Query History' Panel was not populated
Expected behavior
After each SQL query execution ... Query History should be updated

Desktop
SQLTools Version 0.28.4
VS Code Version: 1.97.2
OS: [Windows
Driver:
SQLTools MSSQL/Azure+ Driver 0.6.2
Database version: MS SQL 15.0.4390.2
Additional context
It has no issue when instead of SQLTools I use MSSQL extension.

[Raymond-Ly]

1. Check SQLTools Settings
2. Open VS Code settings (Ctrl + , or Cmd + , on Mac).
3. Search for sqltools.history and ensure that query history is enabled.
4. If no relevant setting is found, SQLTools may not natively support query history logging.

Alternative you can try https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql

[Susja]

Hi @Raymond-Ly - thanks for fast response.
I checked that for mssql I do have this option is settings files:
"mssql.enableQueryHistoryCapture": true, -> in file ...AppData\Roaming\Code\User\settings.json

and
"mssql.enableQueryHistoryCapture": true, -> in file \defaultSettings.json
"mssql.enableQueryHistoryFeature": true,

Note: when I use mssql ... I do have Query History populated but when I use SQLTool .. the Query History is empty.
Do you think I should manually add those features to settings files?
Thanks