Finance | Project Operations, Human Resources, ...

How to join datasources with code?

(0) Share

Report

Posted on by BASMA

932

I add 2 datasources in form , then I add this code in the init method of form

    
    
    parmid                  = element.args().parm();
    query = new Query();
    queryBuildDataSource = query.addDataSource(tableNum(LoadLicenseLevel));
    queryBuildDataSource.addRange(fieldnum(LoadLicenseLevel,ParentMenuItem)).value(parmid);

    queryBuildDataSource1 = queryBuildDataSource.addDataSource(tableNum(TreeNode));
    queryBuildDataSource1.addRange(fieldnum(TreeNode,MatrixRole)).value(MatrixID.valueStr());
    queryBuildDataSource1.joinMode(JoinMode::InnerJoin);
    queryBuildDataSource1.relations(false);
    queryBuildDataSource1.addLink(fieldNum(LoadLicenseLevel, EukBrowsedMenuItems), fieldNum(TreeNode, SecurableName));

But I don't get the exact values.

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you please provide a better description of your problem? "I don't get the exact values" can mean anything.

Can you also show us how you're using the query? Because your code doesn't modify form's query - it creates a new independent query. If you don't explicitly set it to the form, all your code won't have any effect. But do you really want to create a new query instead of just filtering the automatically generated query? As usual, explaining what you're trying to achieve, instead of just showing a piece code, would help us to help you.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I want to display informations in Grid based on 2 datasources.:

in the 1rst column I get BrowsedMenuItems from the 1rst datasource.LoadLicenseLevel

2. Based on BrowsedMenuItems I want to search these values in TreeNode datasources (Column SecurableName ).

When I get the correct informations (BrowsedMenuItems exists into TreeNode in the column SecurableName);

I want to display the securityLevel from TreeNode datasource.

in the init method I add this code that I send later.

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

Like (0)

Report
Copy link

Link copied!

Unfortunately you still haven't describe your problem, so let me at least improve your design.

First of all, there is no TreeNode table and - as far as I can say - none can exist, because the name is already taken by TreeNode class. Can you please confirm that you have such a table? If you don't and your code won't even compile, than you should obviously fix this bug.

Also, you don't need any code to add data sources and set the type of join. You seem to already have form datasources; then simply set JoinSource and Link Type properties on the child data source.

Regarding the join relation, consider if you can't add it to child table. If you can all, you don't need addLink() either. All code you'll need is setting query ranges on the existing data sources.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

The table TreeNode (customized table) exists

I don't find any relations between the 2 tables

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

Like (0)

Report
Copy link

Link copied!

If you really have two types with the same name (which I still struggle to believe), than your environment is a funny state and getting it fixed should be your top priority.

If you don't have any relation and you want one, create it.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

I dont understand you

If you really have two types with the same name ??

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

Like (0)

Report
Copy link

Link copied!

Dynamics AX contains a class called TreeNode. And you're saying that you also have a table with the same name, TreeNode. It shouldn't be possible, because than the same type name would mean two different things. How could you compile and run code without knowing which of the two types you should use?

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Copy link

Link copied!

the name is EUKTreeNode , juste I write TreeNode ;)

I add relation between tables but I don't get any values now

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,381 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

All right then, Next time, please make sure you compile your code and fix compilation errors.

Please show us your current code and configurations of data sources. Also, look at the actual query string and verify that you have at least one record meeting all criteria.

Was this reply helpful? Yes No