public void WhenAddFilterField(string filterField, Table criteria)
{
foreach (var criteriaRow in criteria.Rows)
{
AdHocQueryDialog.AddFilterField(filterField, criteriaRow);
}
}
public void WhenAddFilterField(string filterField, Table criteria)
{
try
{ //select criteria for the filtering
foreach (var criteriaRow in criteria.Rows)
{
AdHocQueryDialog.AddFilterField(filterField, criteriaRow);
}
}
catch (Exception ex)
{
throw new Exception("Error: could not add a filter field 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();
}