We're having a devil of a time getting WordFly set up in our v14 TEST server. Can someone please explain (to someone who's never done it before) what it means to "Register LT_WF_ABANDONED_CART table with Query Builder so that it can be used when building output sets"? Is Query Builder a module within Tessitura or a program like Report Setup? I've never used Output Set Builder before being that I'm the DBA and I just run queries in SSMS so none of this sounds familiar to me.
Appreciate the help, Tessiturians.
Hi Matt
On Version 14 these have changed a little bit and are a little easier to set up. Haven;t used Wordfly's abandoned cart setup so my knowledge on that is limited.
The query element (output set) tables are in System Tables
You will need to add LT_WF_ABANDONED_CART to the table TR_QUERY_ELEMENT_GROUP, in your case I believe you will just need to add a description and then LT_WF_ABANDONED_CART goes into data_from as I am assuming you won't need to filter the data further using the data_where column
My pre-show and post show emails for both my theatres run from the same view so I use the data_where column to filter for each email
Once you have done that take note of the id if you are doing this direct in SSMS, if you are using system tables then it will give you a dropdown for that column.
Now you add the columns you need to TR_QUERY_ELEMENT, this is similar to adding list items to T_Keyword.
Here is how my pre show elements show in system tables in the client
and how it looks in SSMS
Hope that helps
Mark