The marketing folks want to be able to extract mobile phone numbers in order to send out SMS updates to members. We're still in version 11, and will be until version 12.5 comes out.
I'm looking for suggestions about doing this in version 11.
And is anybody doing this in version 12?
Hi Steven,
An output set I think would be ideal for them.
Assuming you have mobile numbers entered against a mobile number *type* from TR_PHONE_TYPE, here are the values you can enter in TR_QUERY_ELEMENT:
Description - Mobile Phone No
Category - Address
Data Select - max(phone)
Data from - t_phone
Data where - type = # (# being the ID in TR_PHONE_TYPE relating to mobile numbers)
Single Row - Y
Hope this helps.
Cheers,
Kevin
Hi Steven, An output set I think would be ideal for them. Assuming you have mobile numbers entered against a mobile number *type* from TR_PHONE_TYPE, here are the values you can enter in TR_QUERY_ELEMENT: Description - Mobile Phone No Category - Address Data Select - max(phone) Data from - t_phone Data where - type = # (# being the ID in TR_PHONE_TYPE relating to mobile numbers) Single Row - Y Hope this helps. Cheers, Kevin From: Steven Hanks <bounce-stevenhanks7046@tessituranetwork.com> Sent: 1/3/2014 5:07:50 PMThe marketing folks want to be able to extract mobile phone numbers in order to send out SMS updates to members. We're still in version 11, and will be until version 12.5 comes out. I'm looking for suggestions about doing this in version 11. And is anybody doing this in version 12? --View this message online at http://www.tessituranetwork.com/Community/forums/p/10733/33199.aspx#33199 or reply to this message Steven HanksDatabase Administrator Information ServicesThe Tech Museum of Innovation 201 South Market StreetSan Jose, CA 95113 +1 (408) 795-6117shanks@thetech.org www.thetech.org Visit: thetech.orgLike: facebook.com/TheTechMuseum Follow: twitter.com/#!/TheTechMuseum
From: Steven Hanks <bounce-stevenhanks7046@tessituranetwork.com> Sent: 1/3/2014 5:07:50 PM
Visit: thetech.org
Like: facebook.com/TheTechMuseum
Follow: twitter.com/#!/TheTechMuseum