| Hi Ursi,
I assume you want to include the field COMPANY from PROFIL into the
displayed line from EMSADD. By entering
<for OA$MAIL_ADD_ADDR do get .%whole
you will see that no value for company appears in the output but there
are some fields containing phone numbers, initials, job title and
location.
Unfortunatly you cannot supply a list of functions to be performed by
the FOR function on a select form, so the following will not work:
;;.TYPE;;
SELECT FOR PROFIL WITH .OA$MAIL_ADD_ADDR WITH .USER = #EMDADDRESS
DO GET #X=.USER \SEL_CHOICE OA$SEL_LINE:2 " " .USER:18 " "
.ORGUNIT1:25 " ( " .FULNAM:15 " ) " PROFIL.COMPANY[#X]
But you can set OA$DDS_PRIME to 2 and then you can modify the layout of
DDS$INDEX in order to display the fields the customer wants to.
Stefan
|
| Hi Stefan
Fortunately OA$DDS_PRIME is 2.
But there are two ways to get a receipient:
I stay in EMHEAD and like to get some receipients:
1. If I enter the full name like ERNI, the form --> EMSDDS <-- tells me
the selection. (EMSDDS makes a FOR-loop through a phantom dataset of
--> SUBSCRIBER <--)
2. If I just enter E, the form --> EMSADD <-- wants to tell me further
information. (EMSADD makes a FOR-loop through
--> OA$MAIL_ADD_ADDR <--)
Your tip to get the whole record with .%WHOLE showed me that
OA$MAIL_ADD_ADDR will never give me the information of company. Now
your idea using profil is not bad. I tried it this way:
SELECT FOR OA$MAIL_ADD_ADDR WITH .USER = #EMDADDRESS
DO SEL_CHOICE OA$SEL_LINE:2 " " .USER:15 " " .ORGUNIT1:15 " "
PROFIL.COMPANY:15[.USER] " ( " .FULNAM:18 " )"
^^^^^
But what if some records are in profile only and some are in DDS. I do
also need to search through OA$MAIL_ADD_ADDR because of nicknames and
distribution-lists.
Is there any hope to get OA$MAIL_ADD_ADDR extended by the field
COMPANY ???
Ursi
|