public void PurgeRecords(Query query)
{
var purge = new PurgeRecords.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.Build();
purge.Post();
Records.Clear();
}
public string GenCsv(Query query)
{
var genResultsTable = new GenResultsTable.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.SetOptions("csv")
.Build();
var xml = genResultsTable.Post().CreateNavigator();
return xml.SelectSingleNode("/response_data").Value;
}
public int QueryCount(Query query)
{
var doQuery = new DoQueryCount.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.Build();
var xml = doQuery.Post().CreateNavigator();
return int.Parse(xml.SelectSingleNode("/qdbapi/numMatches").Value);
}
public void Query(Query query, int[] clist, int[] slist, string options)
{
var solList = GetSortList(slist);
var colList = GetColumnList(clist);
var doQuery = new DoQuery.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.SetCList(colList)
.SetSList(solList)
.SetOptions(options)
.SetFmt(true)
.Build();
_doQuery(doQuery);
}
public void Query(Query query, string options)
{
var doQuery = new DoQuery.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.SetCList("a")
.SetOptions(options)
.SetFmt(true)
.Build();
_doQuery(doQuery);
}
public void Query(Query query, int[] clist, int[] slist, string options)
{
var solList = GetSortList(slist);
var colList = GetColumnList(clist);
var doQuery = new DoQuery.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.SetCList(colList)
.SetSList(solList)
.SetOptions(options)
.SetFmt(true)
.Build();
var xml = doQuery.Post().CreateNavigator();
LoadColumns(xml);
LoadRecords(xml);
}
public void Query(Query query, string options)
{
var doQuery = new DoQuery.Builder(Application.Client.Ticket, Application.Token, Application.Client.AccountDomain, TableId)
.SetQuery(query.ToString())
.SetCList("a")
.SetOptions(options)
.SetFmt(true)
.Build();
var xml = doQuery.Post().CreateNavigator();
LoadColumns(xml);
LoadRecords(xml);
}