Model Driven View One-To-Many column

(0) Share

Report

Posted on by AnthonyD

559

Hi guys,

So i was wondering. I have this case: A training has multiple durations. Would it be possible to have a column in my training view that shows the first duration date (related to the training) from the related durations table? How would this be achieved?

Best Regards,

Anthony

Categories:

Entities

Microsoft Dataverse

Tables

All responses (6)

Answers (1)

AnthonyD 559 on at

Like (1)

Report

Re: Model Driven View One-To-Many column

@dpoggemann Oh! that's how it works!

Well i kinda did it another way and it works too! Here is how i did it:

Thanks for the great help!
Best Regards,
Anthony
Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Model Driven View One-To-Many column

Hi @Anthony_Dob ,

When you are building the condition there is the ability to create multiple conditions and then group them with OR clause. You select each row and then say "Group OR", see below.
AnthonyD 559 on at

Like (0)

Report

Re: Model Driven View One-To-Many column

@bipinshan

A rollup field does not work for me. I've tried that already and it's not returning any values.

Best Regards,
Anthony
AnthonyD 559 on at

Like (0)

Report

Re: Model Driven View One-To-Many column

@dpoggemann ,

I've been trying to implement your instructions but i can't seem to find a OR statement in the classis editor. This is how my workflow looks atm:
I see you can add OR and AND groups but you need 2 or more statements for that.

Best Regards,
Anthony
Verified answer

Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report
Re: Model Driven View One-To-Many column

Hi @Anthony_Dob ,

If rollup does not meet your needs I would do the following:

Create the field for First Duration Date on the Training record

Create realtime workflow triggering on create of Duration record and on modification of Duration record's Date field

First step in workflow checks if the Training tables "First Duration Date" is null or > Duration table record's "Date" field

If true on #3 then do Update Record on the Training record and set the date tot he Duration table's date

The steps above will handle if you make changes to the dates on the Duration table and if you create a new one with a date < the current first one.

2. The first step should check if the Tra
Bipin D365 971 on at

Like (0)

Report

Re: Model Driven View One-To-Many column

Hi,

You can easily achieve this with the help of Roll up field.

Create new roll up field in Training entity as Date Time data type and select field type as Rollup.

Select Max function in rollup field on Duration Date.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

CR8.PNG