完整文本搜索索引的脚本

如果在完整文本索引表单上选择 应用脚本,系统会应用脚本为应用程序创建一些初始的完整文本索引。

该脚本定义了以下完整文本搜索索引:

目录项名称 表单 标题列名称 说明列名称
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