Devart Forums

I wish sort and filter data in OraQuery dataset without full fetch. It is my old wish. You promised me think about it in the future. A lot of time has gone. Have you done something in this direction?

Hello,

For filtering and sorting, you need get all data from a corresponding field. You can use the SmartFetch mode, that retrieves data only from the needed fields when navigating through the dataset. To implement such behavior, you should set the OraQuery1.SmartFetch.Enabled property to True, and specify the fields to filter and sort by in the OraQuery1.SmartFetch.PrefetchedFields property.

Why I can't sort and filter only existing data (without more fetches)?
I have 50 fetched record in my dataset (FetchAll = False) (query like: select * from big_table) and I wish sort and filter only fetched data. If I want fetch more i'll fetch one more set of records and call sort or filer procedure again or it can work automatically but the main I wish to have opportunity to sort and filter without full fetch or additional fetches.

Currently, architecture of our components doesn't allow to add such feature "easily". You can leave your suggestion on our uservoice page: https://devart.uservoice.com/forums/104 ... 909-common . If it gets enough user votes, we will implement it.