Add a dynamic variable value for a attribute in fetchxml

(0) Share

Report

Posted on by Community Member

Hi Guys,

Everytime and everywhere i see in fetchxml people use only harcoded values i got a scenerio were i need to pass a dynamically a string variable please suggest note this c# code

string dynamic ="xyz";

string fetch3 = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='hd_cuscatmust'>
<attribute name='hd_cuscatmustid' />
<attribute name='hd_cusseqnum' />
<attribute name='createdon' />
<order attribute='hd_cusseqnum' descending='false' />
<filter type='and'>
<condition attribute='hd_cusmercod' operator='not-null' />
<condition attribute='hd_cuscatcod' operator='not-null' />
<condition attribute='hd_cusmercod' operator='eq' value=""+dynamic+@"">
</filter>
</entity>
</fetch>";

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Community Member on at

Like (0)

Report

its throws a invalid xml exception

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (3)

Report

Try to use following:

string dynamic ="xyz";

string fetch3 = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>

<entity name='hd_cuscatmust'>

<attribute name='hd_cuscatmustid' />

<attribute name='hd_cusseqnum' />

<attribute name='createdon' />

<order attribute='hd_cusseqnum' descending='false' />

<filter type='and'>

<condition attribute='hd_cusmercod' operator='not-null' />

<condition attribute='hd_cuscatcod' operator='not-null' />

<condition attribute='hd_cusmercod' operator='eq' value='"+dynamic+@"' />

</filter>

</entity>

</fetch>";

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Works awesome thank you Andrii

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

please close the thread by verifying the answer it might be helpful to others

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

not mine sorry its signature

Was this reply helpful? Yes No
Suggested answer

Aman Kothari on at

Like (1)

Report

Hi,

You can also use String.Format method for providing dynamic value to string.

Here is example

string dynamic ="xyz";

string fetch3 =String.Format(@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='hd_cuscatmust'>
<attribute name='hd_cuscatmustid' />
<attribute name='hd_cusseqnum' />
<attribute name='createdon' />
<order attribute='hd_cusseqnum' descending='false' />
<filter type='and'>
<condition attribute='hd_cusmercod' operator='not-null' />
<condition attribute='hd_cuscatcod' operator='not-null' />
<condition attribute='hd_cusmercod' operator='eq' value='{0}'>
</filter>
</entity>
</fetch>", dynamic);

For more info about String.Format methoe please check below url

https://msdn.microsoft.com/en-us/library/system.string.format(v=vs.110).aspx

Thanks

Was this reply helpful? Yes No
Albert_ 458 on at

Like (0)

Report

Hi sir,

I use SQL Server BI Develope, and I put a textbox from toolbox in top of the report.

How can I do it dynamically?

I mean fill the value of a field with that end-user filled out string in the textbox.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andrew.. I have a question. I have a CRM application and i am pulling data from CRM using Kingsway soft CRM source editor.

In that i am writing the fetchXML, but i would to like to one of the column value into a variable.

I tried below and its not working, please help.

<fetch version="1.0" mapping="logical" aggregate="true">

<entity name=@[User::tablename]>

<attribute name=@[User::ColumnName] alias=@[User::tableAlias] aggregate="countcolumn" />

</entity>

</fetch>

Was this reply helpful? Yes No