Hi,
I'm trying to create some output elements for the custom fields on our orders, but can't seem to figure out what table that information lives in on the database. Does anyone know where tha tinformation gets stored?
Thanks!
Ruth,
I know that TR_QUERY_ELEMENT is the System Table which holds the elements from which Output Sets can be built.
Documentation is here: http://www.tessituranetwork.com/Help_System_v125/Content/System_Tables/TR_QUERY_ELEMENT.htm
Also, TR_QUERY_ELEMENT_PARAMETER is a related System Table; documentation here: http://www.tessituranetwork.com/Help_System_v125/Content/System_Tables/TR_QUERY_ELEMENT_PARAMET.htm.
These System Tables are where our calls for, for example, our iWave integration, pulls the custom Output Set elements that are added in the integration process.
Thank you,
Brian
If you're looking for the acutal custom field information, it's stored in T_ORDER and T_KEYWORD has all the information about which field is mapped to what. If you're looking for which tables the element would get set up in those would be the ones Brian mentioned.
Yep, you are absolutely right. I was looking at the ticket history not the order, and didn't see them there.
Thanks so much!