Script for Full-TextSearch Indexing

If you select Apply Script on the Full-Text Indexing form, a script is applied that creates some initial full-text indexes for the application.

These full-text search indexes are defined by the script:

Catalog Item Name Table Column Form Title Column Name Description Column Name
CustomerInternalEmail custaddr internal_email_addr Customers internal_email_addr name
CustomerName custaddr name Customers external_email_addr name
CustomerFax custaddr fax_num Customers fax_num name
CustomerNum custaddr cust_num Customers cust_num name
CustomerState custaddr state Customers state name
CustomerZip custaddr zip Customers zip name
CustomerOrderContact customer contact##1 Customers contact##1 cust_num
CustomerOrderContactPhone customer phone##1 Customers phone##1 cust_num
CustomerCounty custaddr county Customers county name
CustomerAddress[1] custaddr addr##1 Customers addr##1 name
CustomerAddress[2] custaddr addr##2 Customers addr##2 name
CustomerAddress[3] custaddr addr##3 Customers addr##3 name
CustomerAddress[4] custaddr addr##4 Customers addr##4 name
CustomerBillingContact customer contact##3 Customers contact##3 cust_num
CustomerContactPhone customer phone##2 Customers phone##2 cust_num
CustomerCountry custaddr country Customers country name
CustomerBillingContactPhone customer phone##3 Customers phone##3 cust_num
CustomerContact customer contact##2 Customers contact##2 cust_num
EmployeeNum employee emp_num Employees emp_num name
EmployeeName employee name Employees name emp_num
EmployeeEmail employee email_addr Employees email_addr name
ItemOverview item overview Items description overview
ItemNum item item Items item description
ItemName item description Items description description
ProspectNum prospect prospect_id Prospects prospect_id company
ProspectCompany prospect company Prospects company prospect_id
VendorNum vendaddr vend_num Vendors vendaddr name
VendorName vendaddr name Vendors vendaddr vend_num
VendorZip vendaddr zip Vendors zip name
VendorState vendaddr state Vendors state name
VendorCounty vendaddr county Vendors county name
VendorCountry vendaddr country Vendors country name
VendorInternalEmail vendaddr internal_email_addr Vendors internal_email_addr name
VendorExternalEmail vendaddr external_email_addr Vendors external_email_addr name