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 |