-
Users Handbook
-
-
-
- Intro & Basics
- All Objects have Descriptions
- Check for unused procedures
- Compiled Procedures up to date
- Invalid Source Layers
- Required Columns
- Check for abnormally ended Jobs
- Check for blocked Jobs
- Check for disabled Tasks
- Check for duplicate tasks in different Jobs
- Check for duplicate tasks in same Job
-
-
-
Administrators Handbook
-
- Register URL
- Configure SSL/HTTPS
- Configure Proxy-Server
- How to edit the appsettings.json file
- System Settings
- Global Parameters
- Allow Service Account to Logon as a Service
- LDAP & SSO Authentication
- Migrating Testcases and Configuration
- Licenses Management
- Manual Configuration
- Exposing the BiG EVAL REST API to other Network Segments
-
- Articles coming soon
-
Developers Handbook
-
Known Problems
-
Demo Virtual Machine
-
Release Notes
-
General
Validating a list of values
- Home
- Users Handbook
- Scripting
- Examples
- Validating a list of values
Example with a static list of values
var countries = new List
{
"Australia",
"Canada",
"France",
"Germany",
"United Kingdom",
"United States"
};
foreach(var country in countries)
{
SetComment($"{country}");
SetParameter("Country", country);
await ExecuteAsync();
}
Example with values from a datasource
// Query the available sales territories from the ERP. The first parameter is the name of the datasource, and the second one is the query.
var salesTerritories = QueryTable("AW ERP", "SELECT TerritoryID, Name FROM Sales.SalesTerritory ORDER BY TerritoryID");
// Loop through the sales-territories.
foreach(DataRow salesTerritory in salesTerritories.Rows)
{
// Extract ID and Name of the current sales territory.
var salesTerritoryId = (int)salesTerritory["TerritoryID"];
var salesTerritoryName = salesTerritory["Name"].ToString();
// Write a comment to the test-result to show the current sales-territory.
SetComment($"Sales Territory: {salesTerritoryName} ({salesTerritoryId})");
// Push sales-territory-parameter to the probe-queries.
SetParameter("SalesTerritoryId", salesTerritoryId);
// Execute the test.
await ExecuteAsync();
}
Table of Contents