Output sets allow users to return specific elements associated with constituents when viewing a list. These can be used as an easy custom reporting mechanism and there are lots of fields already available. This guide will show how to add additional output elements if something is not already available or if there is a customization that needs to be included.

This is based on the documentation from Tessitura here: https://docs.tessitura.com/Help_System_v160/Tables/TR_QUERY_ELEMENT.htm

Intended Audience

Tessitura admins

Step-by-step guide

This guide will create output elements for custom room charge data. See How to add list criteria for how to create the list criteria and view.


To make an output element:

  1. Make sure the output element does not already exist.
    1. Search for the element in Output Elements (TR_QUERY_ELEMENT)
  2. Determine if there is a table or view that can be used.
    1. If not, create a view containing a customer_no column and the elements needed. See How to add list criteria for an example.
  3. Determine if an appropriate group exists.
    1. Search Output Element Groups (TR_QUERY_ELEMENT_GROUP)
    2. If not, create a group. https://docs.tessitura.com/Help_System_v160/Tables/TR_QUERY_ELEMENT_GROUP.htm
  4. Add a row into TR_QUERY_ELEMENT for each desired element.
    1. In this case, we will add a row for each field in the view created to give as much information about room charges as possible.

  5. Once saved, these output elements should be available for selection.




Content by label

There is no content with the specified labels