AX / D365FO – Custom lookup on UserInfo – Want Id for form filter but display Name

I have a form with a string field. In this field I want to display a lookup with the users of my organization (userid and display name). When I select a user I want to save the user’s display name in the form field.

Override the form field’s lookup() method with this code

public void lookup()

{

    //super();

    Query                   query;

    QueryBuildDataSource    qbds;

    SysTableLookup          lookup;

    query = new Query();

    qbds = query.addDataSource(tableNum(UserInfo));

    lookup = SysTableLookup::newParameters(tableNum(UserInfo), this);

    lookup.parmQuery(query);

    lookup.addLookupfield(fieldNum(UserInfo, Name),true);//Add it here

    lookup.addLookupfield(fieldNum(UserInfo, Id));//Remove True parameter from ID field & add it to Name field

    lookup.performFormLookup();

}

Leave a comment