Dynamics Community Forum Thread Details

Lookup for Reference group control

public class CerficateRequestWorkerLookup
{

/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
[FormControlEventHandler(formControlStr(CertificateRequest, CertificateRequest_Worker), FormControlEventType::Lookup)]
public static void CertificateRequest_Worker_OnLookup(FormControl sender, FormControlEventArgs e)
{
HcmWorker hcmworker;
HcmPositionRecId hcmpositionRecId;
HcmPositionHierarchy hcmPositionHierarchy;
HcmPosition hcmposition;
HcmPositionWorkerAssignment workerAssignment;
HcmWorkerRecId hcmWorkerRecid;
UserId userId = curUserId();
int64 recid;
WorkerTable WorkerTable;
DirPersonUser dirPersonUser;
DirPerson dirPerson;
DirPartyTable dirPartyTable;

ttsbegin;
delete_from WorkerTable;
ttscommit;

hcmpositionRecId = HcmPosition::find(HcmPositionWorkerAssignment::getActivePositionWorkerAssignment(HcmWorker::find(HcmWorker::userId2Worker(userid)).RecId).Position).RecId;

while select hcmPositionHierarchy
where hcmPositionHierarchy.ParentPosition == hcmpositionRecId
join hcmposition where hcmposition.RecId == hcmPositionHierarchy.Position
join workerAssignment where workerAssignment.Position == hcmposition.RecId
join hcmworker where hcmworker.RecId == workerAssignment.Worker
{
WorkerTable.Worker = hcmworker.Person;

WorkerTable.insert();
}
select * from hcmWorker
where hcmWorker.RecId == hcmWorker::userId2Worker(curUserId());

select * from dirPerson
where dirPerson.RecId == hcmWorker.Person;

select * from dirPartyTable
where dirPartyTable.RecId == dirPerson.RecId;
WorkerTable.Worker = hcmworker.Person;

WorkerTable.insert();

SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(WorkerTable),sender);
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;

sysTableLookup.addLookupField(fieldNum(WorkerTable,Worker));
sysTableLookup.addLookupField(fieldNum(WorkerTable,PersonnelNumber));
queryBuildDataSource = query.addDataSource(tableNum(WorkerTable));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
ce.CancelSuperCall();
}

}

Hi All,

I got issue when i create lookup on reference group control.i took event handler lookup.here Worker is Recid.Based on condition we insert the data into WorkerTable.In that Worker Table we need lookup in certificate request form.Finally i got the issue as shown below screen.