I'm looking to create a custom output element to help with our integration between Tessitura and Wordfly, and am finding all documentation in the Help system very unhelpful and feel sure someone else must have attempted this before!
The output element needs to pull the date on which a particular attribute was created - in our case, this is because we use the attribute in question in place of contact preferences, and their Tessitura preferences needs to override any that get saved in Wordfly.
I've found community posts discussing this but they all seem to date from about a decade ago, and the structure of the system tables I need to use seems to have changed significantly in that time. So if anyone has up-to-date knowledge on how to achieve this I would be very grateful.
Thanks,
Emily Johnson
Cheltenham Festivals
Hey Emily,
Go into system tables 'TR_QUERY_ELEMENT_GROUP' and search 'Attributes'.
If your 'data from' column is 'VXS_CUST_KEYWORD', then you'll be able to pull create date.
Now go to 'TR_QUERY_ELEMENT' and create a new row:
Description: Attribute Create Date
Group ID: Attributes
Data Select: create_dt
Control Group: What ever is appropriate
IMPORTANT: You will run into duplicates unless you filter the output correctly. i.e. you will see every attributes' create date on a constituent record unless you say that you only want to see attribute create dates from 'Attribute X'
You can also force it to output only one by ticking the 'Single Row' checkbox in system tables.
hopefully that should work for you!
-Brian