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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

ms crm 2013 lookup filter

(0) ShareShare
ReportReport
Posted on by 1,077

Hi,

I am trying to filter lookup by properties with created view. Want to set other then default lookup value(state).
Lookup field shows proper filtered record But when i click on the lookup magnifying glass it does'nt set selected record
it shows blank. However, when i click on 'lookup more records' then it set the selected record.

Any help would be greatly appreciated.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at

    Hi Suresh,

    Refer the following links:

    www.magnetismsolutions.com.au/.../crm-2013-javascript-lookup-filtering-using-addcustomfilter

    community.dynamics.com/.../crm-2013-javascript-lookup-filtering-using-addcustomfilter.aspx

    Hope this helps.

    Regards,

    R.Rajkumar

    "Please mark my answer as verified if you found it helpful"

  • Suggested answer
    Aileen Gusni Profile Picture
    44,524 on at

    Suresh,

    What is your code?

    Are you using addcustomview or addcustomfilter?

    Thanks.

  • Suresh Sorde Profile Picture
    1,077 on at

    Aileen,

    I am not using any javascript. I have set property of lookup field  'show related record' and created view and set as default for lookup. It is giving expected record.  

    Rajkumar

    The lookup field is giving me expected filtered records I don't want to user javascript. Issue is when I am trying to select value by single click on lookup magnifying glass it doesn't affect on field and when I open lookup by clicking look more record and select the value then only it affect on field.

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at

    Hi suresh,

    Can you see the topic "Fixing the sub-grid user experience in CRM 2013" in the following link:

    garethtuckercrm.com/.../2

    www.rockmycrm.com/.../dynamics-crm-there-is-a-whole-lot-of-clicking-going-on

    Regards,

    R.Rajkumar

    "Please mark my answer as verified if you found it helpful"

  • Suresh Sorde Profile Picture
    1,077 on at

    8103.2.png

    7848.4.png

    When I select value from point 1 then it show blank as in point 2.

    But below as I click on 'lookup more records' and select one record then only it shows in product field.

    2045.6.png

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at

    Hi Suresh,

    Refer this link. It explains deeply.

    missdynamicscrm.blogspot.in/.../filter-lookup-field-by-related-subgrid-crm-2011-2013.html

    Hope this helps.

    Regards,

    R.Rajkumar

    "Please mark my answer as verified if you found it helpful"

  • Verified answer
    Aileen Gusni Profile Picture
    44,524 on at

    Hi Suresh,

    Your Product lookup is a custom entity right?

    it seems you don't have primary name for the records, it's actually not blank?

    Please help to check that your product name is not empty.

    Thanks.

  • Mahendar Pal Profile Picture
    45,095 on at

    Are you facing this issue with current lookup only or with all lookup fields ?? Which browser you are using ?? did you try in another browsers and facing the same issue ??

  • Suresh Sorde Profile Picture
    1,077 on at

    Hi Aileen,

    Yes it is custom entity. and the value i want to set is not the primary name.

    Product name is not blank as in image it affect from 'lookup more records' select.

    When i update view with primary name field it set the primary name but not the product name.

    Hi Himbap

    I am facing this issue only for this lookup other lookup fields are working proper.

    and i am using explorer10.

  • Mahendar Pal Profile Picture
    45,095 on at

    Ok, "i want to set is not the primary name. Product name is not blank as in image it affect from 'lookup more records' select. When i update view with primary name field it set the primary name but not the product name." How you are trying to set non primary field in lookup, using java script ??

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans