Microsoft Dynamics CRM (Archived)

How to get fields from child entity and set it to the parent entity fields

(0) Share

Report

Posted on by Suraj Jadhav

Hello,

I have two entities called booking and payment list and there is 1:N relation between them.

Now i want to get latest record from payment list entity which is child entity of booking.

Payment list entity has multiple records and i want only the last record(who has payment date) and that data should be set to the parent entity (booking) fields.

I want to achieve this using javascript.

please help me in this.

Thank You.

*This post is locked for comments

All responses (13)

Answers (2)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

replied here : community.dynamics.com/.../309283
Suraj Jadhav 74 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hello ,

Do you have any idea about how we can calculate sum of amount that we retrieve based on particular charge type ?
Suraj Jadhav 74 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hello, Rawish

My problem is solved now, it was my mistake i have not check the condition.

Thank You.
Community Member on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

.. why JS and not just Rollup using max of date?
Another solution would be on Change of the date to write it to the parent field using Workflow...
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hi Suraj,

It is working fine for me even for custom date.

please try to clear the cache and try in inprivate.
Suraj Jadhav 74 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

My date field is custom field not created on

and i just debug the cord and date field taking same value as 2019-02-16
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

this works for me :

rest builder - script , first result:
Suraj Jadhav 74 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hello Rawish ,

I have total 8 records and i am sorting data on Due date

1 record has due date 23-04-2016

2 record 30-08-2017

3 record 14-09-2016

4th record 13-11-2016

5th 30-11-2016

6th 30-12-2016

7th 16-12-2016

8th 09-02-2019

and i want 8th record first

i am getting all dates as 2019-02-16
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hi Suraj,

How did you know its not sorting. Did you debug the script to see what record you are getting on [0] position?
Suraj Jadhav 74 on at

Like (0)

Report

RE: How to get fields from child entity and set it to the parent entity fields

Hello Rawish,

Thank you it's work but it's not sorting descending by date

i have done it using rest builder please find below code line

&$orderby=psm_duedate desc", true);