public async Task OrBetweenTables()
{
var obj = new CB.CloudObject("Student");
obj.Set("name", "RAVI");
var obj1 = new CB.CloudObject("hostel");
obj1.Set("room", 509);
await obj.SaveAsync();
await obj1.SaveAsync();
ArrayList tableNames = new ArrayList();
tableNames.Add("Student");
tableNames.Add("hostel");
var sq = new CB.SearchQuery();
sq.SearchOn("name", "ravi", null, null, null, null);
var sq1 = new CB.SearchQuery();
sq1.SearchOn("room", 509, null, null, null, null);
var cs = new CB.CloudSearch(tableNames);
cs.SearchQuery = new SearchQuery();
cs.SearchQuery.Or(sq);
cs.SearchQuery.Or(sq1);
var list = (List <CB.CloudObject>) await cs.Search();
var table = tableNames.ToArray();
for (int i = 0; i < list.Count; i++)
{
if (list[i].TableName != null)
{
var name = (string)list[i].TableName;
table = table.Where(val => val.ToString() != name).ToArray();
}
}
if (table.Length == 0)
{
Assert.IsTrue(true);
}
else
{
Assert.Fail("Search on both tables with OR failed.");
}
}
public void Not(CB.SearchQuery obj)
{
this._PushInMustNotQuery(obj);
}
public void Or(CB.SearchQuery obj)
{
this._PushInShouldQuery(obj);
}
public void And(CB.SearchQuery obj)
{
this._PushInMustQuery(obj);
}
