• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 107 views
  • Users 0 members are here
Related

Output set and table data

Former Member
Former Member $organization

Hi Tessiturians,

 

I have a user who has created an output set and included among other things name 1 and name 2 prefixes. When we run the output set those fields are populated with id number instead of the description. For instance 99 John Doe, 1 Jane Doe instead of Mr. John Doe and Mrs. Jane Doe.

Any idea how to resolve this?

Thanks!

Naomi

  • $organization

    Hi Naomi,

    Here is how the tr_query_element should look for Prefix.

    Data Select
    !.title_desc
    Data From
    (select a.customer_no, b.description as title_desc from t_customer a join  tr_prefix b on a.prefix=b.id)
    For name 2 use this Data From
    (select a.customer_no, b.description as title_desc from t_customer a join tr_prefix b on a.prefix2=b.id)
    Data Where
    leave blank
    Single Row
    Checked

    And for Suffix

    Data Select
    !.suffix_desc
    Data From
    (select a.customer_no, b.description as suffix_desc from t_customer a join tr_suffix b on a.suffix=b.id)
    For name 2 use this Data From
    (select a.customer_no, b.description as suffix_desc from t_customer a join tr_suffix b on a.suffix2=b.id)
    Data Where
    leave blank
    Single Row
    Checked

    Hope this helps!

  • Former Member
    Former Member $organization in reply to Ryan Rowell

    Hi Ryan,

    That worked! Thanks so much!

    Naomi