Dynamics Community Forum Thread Details

fechXML queue stored on database and used in plugin

i'm trying to create a rules table that would store predefined fetchXML queries to be used in in a C# plugin, i know that i can use the follwing code in a plugin

var value = "something";

var fetchXml = "<fetch>";
fetchXml += $"<entity name='account'>";
fetchXml += " <all-attributes />";
fetchXml += " <filter>";
fetchXml += $" <condition attribute='xxx_field' operator='eq' value='{value}'/>";
fetchXml += " </filter>";
fetchXml += "</entity>";
fetchXml += "</fetch>";

var entitySyncRules = service.RetrieveMultiple(new FetchExpression(fetchXml));

and it works no problem the code replaces the {vale} with something . now Ii'm trying to take this to an other level. i have a rule table entity that would store the fetchXML this would enable me to build and edit the fetchXML dinamicly

[rule entity]

storeFetchXML = <fetch><entity name='account'><all-attributes /><filter><condition attribute='xxx_field' operator='eq' value='{value}'/></filter></entity></fetch>

in the plugig

value = "something"

fetchXML = ruleentity.GetAttributeValue<string>("storeFetchXML")

var entitySyncRules = service.RetrieveMultiple(new FetchExpression(fetchXml));

this code do not work, it doest replace the {value} with the content on the variable. it leave the string as is .

is there a way to make sure that the code does the code replace . if tried the following

fetchXML = $ruleentity.GetAttributeValue<string>("storeFetchXML")

fetchXML = $"{ruleentity.GetAttributeValue<string>("storeFetchXML")}"

if i'm going down the wrong path... this is possible. but is there a way to use a stored parametrized fetchXML in a queue with the paramater being replace at run time. (yes i know the field must exist in the code)

Quick Links

Leaderboard