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
Hi Naomi,Here is how the tr_query_element should look for Prefix.
Data Select !.title_descData 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 blankSingle RowChecked
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!
Hi Ryan,
That worked! Thanks so much!