how to transform select statement to query x++ ?

(0) Share

Report

Posted on by Awaxx

229

Hi guys,

I'm little confused on how to transform this select statement in query :

OMOperatingUnit omOpunit;
OMHierarchyRelationship omHierRelation;
DataArea dataReg;
OMInternalOrganization omIO;

str dataarea = '590';

select dataReg where dataReg.id == dataarea;

select omIO where omIO.Name == dataReg.name;

while select omHierRelation where omHierRelation.ParentOrganization == omIO.RecId
{
    select omOpunit
        where omHierRelation.ChildOrganization == omOpunit.RecId;

    Info(omOpunit.Name);
}

I used that in a job and it's working like i want but i need to use it in a lookup eventhandler and its a bit hard for me to find how.

Could someone teach me please ?

Regards.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
RE: how to transform select statement to query x++ ?

select * from DataArea da join OMInternalOrganization omIO on omIO.Name = da.name join OMHierarchyRelationship omHierRelation on omHierRelation.ParentOrganization = omIO.RecId join OMOperatingUnit omOpunit on omHierRelation.ChildOrganization = omOpunit.RecId where dataReg.id = '590';

You can try this. For me OMInternalOrganization, OMOperatingUnit are not found. Try and let us know.

Was this reply helpful? Yes No
Abhi 120 on at

Like (0)

Report

RE: how to transform select statement to query x++ ?

Hi Mack Nate,

You ask how to create a lookup eventhandler for field.

Please take the ref this code

----------------------------------------------------------------------------------------------------------------

Query query = new Query();

QueryBuildDataSource queryBuildDataSource,queryBuildDataSource1;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(PurchTable),this); // this is refer that current ref (In eventhandler sender )

sysTableLookup.addLookupField(fieldNum(PurchTable, PurchId));

queryBuildDataSource = query.addDataSource(tableNum(PurchTable));

querybuilddatasource1 = querybuilddatasource.adddatasource(tablenum(ledgerjournaltrans));

querybuilddatasource1.addlink(fieldnum(PurchTable, PurchId), fieldnum(ledgerjournaltrans, PurchId));

queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchTable, InvoiceAccount));

queryBuildRange.value(001);

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

-------------------------------------------------------------------------------------------------------------------

Thanks,

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: how to transform select statement to query x++ ?

Hi, Please check this article and try creating your lookup method. Let us know when you get issues and need assistance.

daxbeginners.wordpress.com/.../

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (1)

Report
RE: how to transform select statement to query x++ ?

You can refer to the below query and see if it helps.

Query query = new query(); QueryBuildDataSource qbds,qbds1; OMOperatingUnit omOpunit; OMHierarchyRelationship omHierRelation; DataArea dataReg; OMInternalOrganization omIO; str dataarea = '590'; select dataReg where dataReg.id == dataarea; select omIO where omIO.Name == dataReg.name; SysTableParameter parameter = new SysTableParameter(tableNUm(OmOperatingUnit),this); parameter.addlookupfield(fildnum(OmOperatingUnit, Name)); qbds = query.addDatasource(tablenum(OmOperatingUnit)); qbds1 = qbds.addDatasource(tablenum(OmHierarchyRelationship)); qbds1.addLink(fieldnum(OmOperatingUnit,RecId),fieldnum(OmHierarchyRelationship, ChildOrganisation)); qbds1.relations(false); qbds1.addRange(fieldnum(OmHierarchyRelationship, ParentOrganization)).value(queryvalue(omIo.RecId));

Thanks,

Girish S.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (3)

Report
RE: how to transform select statement to query x++ ?

I did this, its seem to work

Query query = new query(); QueryBuildDataSource qbds,qbds1; OMOperatingUnit omOpunit; OMHierarchyRelationship omHierRelation; DataArea dataReg; OMInternalOrganization omIO; select dataReg where dataReg.id == ledgJourInfo.DataAreaId; select omIO where omIO.Name == dataReg.name; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(OMOperatingUnit), location); sysTableLookup.addlookupfield(fieldnum(OmOperatingUnit, OMOperatingUnitNumber)); sysTableLookup.addlookupfield(fieldnum(OmOperatingUnit, Name)); qbds = query.addDatasource(tablenum(OmOperatingUnit)); qbds1 = qbds.addDatasource(tablenum(OmHierarchyRelationship)); qbds1.addLink(fieldnum(OmOperatingUnit,RecId),fieldnum(OmHierarchyRelationship, ChildOrganization)); qbds1.relations(false); qbds1.addRange(fieldnum(OmHierarchyRelationship, ParentOrganization)).value(queryvalue(omIo.RecId)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup();

Thank you guys.

Now i need to understand and learn how.

Was this reply helpful? Yes No