Performing run time lookup for a Custom EDT

(0) Share

Report

Posted on by Community Member

Hi All,

I have created a new EDT(MyEcoResCategoryHierarchyId) and attached it to a field in a table MY_EcoResCategoryHierarchy(this table is created by me).I want to perform run time lookup in a dialog on the field which is using my new EDT MyEcoResCategoryHierarchyId .I have written the below code to perform this functionality:

class LookupDialog extends RunBase
{
DialogRunbase dialog;
DialogField dialogField;

}

public Object dialog()
{
dialog = super();

dialogField = dialog.addFieldValue(extendedTypeStr(MyEcoResCategoryHierarchyId),"Category Hierarchy");
return dialog;

}

public void dialogPostRun(DialogRunbase _dialogloc)
{

super(_dialogloc);

_dialogloc.dialogForm();
_dialogloc.dialogForm().formRun().controlMethodOverload(true);
_dialogloc.dialogForm().formRun().controlMethodOverloadObject(this);
_dialogloc.formRun().controlMethodOverload(true);
_dialogloc.formRun().controlMethodOverloadObject(this);

}

public void Fld1_1_lookup()
{
Query query = new Query();
QueryBuildDataSource qbds;
SysReferenceTableLookup sysTableLookup;

FormControl frmStr = dialogField.dialog().formRun().controlCallingMethod();
sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(MY_EcoResCategoryHierarchy),frmStr);
sysTableLookup.addLookupfield(fieldNum(MY_EcoResCategoryHierarchy, Code));

query = new query();
qbds = query.addDataSource(tableNum(MY_EcoResCategoryHierarchy));
qbds.fields().addField(fieldNum(MY_EcoResCategoryHierarchy,Code));

sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();

}

static void main(Args _args)
{
LookupDialog lookupDialog = new LookupDialog();

if (lookupDialog.prompt())
{
lookupDialog.run();
}
}

If I run the above code, control is not added to the dialog,hence unable to perform lookup on the same.The dialog is opened empty.

Note: The same code is working fine if I am using a standard EDT(For example: EcoResCategoryHierarchyId in place of my new EDT).

Please help me in resolving this issue.

Regards,

Padmaja

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

LiuJie Xu 90 on at

Like (0)

Report

RE: Performing run time lookup for a Custom EDT

If you are using D365FO, I found that you need to set the "Replacement key" in table property. This will help you to add the relevent fields under the "AutoIdentification" field group. After that, it will appear in the dialog you made.
Suggested answer

Nishant2408 705 on at

Like (0)

Report

RE: Performing run time lookup for a Custom EDT

Hi Padmaja,

Code looks fine here but why is it not working that you can debug and check.

You can use the below code to fulfil your requirement as well.

class LookupDialog extends RunBase

{

DialogRunbase dialog;

DialogField dialogField;

}

public Object dialog()

{

FormStringControl control;

dialog = super();

dialogField = dialog.addFieldValue(extendedTypeStr

(MyEcoResCategoryHierarchyId),"Category Hierarchy");

control = dialogField.control();

control.registerOverrideMethod(methodStr(FormStringControl, lookup),

methodStr(LookupDialog, Fld1_1_lookup),

this);

return dialog;

}

public void Fld1_1_lookup(FormStringControl _control)

{

Query query = new Query();

QueryBuildDataSource qbds;

SysTableLookup sysTableLookup;

sysTableLookup = SysTableLookup::newParameters(tableNum

(MY_EcoResCategoryHierarchy),_control);

sysTableLookup.addLookupfield(fieldNum(MY_EcoResCategoryHierarchy, Code));

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

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

static void main(Args _args)

{

LookupDialog lookupDialog = new LookupDialog();

if (lookupDialog.prompt())

{

lookupDialog.run();

}

}
Community Member on at

Like (0)

Report

RE: Performing run time lookup for a Custom EDT

Hi,

I synchronized the data dictionary completely,cleared caches after adding the EDT.Still no luck:(

regards,

Padmaja
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Performing run time lookup for a Custom EDT

Make sure your Data Dictionary is fully synchronized after the EDT has been added.

Also you might want to use addSelectionField as well, see the example below:

parthav-dynamicsax.blogspot.hu/.../adding-lookup-method-on-form-reference.html
Mea_ 60,278 on at

Like (0)

Report

RE: Performing run time lookup for a Custom EDT

Hi Padmaja_AX,

Your code looks ok. If you are saying that it works with different EDT you can try to refresh caches from Tools -> Caches .

If this won't help you can always debug and see what exactly is wrong.