Finance | Project Operations, Human Resources, ...

Get Data from another Table?

(0) Share

Report

Posted on by Chomchanok

282

Hi now I dev x++ for Data Provider

1. Set up variable

ReturnReasonCode ReturnReasonCode;
str returnReasonCodeID;
str returnReasonDesc;

2. I try to filter data in table ReturnReasonCode to show with criteria ReasonCodeId = custInvoiceJour.ReturnReasonCodeId

returnReasonCodeID = custInvoiceJour.ReturnReasonCodeId ;
returnReasonCode = ReturnReasonCode::find(ReturnReasonCode.ReasonCodeId); // suspect this line error but what's wrong?

3. I show My string
if (returnReasonCode)
{
returnReasonDesc = returnReasonCode.Description; // Get the Description field from the ReturnReasonCode record
}
else
{
// Handle the case when the return reason code is not found
}

and of cause I didn't got error but nothing to show. what's wrong please help.

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi, If you want to find ReturnReasonCodeId of custInvoiceJour in returnReasonCode table then try below code where you mentioned '// suspect this line error but what's wrong?'

returnReasonCode = ReturnReasonCode::find(returnReasonCodeID);

You are finding returnReasonCodeID but not using it in ReturnReasonCode find method.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Thanakorn,

Have you debugged the code?

Seems the code looks good.

Does the particular reason code have description?

Thanks,

Girish S.

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mohit.

Was this reply helpful? Yes No
Chomchanok 282 on at

Like (0)

Report
Copy link

Link copied!

yes in my idea I want to get a description to show but it's sound like i'm in a rat race that test, debug.. bla bla but now i got answer already thank you too.

Was this reply helpful? Yes No
Mohit Rampal 12,573 Moderator on at

Like (1)

Report
Copy link

Link copied!

You are welcome Thanakorn Kanjiropas

If Fixed, please mark answer Verified else let us know if still issue.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!
One more suggestion I have is, if you want only one field from ReturnReasonCode table - You can go for select statement by specifying the field to be selected from the database - This will increase your performance.

ReturnReasonCode ReturnReasonCode; str returnReasonCodeID; str returnReasonDesc; returnReasonCodeID = custInvoiceJour.ReturnReasonCodeId ; select firstonly Description from returnReasonCode where returnReasonCode.ReasonCodeId == returnReasonCodeId; if(returnReasonCode) { returnReasonDesc = returnReasonCode.Description; }

Thanks,

Girish S.

Was this reply helpful? Yes No