-
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
Last Updated On
- 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