Search option is not working in Query History

[Susja]

Select Topic Area

Question

Body

Hello,
I started to use VS Code. I installed mssql extension 1.28.0. I am interested in running SQL queries.
I do have a list of queries in 'history' panel, but I can't search in it. I click on Ctrl+F but dialog box for search does not open.
Is it known issue or my configuration issue?

Thanks

[Susja]

I noticed this error when click Ctrl+F:
Error running command mssql.openQueryHistory: Cannot read properties of undefined (reading 'credentials'). This is likely caused by the extension that contributes mssql.openQueryHistor

[Bobston01]

The issue you’re experiencing with search not working in the Query History panel in VS Code (mssql extension 1.28.0) could be due to the following reasons:

Possible Causes & Solutions:

1. Search Functionality Not Available in Query History

   • As of now, the mssql extension does not support searching within the Query History panel using Ctrl + F.
   • The search feature (Ctrl + F) works in the editor window, but not in panels like Query History.

2. Workaround: Copy History to a New File

   • If you need to search within your query history, do the following:
     1. Click the Query History panel.
     2. Select all (Ctrl + A) and copy the history (Ctrl + C).
     3. Open a new file in VS Code (Ctrl + N).
     4. Paste the copied queries and use Ctrl + F to search.

3. Check Keybinding Conflicts

   • Sometimes, Ctrl + F might be overridden by another extension or VS Code’s default settings.
   • To check:
     • Go to File → Preferences → Keyboard Shortcuts (Ctrl + K, Ctrl + S).
     • Search for Ctrl + F and see if any conflicting keybindings exist.

4. Try Searching via Output Panel

   • Instead of Query History, open the Output Panel:
     • Press Ctrl + Shift + U and select SQLTools from the dropdown.
     • If your queries are logged here, you can use Ctrl + F to search.

5. Consider Using SQL Server Management Studio (SSMS)

   • If searching query history is essential for your workflow, SQL Server Management Studio (SSMS) provides better query history and search functionalities.

Would you like guidance on submitting a feature request for this? 😊

[Susja]

@Bobston01 - Thanks for detailed explanation and reply.
I tried all your suggestions ... but none of it worked for me ..
Finally I found acceptable workaround for me: I open command pallet Ctrl+Shift+P; type 'query history'; select from drop-down "MS SQL: Open History in Command Palette". Here I could search by typing keyword.
Well, it's not as straightforward and I used to have it in ADS ... but still acceptable for me.
Appreciate your input