public void WhenAddOutputFields(Table outputFields)
{
foreach (var outputField in outputFields.Rows)
{
AdHocQueryDialog.FilterBy(outputField["Path"]);
AdHocQueryDialog.AddOutputField(outputField["Field"]);
}
}
public void WhenFilterBy(string filter)
{
try
{
AdHocQueryDialog.FilterBy(filter); //filter the query
}
catch (Exception ex)
{
throw new Exception("Error: could not filter an adhoc query. " + ex.Message);
}
}
public void WhenAddOutputFields(Table outputFields)
{
try
{ //select output fields for the query
foreach (var outputField in outputFields.Rows)
{
AdHocQueryDialog.FilterBy(outputField["Path"]);
AdHocQueryDialog.AddOutputField(outputField["Field"]);
}
}
catch (Exception ex)
{
throw new Exception("Error: could not add output fields to an adhoc query. " + ex.Message);
}
}
private static void CreateUnacknowledgedRevenueSelection(string selectionName)
{
InformationLibraryPanel.AddAdHocQuery("Revenue");
AdHocQueryDialog.FilterBy("Revenue");
AdHocQueryDialog.AddFilterField("Transaction type", CreateTransactionCriteria());
AdHocQueryDialog.AddFilterField("Date", CreateDateCriteria());
AdHocQueryDialog.FilterBy("Revenue\\Revenue Letters");
AdHocQueryDialog.AddFilterField("Acknowledge date", CreateAcknowledgeDateCriteria());
AdHocQueryDialog.FilterBy("Revenue");
AdHocQueryDialog.AddOutputField("Transaction type");
AdHocQueryDialog.FilterBy("Revenue\\Constituent");
AdHocQueryDialog.AddOutputField("Last/Organization/Group/Household name");
AdHocQueryDialog.SetSaveOptions(CreateSaveOptions(selectionName));
Dialog.Save();
}
public void WhenFilterBy(string filter)
{
AdHocQueryDialog.FilterBy(filter);
}