Get Prefix description in an output set instead of the ID number

Elizabeth Carlock (Past Member) $organization over 13 years ago

This seems like it should be an easy fix but I'm not sure how to wrap my head around it. Is there a way to update the Customer Prefix query element so that it will disply the description of the Prefix and not the ID number? Customer Prefix is pulled from one of those special tables and I'm not sure if I can modify the element. And I'm not sure how diffcult a new element would be to create.

Thanks in advance for suggestions.

Elizabeth Carlock

Parents

Paul Kappel $organization over 13 years ago

Hey Elizabeth,

It should be pretty easy to set up a new row in TR_QUERY_ELEMENT, we use:

Data Select: !.prefix_desc
Data From: (select c.customer_no, p.description as prefix_desc from t_customer c join tr_prefix p on c.prefix=p.id)
Data Where: blank
Single Row: Check
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Paul Kappel $organization over 13 years ago

Hey Elizabeth,

It should be pretty easy to set up a new row in TR_QUERY_ELEMENT, we use:

Data Select: !.prefix_desc
Data From: (select c.customer_no, p.description as prefix_desc from t_customer c join tr_prefix p on c.prefix=p.id)
Data Where: blank
Single Row: Check
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data