customize lookup for Unbound Int64 formcontrol

(0) Share

Report

Posted on by Rohin

4,624

Hi ,

I have a form without datasource having two unbound form control. One is Base enum type and other is Int64 type(DirPartyRecId).

I had customized Lookup on form (by overriding Lookup method) like below:

public void lookup()
{
// super();
SysTableLookup sysTableLookup;
Query query = new Query();
QueryBuildDataSource qbds;
;

sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker),this);
sysTableLookup.addLookupfield(fieldNum(HcmWorker,Person));
sysTableLookup.addLookupfield(fieldNum(HcmWorker,PersonnelNumber));
qbds = query.addDataSource(tableNum(HcmWorker));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

and lookup is showing correct (showing employee Name) but when i select any employee from lookup , it get RecID :

6175.Capture.PNG

I want it shows Employee name here . please suggest me

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Visvash Walia,

You can either add string as a second field( instead of recId) and store employee Name there or you need to use "Reference Group" instead of Int64 , please read this blog for details natepaine.blogspot.co.nz/.../ax-2012-unbound-recid-lookup.html

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Hi Ievgen,

I tried your link , but its giving below error while lookup field:

I have changed lookup method of reference group as below:

public void lookup()
{
// super();
SysReferenceTableLookup sysTableLookup;
Query query = new Query();
QueryBuildDataSource qbds;
;

sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(HcmWorker),this);
sysTableLookup.addLookupfield(fieldNum(HcmWorker,Person));
sysTableLookup.addLookupfield(fieldNum(HcmWorker,PersonnelNumber));
qbds = query.addDataSource(tableNum(HcmWorker));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}

Please suggest

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

Hello Crispin,

I tried your way , but not works.

Was this reply helpful? Yes No
Verified answer

Rohin 4,624 on at

Like (0)

Report

I resolved this issue by changing below code :

public void lookup()

{

SysReferenceTableLookup tablelookup;

Query query = new Query();

QueryBuildDataSource qbds;

QueryBuildDataSource qbds1;

;

tablelookup = SysReferenceTableLookup::newParameters(tableNum(DirPartyTable),this);

tablelookup.addLookupfield(fieldNum(DirPartyTable,Name));

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

qbds1 = qbds.addDataSource(tableNum(HcmWorker));

qbds1.relations(true);

tablelookup.parmQuery(query);

tablelookup.performFormLookup();

// super();

}

But i would appreciate your suggestion on this , if you have better solution most welcome :)

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

I am closing this thread by verified answer. I think this only the solution but most welcome for any suggestion.

Was this reply helpful? Yes No

Community site session details

customize lookup for Unbound Int64 formcontrol

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

customize lookup for Unbound Int64 formcontrol

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates