• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 37 views
  • Users 0 members are here
Related

Custom Built Tables in List Builder

Matt Gonzales
$organization

Assuming it's possible, is it very involved to make custom-built tables in Tessitura available to List Builder for user-defined lists based on said tables?

Thanks, Tessiturians.

Bonus Trivia: The stomach of a hippopotamus is ten feet long.

  • $organization

    Hi Matt,

    Yes you can create List items using local tables, and it's not too difficult.

    In system table T_Keyword add a row for each item that you'd like to use in a List builder query. The columns I filled in to get this to work are:

    Description (name of list builder item)
    Data type
    Detail TBL (name of local table)
    Detail Col (table column with a !. in front of the name)

    Ref Tbl
    Ref IDCol    (these are only needed to construct the dropdown's in list builder)
    Ref Desccol
    Ref Where

    Category (which part you'd like the items to appear in list builder)
    Use For List (select List Only, if that's what you need)

     

    If you like I can paste in an example of my T_Keyword table showing my custom tables used in list builder.

    HTH

    David