how to get store address from LogisticsPostalAddress Table

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

i have data source table RetailTransactionPaymentTrans, i want to get state, county, and address fields from LogisticsPostalAddress Table, i'm using this peace of code but still faild...

str storeVale, storeValue2, storeValue3;

container workFlowContainer;

while select logisticsPostalAddress
join logisticsPostalAddress
where retailTransactionTable.LogisticsPostalAddress== logisticsPostalAddress.RecId
join retailTransactionTable
where retailTransactionTable.transactionId== paymentTransTable.transactionId
|| retailTransactionTable.store== paymentTransTable.store
|| retailTransactionTable.terminal== paymentTransTable.terminal

storeVale = postalAddressView.County;
storeValue2 = postalAddressView.Address;
storeValue3 = postalAddressView.State;

workFlowContainer = conIns(workFlowContainer,1, storeVale);
workFlowContainer = conIns(workFlowContainer,2, storeValue2);
workFlowContainer = conIns(workFlowContainer,3, storeValue3);
return workFlowContainer;

... please help me where i miss the logic ?

*This post is locked for comments

All responses (6)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: how to get store address from LogisticsPostalAddress Table

basically its warehouse location , i'm using storeID
Mea_ 60,278 on at

Like (1)

Report

RE: how to get store address from LogisticsPostalAddress Table

How do you want to find a store ?

Do you know store id or you have payment transaction record \ store record ?
Community Member Microsoft Employee on at

Like (0)

Report

RE: how to get store address from LogisticsPostalAddress Table

store location address
Mea_ 60,278 on at

Like (0)

Report

RE: how to get store address from LogisticsPostalAddress Table

Yes you can,

retailTransactionPaymentTrans.TransactionTable().deliveryAddress().Address;

However what are you trying to get store address or delivery address ?
Community Member Microsoft Employee on at

Like (0)

Report

RE: how to get store address from LogisticsPostalAddress Table

Hi ievgen,

i tried it but still failed, can we use built-in methods like :

salesRemittanceTemp.LocationName=logisticsPostalAddress::findByLocation(CompanyInfo::find().postalAddress() .Location).Address;
Suggested answer

Mea_ 60,278 on at

Like (1)

Report
RE: how to get store address from LogisticsPostalAddress Table

I think you need to rewrite it a bit :

select logisticsPostalAddressView join retailTransactionTable where retailTransactionTable.LogisticsPostalAddress == logisticsPostalAddressView.RecId && retailTransactionTable.transactionId == paymentTransTable.transactionId && retailTransactionTable.store == paymentTransTable.store && retailTransactionTable.terminal == paymentTransTable.terminal