UserName from UserInfo Table in a dialog box

Hi All,

I am trying to open a form which has a dialog box before opening a form which contains Username and Fromdate,Todate

but I want to show the UsersList in a drag down menu of that dialog field how can I do it…?

User name is not unique or not even mandatory. I would suggest using user id (the lookup will also show you the user name as well)

Okay but Iam not geting it as a drop down, please send me the code for drop down in dialog field

Are you using UserId EDT?

How you are building the dialog? If possible, show us your code…

HI Kranthi,

static void theAxapta(Args _args)
{
DialogField dialogStartDate, dialogEndDate, dialogEmpName;
Dialog dialog = new Dialog(“Month range”);
TransDate fromDate, todate;
Name empname;
dialogStartDate = dialog.addField(extendedTypeStr(TransDate));
dialogEndDate = dialog.addField(extendedTypeStr(TransDate));
dialogEmpName = dialog.addField(extendedTypeStr(Name));

dialogStartDate.label(“From Date”);
dialogEndDate.label(“To Date”);
dialogEmpName.label(“Emp Name”);

if(dialog.run())
{
fromDate = mkDate(1, mthOfYr(dialogStartDate.value()), year(dialogStartDate.value()));
toDate = (mkDate(1, (mthOfYr(dialogEndDate.value()) + 1), year(dialogEndDate.value())) - 1);
empname = dialogEmpName.value();
}
}

dialogEmpName = dialog.addField(extendedTypeStr(UserId)); // it gives the user id look up, the lookup will also have the user name.

Change it from user name to user id.

okay thanks Kranthi