Adding New Columns to Search Keyword

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.