Customer experience | Sales, Customer Insights,...

Plugins for lookup

(0) Share

Report

Posted on by happysingh0009

160

i am writing a plugin on "PLAN CLASS TABLE". I have another table "CLASS REQUIREMENTS". this table has a lookup field "PLAN CLASS" from PLANCLASS TABLE. i want to

read second table. please guide which is best way to do this.

666740.Capture.PNG

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report
RE: Plugins for lookup

Hello ManPreet,

As you will register your plugin on the Plan Class Table,

1. You will get the GUID of the Plan Class Table record.

2. Now Just create a query on the "Class Requirement Table" just like below.

select Class Requirement table

where Plan class Table Record guid = from step 1.

Download this Fetch XML.

3. Fetch XML will look like below.

and that is how you will get the data.

4. Replace GUID with the Dynamic GUID when your plugin will run.

Thank you,

Amit Katariya

Was this reply helpful? Yes No
happysingh0009 160 on at

Like (0)

Report

RE: Plugins for lookup

hi sir

i am beginner so dont know how to create query on table. can please explain it in details

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: Plugins for lookup

Just like I did above you can follow the same...that is why I have attached the screen shots for your reference.

It is very easy to understand the Fetch XML.

Line number 2 describes the Entity/table on which this query run.

Line 3 to 16 have attributes which we will get.

Line 18 to 20, it is a filter criteria that means "Where" condition...

docs.microsoft.com/.../use-fetchxml-construct-query

www.c-sharpcorner.com/.../

dynamics-chronicles.com/.../fetchxml-overview-essential-syntax

Also for the C# code you can refer below articles.

d365demystified.com/.../

carldesouza.com/.../

mylearnings26.wordpress.com/.../

Was this reply helpful? Yes No
happysingh0009 160 on at

Like (0)

Report

RE: Plugins for lookup

i performed these steps. now how i can add this code to my pre-written code. this was a part of bigger project. i want to use the value of these attributes to perform some tasks.

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

RE: Plugins for lookup

Have you already registered the plugin on the PLAN CLASS TABLE?

if yes then you can merge this New code with the old one. And make sure get the attribute result before your main operation so that your code will work as expected and will not provide null exception.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

RE: Plugins for lookup

Hi,

You can generate your fetch xml query from advanced find easily. Open advanced find and add below condition then click on Download fetch xml ribbon button.

Building -> Class Reuqirement Table

Employee -> Plan Class(lookup)

Now use below tool to convert your fetxh xml to c#

https://www.ashishvishwakarma.com/FetchXmlFormatter/

Now check below blog on how to use this code in your plugin class file

https://carldesouza.com/dynamics-365-fetchxml-c/

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No