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