How to use a local variable in Caml Query? C#

Question

I have a caml query and I have a list item in SharePoint list named testb and it is of DateTime type. But I was wondering if I could use a local variable like one I declared testBdate. Can I use testBdate or how to use a variable like this in <FieldRef Name ='' ?

DateTime testBdate = DateTime.Now;

queryMuaj.Query = "<OrderBy>" +
                            "<FieldRef Name ='testb' Ascending = 'TRUE'/>" +
                      "</OrderBy>" +
                      "<Where>" +
                      "<And>" +
                      "<Eq><FieldRef Name='Kompania' /><Value Type='Text'>" + selvalcomp + "</Value></Eq>"+
                      "<And>" +
                            "<Geq>" +
                             "<FieldRef Name='testb' />" +
                                "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + startDateFx + "</Value>" +
                            "</Geq>" +
                            "<Leq>" +
                                "<FieldRef Name='testb' />" +
                                "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + endDatFx + "</Value>" +
                            "</Leq> " +
                          "</And>" +
                          "</And>" +
                       "</Where>";

Thanks

What are you trying to achieve exactly at a higher level?

Submits
– Submits

2016-09-21 09:53:18 +00:00
Commented Sep 21, 2016 at 9:53 — Submits
– Submits, Commented Sep 21, 2016 at 9:53

Mohamed El-Qassas MVP · Accepted Answer · 2016-09-21 09:58:38Z

Name Attribute is Optional Text that provides the internal name of the field that is referenced.

So try to create a new variable that will hold the internal name of your field and set it via String.Format

string FileReferenceInternalFieldName = "internal field name";


queryMuaj.Query =  String.Format("@<OrderBy>" +
                            "<FieldRef Name ='{0}' Ascending = 'TRUE'/>" +
                      "</OrderBy>" +
                      "<Where>" +
                      "<And>" +
                      "<Eq><FieldRef Name='Kompania' /><Value Type='Text'>" + selvalcomp + "</Value></Eq>"+
                      "<And>" +
                            "<Geq>" +
                             "<FieldRef Name='testb' />" +
                                "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + startDateFx + "</Value>" +
                            "</Geq>" +
                            "<Leq>" +
                                "<FieldRef Name='testb' />" +
                                "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + endDatFx + "</Value>" +
                            "</Leq> " +
                          "</And>" +
                          "</And>" +
                       "</Where>", FileReferenceInternalFieldName);

See also Create dynamic caml query in sharepoint

Juan Pablo Pussacq Laborde · Accepted Answer · 2016-09-21 10:49:44Z

2

DateTime testBdate = DateTime.Now;
string testBdateISO = SPUtility.CreateISO8601DateTimeFromSystemDateTime(testBdate);

And in the CAML:

<FieldRef Name='yourfieldname'/><Value Type='DateTime'>" + testBdateISO + "</Value>

answered Sep 21, 2016 at 10:49

Juan Pablo Pussacq Laborde

3,3792 gold badges17 silver badges24 bronze badges

Add a comment |

Stack Exchange Network

How to use a local variable in Caml Query? C#

2 Answers 2

Your Answer

Hot Network Questions

How to use a local variable in Caml Query? C#

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions