Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to show top first ...
Microsoft Dynamics CRM (Archived)

How to show top first latest record from child custom entity in parent form?

(0) ShareShare
ReportReport
Posted on by Ashish Moradiya 515

Hello, 

I am extending information for Opportunity entity by creating custom ExtendedInfo Entity with 1:N relationship.

I want to see only top 1 (latest) record from ExtendedInfo entity in opportunity form. I already tried creating view showing record descending order by CreatedDate field and use subgrid with with limiting number of rows which creates two problem for me.

1. Not allow to set 1 value

LimitRow.jpg

2. It shows pagination (multiple records)

How can I achieve my requirement?

Thanks in advance...

Regards,

Ashish

*This post is locked for comments

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: How to show top first latest record from child custom entity in parent form?

    Hi Ashish,

      if there is always only 1 extended entity per opportunity (is it, literally, 1:1?), it might be easier/more straighforward to use a combination of a lookup/quick view form (add a lookup to the opportunity entity, create a quick view form for the extendedinfo entity, and add both the lookup and the quick view form to the opportunity form instead of that subgrid)

      With the subgrid, you can probably use javascript to display top 1, but it will still be a subgrid ("+" button, "delete" button, etc)

  • Suggested answer
    ashok teja Profile Picture
    ashok teja 290 on at
    RE: How to show top first latest record from child custom entity in parent form?

    Hello, 

    Using script you can filter the records in subgrid as per your requirement. 

    Have a look at the following link 

    https://mydynamicsmscrm.wordpress.com/2016/11/18/filter-subgrid-using-script/

    If found useful, please mark the answer as verified.

    Thanks

    Ashok J

    XRMWEBKIT | CRMPORT | DynamicsHelpmate 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans