407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 5829)

Why you cannot sort the "Description" field

This information applies to :

Article ID
5829

Created/Updated
December 3, 2014

Category
Products


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Question:
Why can't I sort the "Description" field?

Cause:
The QuoteWerks description field is a "Memo" type database field. Since, memos can contain thousands of characters of data, databases for performance reasons do not support sorting.

Solution:
You can utilize the Medic Utilitiy to Copy the first 255 characters of the Description to a CustomText field. This is accomplished from the Utilities-Data Manager for Product Databases menu. In Version 3.0 you will use the first tab and in Version 4.0 you will use the Pre-Defined Product Database Queries Tab.

New Search