SQL code for phone number in flex header?

Tyler Kubat $organization over 5 years ago

Hello!

Subject explains it. No one at our organization is particularly well versed in SQL. We'd like to remove email addresses from our pop-up and flex headers and add in phone numbers instead. Everything we try just ends with an error. Does anyone have a quick formula or easy way to implement this change?

Thanks in advance for your help!

-Tyler
Patron Services Manager
Broadway Rose Theatre Company

Parents

Heath Wilder $organization over 5 years ago
Hi Tyler,

In TR_FLEX_HEADER_ELEMENT My phone element is

Type: String

Description: Phone

Sql Code: select top 1 p.phone from T_PHONE p Where customer_no = @customer_no

I think that's all you need. From there you can pop it into TR_FLEX_HEADER and go for it
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Heath Wilder $organization over 5 years ago
Hi Tyler,

In TR_FLEX_HEADER_ELEMENT My phone element is

Type: String

Description: Phone

Sql Code: select top 1 p.phone from T_PHONE p Where customer_no = @customer_no

I think that's all you need. From there you can pop it into TR_FLEX_HEADER and go for it
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data