I've been going through documentation about the Product Search function in House View but have had no luck finding the info I need.
In the Product Search feature you can search by Text. I found documentation saying that " 800x600 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 This field is used to perform a full-text search on a full-text index built of data from titles, productions, performances." But I can't figure out where this full-text index lives. And I haven't been able to successfully get any results from any text search that I've tried.
Does anyone know where this index lives? Or at least how I can utilize this function properly?
Thanks!
Hi Beth,
The information you are looking for is in the Performance Setup document. Here’s the relevant excerpt:
In order for the full-text product search feature to include new performances, the TP_POPULATE_FULLTEXT procedure must be run. This procedure populates a column in T_INVENTORY with some common data from the title, production and performance tables. The procedure should be scheduled to run on a regular basis. Custom data can also be included in the index by customizing the LP_POPULATE_FULLTEXT procedure, which is referenced by the TP_POPULATE_FULLTEXT procedure. For more details see the Localized Procedures document.
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Excellent!! The info I need is always in the last place I forget to look. :)
Kevin, you rock!!