Setting Order By in Browse Dialog Search Results

Author	Message
Govinda Berrio	Govinda Berrio posted 9 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 94, Visits: 481	Hello all, I have a browse dialog that is querying on a table with 10s of thousands of records. When the user searches, with criteria selected, there are a lot of results. But, I have the Browse Dialog set to only get TOP 1000, to improve responsiveness. My intention is to have the search results return the latest records first, sorted by the added_date field. So query I would need the Browse Dialog to perform is something like this: SELECT TOP 1000 * ... ORDER BY added_date DESC When I set the sort order in the SearchFields editor, it sorts the records that it gets back from a regular query with no Order By clause, so the user is not getting the latest records. They're getting the TOP 1000 records in the order that they are in the table. When I set the BrowseDialog.OrderBy property, I can put the field there, but I can't specify "DESC"; I get the SQL error, "Invalid column name 'added_date DESC'." Could someone please help me display the latest records in the Browse Dialog. Thank You, Govinda Tags BrowseDialog
	Reply Like 1

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Govinda Berrio - 9 Years Ago

Hi Govinda, Sorry but I have not used the BD in a long time. I...

Edhy Rijo - 9 Years Ago

Hi Edhy, Thanks for the reply. I'm looking in the framework code...

Govinda Berrio - 9 Years Ago

Hi Govinda, You are welcome. I spend sometime with the BD and was...

Edhy Rijo - 9 Years Ago

That is a good strategy, Edhy, but I can't spend the time converting...

Govinda Berrio - 9 Years Ago

Hi Govinda Awesome and simple!!! Thanks for sharing this idea!!!

Edhy Rijo - 9 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login