By default records are sorted in descending order by RECORD_TYPE and in ascending order by CUSTOMER_NAME.
To change the sorting rules:
1. Modify the following code snippet in the below mentioned stored procedures.
FROM
dbo.USERACH_CUSTOMER AS C
ORDER BY
C.RECORD_TYPE DESC
, C.CUSTOMER_NAME
Stored Procedures:
· USEARCH_EXPORT_CUSTOMER_LIST
· USEARCH_EXPORT_CUSTOMER_SEARCH
· USEARCH_EXPORT_CUSTOMER_DETAIL
2. Delete all files in the following folders:
\\UNC_PATH\detail\
\\UNC_PATH\detail
3. Execute the SQL Job to generate new search and detail files.