web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) While select join map

Microsoft Dynamics AX (Archived)

While select join map

(0) Share

Report

Report

Posted on by OrangeRocks

700

Hi all,

is it generally possible to write a query in a class that choses records from a table and a map?

The table would be LedgerJournalTrans , the map: CustVendTransOpen.

The tabel LedgerJournalTrans has a customized field that contains recids from tables custTransOpen or VendTransOpen.

I need something like this:

while select forupdate LedgerJournalTrans

join  CustVendTransOpen where CustVendTransOpen.recId == LedgerJournalTrans.cutVendTransOpenRecID

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Martin Dráb 237,912 Most Valuable Professional on at

Like (0)

Report

A map always represent one specific table at runtime - either CustTransOpen or VendTransOpen in your case, never both at the same time. Therefore the answer is "no, it can't work in this way".

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

Ok, thank you

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans