public void SharepointUtils_BuildCamlQuery_ValidFilters_HasQueryWithAnd()
{
//------------Setup for test--------------------------
var sharepointUtils = new SharepointUtils();
//------------Execute Test---------------------------
var camlQuery = sharepointUtils.BuildCamlQuery(new ExecutionEnvironment(), new List <SharepointSearchTo> {
new SharepointSearchTo("Title", "Equal", "Bob", 1)
{
InternalName = "Title"
}, new SharepointSearchTo("ID", "Equal", "1", 1)
{
InternalName = "ID"
}
}, new List <ISharepointFieldTo> {
new SharepointFieldTo {
InternalName = "Title", Type = SharepointFieldType.Text
}, new SharepointFieldTo {
InternalName = "ID", Type = SharepointFieldType.Number
}
}, 0);
//------------Assert Results-------------------------
Assert.AreEqual("<View><Query><Where><And><FieldRef Name=\"Title\"></FieldRef><Value Type=\"Text\">Bob</Value>" + Environment.NewLine + "<FieldRef Name=\"ID\"></FieldRef><Value Type=\"Integer\">1</Value>" + Environment.NewLine + "</And></Where></Query></View>", camlQuery.ViewXml);
}
public void SharepointUtils_BuildCamlQuery_NoFilters_ShouldBeCreateAllItemsQuery()
{
//------------Setup for test--------------------------
var sharepointUtils = new SharepointUtils();
//------------Execute Test---------------------------
var camlQuery = sharepointUtils.BuildCamlQuery(new ExecutionEnvironment(), new List <SharepointSearchTo>(), new List <ISharepointFieldTo>(), 0);
//------------Assert Results-------------------------
Assert.AreEqual(CamlQuery.CreateAllItemsQuery().ViewXml, camlQuery.ViewXml);
}
public void SharepointUtils_BuildCamlQuery_ValidFilter_In_TextResultCommaSeperated()
{
//------------Setup for test--------------------------
var sharepointUtils = new SharepointUtils();
var executionEnvironment = new ExecutionEnvironment();
//------------Execute Test---------------------------
var camlQuery = sharepointUtils.BuildCamlQuery(executionEnvironment, new List <SharepointSearchTo> {
new SharepointSearchTo("Title", "In", "bob,dora", 1)
{
InternalName = "Title"
}
}, new List <ISharepointFieldTo> {
new SharepointFieldTo {
InternalName = "Title", Type = SharepointFieldType.Text
}
}, 0);
//------------Assert Results-------------------------
Assert.AreEqual("<View><Query><Where><In><FieldRef Name=\"Title\"></FieldRef><Values><Value Type=\"Text\">bob</Value><Value Type=\"Text\">dora</Value></Values></In>" + Environment.NewLine + "</Where></Query></View>", camlQuery.ViewXml);
}