Microsoft Dynamics CRM (Archived)

How to pass dynamic variable value as array for a attribute in fetchxml?

(0) Share

Report

Posted on by Abdelrhman Hiba

321

i want to pass multiple variable to my below FetchXML for (msdyn_workorderid) parametar

in my case i pass 10 ststic parametars

Is there another solution that makes it automatic?

Without installing the number of fild?

My FetchXML:

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

PranavShroti 4,510 on at

Like (1)

Report

Hi

Unfortunately, there is no direct way of doing this in current SDK version.

You can try giving individual elements as arguments: (indicative code)

string fetchxml = @"<fetch mapping='logical'>

<entity name='contact'>

<attribute name='firstname' />

<filter type='and'>

<condition attribute='lastname' operator='not-in'>

<value>"+array[0]+@"</value>

<value>"+array[1]+@"</value>

</condition>

</filter>

</entity>

</fetch>";

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,256 on at

Like (1)

Report

Hi,

Could you please help me understanding more about the situation, where are you using this fetchxml? and from where you are fetching these static guid id's?

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
Hi ,

Make sure you are passing GUID within {}.

You can prepare the fetchXML using Advanced Find. Here is sample one -

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="account"> <attribute name="name" /> <attribute name="primarycontactid" /> <attribute name="telephone1" /> <attribute name="accountid" /> <order attribute="name" descending="false" /> <filter type="and"> <condition attribute="primarycontactid" operator="in"> <value>{25A17064-1AE7-E611-80F4-E0071B661F01}</value> <value>{49A0E5B9-88DF-E311-B8E5-6C3BE5A8B200}</value> <value>{9DA07064-1AE7-E611-80F4-E0071B661F01}</value> </condition> </filter> </entity> </fetch>

Try to write like below -

var fetchXml = "<fetch distinct='true'>"+ "<entity name='msdyn_workorder'>" + "<attribute name='msdyn_workorderid'/>" + "<attribute name='msdyn_serviceaccount'/>" + "<attribute name='msdyn_systemstatus'/>" + "<filter type='and'>" + "<condition attribute='msdyn_workorderid' operator='in'>" for (var i = 0; i < GuidArray.length; i++) { // Assuming that you have array of Guid which is GuidArray . fetchXml += "<value>" + GuidArray[i] + "</value>"; } fetchXml += "</condition ><condition attribute='msdyn_systemstatus' operator='in' >" + "<value>1</value>" + "<value>2</value>" + "<value>3</value>" + "</condition>" + "</filter >" + "</entity >" + "</fetch >";

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (1)

Report

Hi Abdelrhman,

Using for loop you can add 'Value' node dynamically as suggested by Pranav

Was this reply helpful? Yes No
Abdelrhman Hiba 321 on at

Like (0)

Report

i use that fetxhxml to create API for Mobile Application

Was this reply helpful? Yes No
Abdelrhman Hiba 321 on at

Like (0)

Report

But anywhere put GuidArray array ?

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report

Yes you can declare before preparing the fetchXML like below -

var GuidArray= ["{25A17064-1AE7-E611-80F4-E0071B661F01}", "{25A17064-1AE7-E611-80F4-E0071B661F01}", "{25A17064-1AE7-E611-80F4-E0071B661F01}"];

Was this reply helpful? Yes No
Abdelrhman Hiba 321 on at

Like (0)

Report

thanks Goutam

for your answer

Was this reply helpful? Yes No
Gyllentid 10 on at

Like (0)

Report

This is quite difficult to understand where to put it. Am I assuming correctly this is done in Power Auttomate?

Was this reply helpful? Yes No