web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

(0) ShareShare
ReportReport
Posted on by

In an Opportunity, I would like the Job Order Lookup to provide the following:

  The Job Orders associated with the Account that is assigned to the given Opportunity.

Is there specific filter criteria to customize on "Job Order Lookup View" to meet this request?

Was expecting the query below to work... but does not provide the expected results:

Further clarification:

I've come to realize the Lookup I am describing is actually a list/chart.

When the "Add Job Order Record" plus sign is selected, it uses the aforementioned  "Job Order Lookup View".

I'm not sure of a method of passing the account value into this view... or the filtered criteria of a view taking a passed-in variable to determine which Job Orders are associated with the associated account.

Still trying to get my screenshots attached.

Here is a picture of the Opportunity:

opportunity_5F00_pic.JPG

Clicking the Plus sign to the right of Job Orders provides "Lookup":

Job_5F00_Order_5F00_Lookup_5F00_pic.JPG

At the bottom of the lookup records, it allows for Lookup of More Records and shows the view being used:

Job_5F00_order_5F00_lookup_5F00_view_5F00_pic.JPG

My challenge is wanting to provide the user a lookup based on "this" Opportunity's Account and the Job Orders associated with the the Account.

*This post is locked for comments

I have the same question (0)
  • TomDT Profile Picture
    on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    My copied screenshots were being removed.  I apologize.  I have inserted them as objects and hope they remain.

  • TomDT Profile Picture
    on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    Here is one screenshot that was removed:

  • Nithya Gopinath Profile Picture
    17,078 on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    Hi Tom,

    The screenshots are not visible.

  • TomDT Profile Picture
    on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    Very helpful, but doesn't help me achieve what I'm looking for.  I have updated the original post with a little more detail.

  • Community Member Profile Picture
    on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    Hi,

    you can also achieve it with javascript: www.inogic.com/.../apply-custom-filter-on-lookup-field-in-dynamic-crm-using-script

    If Mahender solution meets your needs you should go with it else use the above solution

  • Mahendar Pal Profile Picture
    45,095 on at
    RE: Dynamics CRM 365 - Filter Criteria on Form Views (using related entities)

    Hi,

    I am assuming you want to filter job order which is specific to account only and you have relationship between account and job order entity, if yes, you can use related record filtering , please check steps here: www.powerobjects.com/.../how-to-use-dependent-lookups-for-dynamics-crm-201320152016

    Let me know if my understanding is not correct.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans