Unable to filter Result grid in ADS

Voldman, Eliya 20

I have an issue with using 'filter' in Result Grid for big number of records.

E.g. when I select e.g. 50K records ... everything works fine. When I select 100K records ..and click on down arrow (filter) it shows me the records ... I could select one record but it does not filter it out. And if I select e.g. 200K records .. it doesn't even open a list when I click on filter.

Hence, my assumption is that it's related to memory management on my server. I tried to contract GitHub ... but no luck with response. It significantly impact my work because every time I have to export Result Set and analyze it outside of ADS. I have the same issue on 2 computers: Windows 10 running on PC and Windows Server 2019.

I am running:

Version: 1.50.0 (system setup)

Commit: 49c73a84388731fec941dac8d938345ac16bd470

Date: 2024-11-17T22:41:05.327Z

VS Code: 1.82.0

Electron: 30.5.1

Chromium: 124.0.6367.243

Node.js: 20.16.0

V8: 12.4.254.20-electron.0

OS: Windows_NT x64 10.0.17763

RAM is 8 Gb and a lot of virtual memory.

I set this field: Query Editor › Results: In Memory Data Processing Threshold 99999999

It didn't help.

Any help would be appreciated ... because it impacts my daily business and export results every time is not convenient thing ..

Sai Raghunadh M 2,230 Reputation points Microsoft Vendor

2025-01-27T02:48:21.06+00:00

Hi @Voldman, Eliya

Thank for the Question and using Microsoft Q&A

Have you checked this similar thread?

https://learn.microsoft.com/en-us/answers/questions/1514691/filter-results-in-ads-does-not-work
Sai Raghunadh M 2,230 Reputation points Microsoft Vendor

2025-01-28T03:54:00.45+00:00

Hi @Voldman, Eliya

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 2,230 Reputation points Microsoft Vendor

2025-01-29T03:43:35.2166667+00:00

Hi @Voldman, Eliya

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Voldman, Eliya 20 Reputation points

2025-01-30T15:41:38.3333333+00:00
@Sai Raghunadh M -- sorry Folks, I have an issue with email notification. I did everything I could, but I don't get notified. Hence, I did not see your response. I noticed it accidentally when explicitly open this thread ... apologies for that.

I will follow the link you provided and will update you ..

Thanks
Voldman, Eliya 20 Reputation points

2025-01-30T16:19:23.1166667+00:00

@Sai Raghunadh M I checked the link you provided. That thread was opened by me a year ago. I followed the recommendation last year and opened an issue in https://github.com/microsoft/azuredatastudio/issues but no activity to resolve it.

Thanks
Sai Raghunadh M 2,230 Reputation points Microsoft Vendor

2025-01-31T01:37:06.2966667+00:00

Hi @Voldman, Eliya

Could you kindly attempt to post the issue on the GitHub forum once more?
Voldman, Eliya 20 Reputation points

2025-01-31T15:40:34.9533333+00:00

@Sai Raghunadh M I opened a new issue #26167
Sai Raghunadh M 2,230 Reputation points Microsoft Vendor

2025-02-03T02:28:56.2666667+00:00

Hi @Voldman, Eliya
Thankyou.

Share via

Unable to filter Result grid in ADS

Your answer