while select AccountNum, TransDate from vendTrans group by vendTrans.AccountNum where vendTrans.TransDate==fromdate
{
Info(vendTrans.AccountNum);
if( localAccount != vendTrans.AccountNum)
{
select AccountNum ,party from vendTable where vendTable.AccountNum==vendTrans.AccountNum
join Name from partyTable where partyTable.RecId==vendTable.Party join
Locator from logisticsElectronicAddress where logisticsElectronicAddress.RecId==partyTable.PrimaryContactEmail;
str emails = logisticsElectronicAddress.Locator;
mailer.addTo(emails);
mailer.setSubject(strFmt(" Payment Details - %1 %2",vendTable.AccountNum,partyTable.Name));
body = "Hi Dear " + strFmt(" %1 <br/><br/> Vendor Account No. : %2 <br/> ",partyTable.Name,vendTable.AccountNum) ;
}
localAccount = vendTable.AccountNum;
}
mailer.setBody(body,true) ;
SysMailerFactory::getNonInteractiveMailer().sendNonInteractive(mailer.getMessage()) ;
this query outputs two accounts INMF01 And INMF05 , now data needs to be sent to their primary email address we have added lets suppose x1@gmail.com and x2@gmail.com(picking from locator in logistics electronic address) for both accounts respectively but this query is also sending INMF05 to x1@gmail.com also , only INMF01 to x1@gmail.com and INMF to X2@gmail.com needs to be sent
