The “XML Format for Search File” section lists the columns a user can search to the detail file. You can add new columns to this by completing the steps below.
To add new columns to search keyword:
1. Add a column in the appropriate USEARCH related table.
2. Add code for the new column in the USEARCH_INSERT_DATA stored procedure.
3. Add a code section for Insert in to temporary table #CUSTOMER_SEARCH in the USEARCH_EXPORT_CUSTOMER_SEARCH stored procedure.
4. Delete all files in the following folder:
\\UNC_PATH\detail\
5. Execute the SQL Job to generate new detail files.