how to Create query in X++ by code to get only selected fields ?

(0) Share

Report

Posted on by D.K.S.

1,010

Hi All,

I want to create a query using X++ code to get only two fields Dataarea and Name from CompanyInfo Table in the lookup. there are many fields in table and all are coming.

Class declaration code :-

SysLookupMultiSelectCtrl msctrl;
Query q;
QueryRun qr;
QueryBuildDataSource qbd;
QueryBuildRange qbr;

Form Init method code :-

super();
// mzkCompanyId - Name of control on which you want a lookup.
// CompanyInfo - Table name to get the lookup data
q = new Query();
qbd = q.addDataSource(TableNum(CompanyInfo));

msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(element, mzkCompanyId,q);

In this code, I just want to show Dataarea and Name field

how to achieve it ?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

D.K.S. 1,010 on at

Like (0)

Report

RE: how to Create query in X++ by code to get only selected fields ?

Hi ievgen Miroshnikov,

Thanks. it worked for me.

Regards,

DKS

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

RE: how to Create query in X++ by code to get only selected fields ?

Hi D.K.S.,

To specify fields you need to clear all fields from query and add only 2 you want, please refer for details theinfolog.com/using-a-query-with-syslookupmultiselectctrl

Was this reply helpful? Yes No