Finance | Project Operations, Human Resources, ...

Answered

View datasource on extended form

(3) Share

Report

Posted on by ŠŠ-06050712-0

Hi all,

I'm adding view to CaseDetail form extension (CaseDetail.KOP) for displaying active activities per case and I do not know how to join this view to CaseDetailBase ds without outerJoin. Outer join works well, but is problematic as it breaks positionToRecord method and user's refresh makes grid jump to first record.

For 'delayed' joinType the positionToRecord() works well but view's results are displayed only in first row, but correctly. If I select e.g. 3rd row, correct result is diplayed in the 1st row.

Query on view DS seems to have correct link (CaseDetailBase.CaseId = view.CaseId) - results are correct but are only displayed wrong.

Is there any way to join view with types of join other than inner or outer join? Am I missing something? Should I create table?

I have chosen view as users want to sort by this field, so display method is not suitable.

I tried to link CaseDetailBase DS and view by code, but since link is okay and only display is broken, it didn't helped. I didn't try outerJoin by code as I do not expect to do anything else what outerJoin in DS properties is doing.

I have this problem on some other form extensions, so any advice would help me a lot. I'm asking this before making everything into table as both displayMethod and jumping to first record are unacceptable for client.

grid displaying view's result only in first row with 'delayed' linkType:

with outerJoin:

view is very simple:

Thanks for any advice!

Šimon

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (1)

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

Like (0)

Report

There isn't any other type of join (besides inner join and outer join) that you could use. The only remaining are exists join and not exists join, which fetch no data from the joined data source.

Delayed, active etc. aren't joins at all. They produce a separate query filtered by the selected row of the parent data source, which isn't suitable if you want to show data from both tables in a single grid.

Was this reply helpful? Yes No
Verified answer

ŠŠ-06050712-0 19 on at

Like (0)

Report

@Martin Dráb Thanks for your answer and pardon me for mixing joinType and linkType property. I'll try to be 100% correct and maybe you will answer to the point of post next time.

For anyone having same problem: on extended forms, just insert data into table as somehow outerJoin on table is working and user's refresh does not make grid jump to first record. It may require more coding for getting/rewriting data at right time, but anything for users, right?

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

Like (0)

Report

It's good to hear that's now clear to why you didn't got wrong result using the delayed link instead of a join. (You wrote before: For 'delayed' joinType the positionToRecord() works well but view's results are displayed only in first row, but correctly. If I select e.g. 3rd row, correct result is diplayed in the 1st row.).

Was this reply helpful? Yes No
ŠŠ-06050712-0 19 on at

Like (0)

Report

@Martin Dráb I'm aware of that, but the problem I posted about was with jumping to first record using views on extended forms. I was trying to point out that data are corrrect and form works well until I select outerJoin for datasource based on view. I thought that maybe I'm missing some setting for delayed link to make it work - display on all rows.

I don't know half of what you know. I saw your answers many times and sometimes they are great and pointing to solution. Maybe my english is hard to understand and for that the real problem was not clear - sorry for that, but your answer didn't helped at all. If you were trying to teach me not to ask and find solution by myself, it helped a bit (:

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

Like (0)

Report

I understand that my reply wasn't the ultimate solution of your issue, but I believe that I correct one mistake (I explained why using a Delayed link can't give you what you want) and I also answer one of your questions ("Is there any way to join view with types of join other than inner or outer join?). Then we could have a further discussion about your problem, without being distracted by things like Delayed links, because we've already addressed them. Unfortunately, you stopped the discussion.

In my opinion, these are answers relevant to your questions and I don't understand why you feel offended by them. Even I missed your point, I would still be somene investing his time to trying to help you. Anyway, I apologize for any inconvenience caused by my reply.

Was this reply helpful? Yes No
ŠŠ-06050712-0 19 on at

Like (0)

Report

@Martin Dráb Martin, I appreciate your time. Thanks for trying to help, even you missed the point. I missed yours..

Was this reply helpful? Yes No

Join the conversation

Community site session details

View datasource on extended form

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

View datasource on extended 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 > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates