Hi Everyone,
In addition with the forum i have put my effort and followed the forum instruction and used this code to fetch workers private email as well :
<
select * from logisticsElectronicAddress
where logisticsElectronicAddress.PrivateForParty == HcmWorker.Person
&& logisticsElectronicAddress.IsPrivate == NoYes::Yes
&& logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Email />
but unable to achieve my requirement as this select statement is showing blank record on the report.Below is my embed code :
<
///The method should compute data and populate the data tables that will be returned to SSRS.
private void insertData()
{
//AssetTable assetTable;
AssetTable assetTable ;
HcmWorker hcmWorker ;
LogisticsElectronicAddress logisticsElectronicAddress;
DirPartyTable dirPartyTable;
//declaring EA_AssettableContract_UI class
ATO_AssetTableContract contract=this.parmDataContract();
while select * from assetTable
//inner join with hcmworker
join RecId from hcmWorker
where hcmWorker.RecId==assetTable.WorkerResponsible
&& AssetTable.AssetGroup=="Computers"
//skipping blank values from workername field
&& AssetTable.WorkerName!=" "
//comparing paramerter to report
&& assetTable.AssetId==contract.parmAssetId()
join * from dirPartyTable
where dirPartyTable.RecId == hcmWorker.Person
join * from logisticsElectronicAddress
where logisticsElectronicAddress.PrivateForParty == hcmWorker.RecId
&& logisticsElectronicAddress.IsPrivate == NoYes::Yes
&& logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Email
// && logisticsElectronicAddress.IsPrivate == NoYes::No
//&& logisticsElectronicAddress.Type == LogisticsElectronicAddressMethodType::Email
{
assetTableTmp.clear();
assetTableTmp.AssetId =assetTable.AssetId;
assetTableTmp.AssetGroup =assetTable.AssetGroup;
//tmpAssettable.PersonnelNumber=assetTable.PersonnelNumber
assetTableTmp.WorkerName=assetTable.WorkerName;
assetTableTmp.Locator=logisticsElectronicAddress.Locator;
// assetTableTmp.WorkerName=hcmWorker.PersonnelNumber;
// assetTableTmp.Locator=logisticsElectronicAddress.LocatorExtension;
//personnel number fetching form hcmworker table
// assetTableTmp.PersonnelNumber=hcmWorker.PersonnelNumber;
assetTableTmp.insert();
}
}
/>
Can someone assist me what is wrong in the code ? and why we have used PrivateforParty for relation.
thank you
regards
*This post is locked for comments
I have the same question (0)
