How to retrieve the data based on a lookup using javascript

(0) Share

Report

Posted on by Community Member

hi guys,

i have three related entities, let city, bus, booking..

in booking entity if i select a particular city in city lookup i should get the related buses in the buses lookup field..

how to write the code in javascript..

thanks in advance..

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report

Refer this:

community.dynamics.com/.../how-to-retrieve-lookup-value-and-set-it-on-another-lookup-field-in-dynamics-crm-javascript

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Hi Varun ,

You can write fetch xml .Here is the sample fetch XML how to retrieve related record .

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"> <entity name="new_postalcode"> <attribute name="new_postalcodeid" /> <attribute name="new_name" /> <attribute name="createdon" /> <order attribute="new_name" descending="false" /> <link-entity name="etel_country" from="etel_countryid" to="optnc_pcountry" alias="ac"> <attribute name="countryname" /> <filter type="and"> <condition attribute="new_countryid" operator="eq" uiname="NOUVELLE-CALEDONIE" uitype="new_country" value="{2CF9EBD6-0575-E611-80E3-0050560111FF}" /> </filter> <link-entity name="new_city" from="new_countryid" to="new_countryid" alias="ad"> <attribute name="cityname" /> <filter type="and"> <condition attribute="new_cityid" operator="eq" uiname="NOUMEA" uitype="new_city" value="{381B1F7C-404F-E711-8103-000C29CBC14A}" /> </filter> </link-entity> </link-entity> </entity> </fetch>

You can use web api to execute fetchXML.

www.inogic.com/.../execute-fetchxml-using-web-api-in-dynamics-crm-2016

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi Varun,

If you have set up the relationship between these entities then you can look for the oob related record filtering functionality.

community.dynamics.com/.../how-to-filter-lookups-by-related-records-in-dynamics-365

www.powerobjects.com/.../how-to-use-dependent-lookups-for-dynamics-crm-201320152016

If the above doesn't work then you can add a java script to filter the lookup accordingly-

www.inogic.com/.../apply-custom-filter-on-lookup-field-in-dynamic-crm-using-script

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi,

You can use add “addPreSearch()“ method. You can read article www.inogic.com/.../apply-custom-filter-on-lookup-field-in-dynamic-crm-using-script

Hope it helps:)

Thank You

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi ridhima, i written the same one but it is throwing an error "is not defined at eval"..

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (1)

Report

Hi Varun,

The error "is not defined at eval" generally pccurs if there is any syntax error in the javascript or due to cache.

Do save publish customization, and refresh the form.

If that doesnt fix the issue then check if there are any javascript syntax error.

Hope this helps

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Not sure why you are writing code if this can be done through simple configuration only. refer above suggestion to implement dependent lookup.

Was this reply helpful? Yes No
Suggested answer

Arpit Shrivastava 7,518 User Group Leader on at

Like (1)

Report

Hi Varun,

You don't need to write a code in order to filter lookup unless filtering of records is complex.

Go with article suggested by Ravi or cab check below article:

https://community.dynamics.com/crm/b/magnetismsolutionscrmblog/archive/2017/10/19/how-to-filter-lookups-by-related-records-in-dynamics-365

https://community.dynamics.com/crm/f/117/t/224515

If found useful, please mark the answer as verified.

Cheers
Arpit
https://arpitmscrmhunt.blogspot.com

Was this reply helpful? Yes No
Suggested answer

Preeti Sharma 2,678 on at

Like (0)

Report

Hi Varun,

As suggested above you should use options provided OOB by CRM to filter records based on another lookup on form level.

Thanks:)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you guys for ur help.. i got my result..

Was this reply helpful? Yes No