public void WhenAddFilterField(string filterField, Table criteria) { foreach (var criteriaRow in criteria.Rows) { AdHocQueryDialog.AddFilterField(filterField, criteriaRow); } }
public void WhenAddOutputFields(Table outputFields) { foreach (var outputField in outputFields.Rows) { AdHocQueryDialog.FilterBy(outputField["Path"]); AdHocQueryDialog.AddOutputField(outputField["Field"]); } }
public void WhenSetSaveOptions(Table saveOptions) { foreach (var option in saveOptions.Rows) { option["Name"] = option["Name"] + uniqueStamp; AdHocQueryDialog.SetSaveOptions(option); } AdHocQueryDialog.SaveAndClose(); }
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 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); } }
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); } }
public void WhenSetSaveOptions(Table saveOptions) { try { //set save options for the adhoc query foreach (var option in saveOptions.Rows) { AdHocQueryDialog.SetSaveOptions(option); } AdHocQueryDialog.Save(); } catch (Exception ex) { throw new Exception("Error: could not set save options 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 WhenSetQuerySaveOptions(Table saveOptions) { try { //save the details which are in the table for the Save Options for the query foreach (var option in saveOptions.Rows) { option["Name"] = option["Name"] + uniqueStamp; AdHocQueryDialog.SetSaveOptions(option); } AdHocQueryDialog.SaveAndClose(); // save and close the query System.Threading.Thread.Sleep(4000); //pause because otherwise the code runs so rapidly that the next line is not invoked in time } catch (Exception ex) { throw new Exception("Error: Could not save the query options. " + ex.Message); } }
public void WhenFilterBy(string filter) { AdHocQueryDialog.FilterBy(filter); }