Microsoft Dynamics CRM (Archived)

a quick help on fetch xml

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Friends,

55106.Capture.PNG

My requirement is to get the account id using that parent account number.

I have attached a screen shot of fetch xml here. IS it right way to get what I want. please help me.

*This post is locked for comments

All responses (12)

Answers (3)

Verified answer

Alex Fun Wei Jie 33,626 on at

Like (1)

Report

RE: a quick help on fetch xml

Hi,

if you stored the parent account number in every child account, then you can go ahead.
Mahendar Pal 45,095 on at

Like (0)

Report

RE: a quick help on fetch xml

Not sure what screen shot you are looking for, the query I shared, will be fetching all the account which parent customers number is 123, based on your question.
Community Member Microsoft Employee on at

Like (0)

Report

RE: a quick help on fetch xml

Yes I want all the parent account number because my intension is to fire plugin on the change of parent Account Number field of the account entity. So do you think the fetch xml, I selected will help me, please reply.
Verified answer

Alex Fun Wei Jie 33,626 on at

Like (1)

Report

RE: a quick help on fetch xml

Hi,

if the parent account number is 1234, and you want to find those account which using parent account number 1234. With your fetchxml, you not only getting accounts with parent account number with 1234, but also others ( parent account number with 5678). Are you sure?
Community Member Microsoft Employee on at

Like (0)

Report

RE: a quick help on fetch xml

yes, all account, not specific. so the one I shared, is that correct. But then I dont get that link-entity in my fecth query, is it okay?
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: a quick help on fetch xml

Hi,

you should use equal operator in the filter right? i thought you want to get specific accountid. With your fetchxml, you will get all account with parent account number is not empty.
Community Member Microsoft Employee on at

Like (0)

Report

RE: a quick help on fetch xml

I am adding screenshot to show you what I am using and what I am getting, but hopefully link-entity may help is what I am assuming. Yet please check the screen shot to tell me if the fetch xml looks good, my intention is to get the account id using that parent account number.

Thanks
Suggested answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: a quick help on fetch xml

Hi,

go for related record and select the highlighted area.
Community Member Microsoft Employee on at

Like (0)

Report

RE: a quick help on fetch xml

when I use the 1st screen shot, i dont get link entity. can you please share the first screen shot again, Alex.
Community Member Microsoft Employee on at

Like (0)

Report

RE: a quick help on fetch xml

Hi Mahen, Please share the screen shot too