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(); }