Microsoft Dynamics AX (Archived)

Adding a view as a secondary datasource on a form

(0) Share

Report

Posted on by JoeBrewer

692

Is it possible to add the DirPartyView as a form datasource to link to DirPartyTable?

I have tried, but it doesnt seem to join correctly. It should be DirPartyTable.RecId == DirPartyView.Party

Thanks,
Joe

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Verified answer

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

Like (3)

Report
You'll have to help AX with the relation. If you're joining the datasources, add the link by the following piece of code in init() of the DirPartyView datasource.

this.queryBuildDataSource().addLink(fieldNum(DirPartyTable, RecId), fieldNum(DirPartyView, Party));

If you're linking them, use a dynalink instead.

Was this reply helpful? Yes No
JoeBrewer 692 on at

Like (0)

Report

Thanks Martin. That was exactly what I was looking for

Was this reply helpful? Yes No
Jorgen Dam 35 on at

Like (0)

Report

And how is this done in AX 2009, where this.querybuildDataSource() doesn't apply?

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (1)

Report

E.g. this.query().dataSourceTable(tableNum(MyTable)).

Was this reply helpful? Yes No
Jorgen Dam 35 on at

Like (0)

Report
Hi Martin

Thanks for your quick reply.

Yes I've tried that, but getting the "The data source is not embedded within a (parent) data source." runtime error.

I have a Table ActiveDealers with only one field DealerId, as the parrent table.
I want to join that with the DealersView (which contains aggregated info for the dealers)
I've added both as data sources to the form and set join source of DealersView to ActiveDealers (LinkType passive, as I want to add active dealers in the form)

I added this code to the init() of DealersView datasource:

super(); this.query().dataSourceTable(tablenum(DealersView)).addLink(
fieldnum(ActiveDealers, DealerId), fieldNum(DealersView, DealerId));

Been fighting with this issue all day now, so any input is appreciated :)

Best regrads,
Jorgen Dam

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

You said you wanted to join the datasources, but you didn't do that - that's why you got the error. Use InnerJoin instead of the passive link.

If you actually want to use a link instead of a join, you would have to use a dynalink (as I already mentioned in the first reply).

Was this reply helpful? Yes No
Jorgen Dam 35 on at

Like (0)

Report

I wanted to use the passive link as I wanted to edit the parrent table and for good reason not the child table as it is a view.

BUT, I used the InnerJoin instead and overrided the write method om the view datasource.

Everything works perfectlly now :)

Thanks a lot Maritn

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (1)

Report
I know it's confusing, because the single property (LinkType) is used for two very different things:

joins (InnerJoin, OuterJoin, ExistsJoin, NotExistsJoin) - create a single query

links (Passive, Delayed, Active) - create separate queries

You obviously have to work very differently if you have a single query (composed of two joined tables), or two separate queries (connected through a dynalink).

Was this reply helpful? Yes No
cujamison 5 on at

Like (1)

Report

Thank you Martin for your answer. This answered a big problem I was having today. I appreciate all your responses throughout the various AX community blogs.

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report

What about if a View has to be added to the query:

ListPage -> DataSource -> Query -> DataSourceTable01-> View.

I am trying to overwrite the init() method of the query (which is the data source) in order to link the view to the DataSourceTable01

Was this reply helpful? Yes No

Community site session details

Adding a view as a secondary datasource on a form

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Adding a view as a secondary datasource on a form

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 > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates