Finance | Project Operations, Human Resources, ...

Get Data from another Table?

(0) Share

Report

Posted on by Chomchanok

276

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)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (1)

Report

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,827 Moderator on at

Like (1)

Report

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 276 on at

Like (0)

Report

Thank you Mohit.

Was this reply helpful? Yes No
Chomchanok 276 on at

Like (0)

Report

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,565 Moderator on at

Like (1)

Report

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,827 Moderator on at

Like (1)

Report
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

Join the conversation

Community site session details

Get Data from another Table?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Get Data from another Table?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates