Saving title menu filter settings when refreshing underlying dataset

Stephen Everington

June 12, 2019 09:14

Hi,

Is there a way to save / retain / re-instate a filter set at runtime using the titlemenu filter whilst performing a refresh of the dataset?

I am running Delphi 10.3, Infopower VCL 4K 20.0.2.3. The dataset is an ADOQuery which, currently, I am refreshing by closing & re-opening.

Thanks

Steve Everington

0

Comments

4 comments

Roy Woll

June 20, 2019 00:52
I'm sorry for the late response. I overlooked this message. Are you saying you are closing and opening the query and it is not keeping the filter? What do you mean by a refresh of the dataset?
0

Comment actions Permalink
Stephen Everington

June 20, 2019 06:51
HI Roy,

Steps are as follows:

Application runs query & presents data to user.in a grid

User sets their own filter(s) etc via the title menus on the grid

User (or other users) carry out actions that changes data on server.

User now wants to update(refresh) the data in their grid without loosing their filter(s) to reflect changes.

The data is held in SQL server and I am using an ADOQuery to retrieve it. My understanding is that I need to close and re-open the ADOQuery to "refresh" the data. It is at this point that the filters are lost so I am hoping that there is a way of saving them prior to the close/re-open of the query so I can re-apply them afterwards.
0

Comment actions Permalink
Sven

December 20, 2022 15:49

Edited
Hello,

This post is quite old, but I have a similar problem when (re)loading the data into the dataset. How can the title-menu-filters be saved?
0

Comment actions Permalink
Stephen Everington

December 22, 2022 07:58
Hi Sven,

Sorry, but I never got an answer to this issue. I think I gave up on the saving of the filters and just made it much clearer that when the dataset was refreshed the filters etc would be lost.
0

Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk