Welcome
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
Schema design
A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
Functions and Expressions
Lookup and reference functions
EXTRACT

Release Notes
This document includes information about What’s new, installation and upgrade instructions, known issues, and contact information of HCL Customer Support.
System Requirements
Getting started guide
This guide, which is intended for new users, provides an overview and some task flows to get you started with HCL OneTest™ Server.
Administrator guide
This guide, which is intended for an administrator, describes how to install HCL OneTest™ Server software. After you install the software, you can administer the server. Administration tasks can include License configuration, User management, Security, Memory and disk usage management, Backup and restore user data.
Test Author guide
This guide, which is intended for a tester and test manager, describes how to create test assets in HCL OneTest™ Server and publish test assets to the Git repository that you have configured.
Test Execution Specialist guide
This guide, which is intended for a tester or a test execution specialist, describes tasks that you must complete before you can configure and run tests on HCL OneTest™ Server. You can find information about other tasks that you can perform on the Resource Monitoring Service, Virtualization, and Integrations with third-party applications.
Test Manager guide
This guide, which is intended for a test manager, explains how to manage and track your overall test effort.
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
- Files
  You add a file to a project to use it as input in the project. You can upload a file from your local file system to a project from the Files tab to generate test data. Alternatively, you can upload it when you define an action.
- Connections
  A connection defines the properties that are required to connect to an external resource. An action uses a connection to provide source data to a project or write data from a source to a target. Multiple actions can use the same connection. You can define both connections and actions at the project level.
- Schema design
  A schema is a graphical data dictionary that contains metadata definitions of the structure of a document to generate test data. Schema provides visual cues for understanding the structure and complete definition of an object.
  - Introduction to schema design
    Use the Schemas tab to define, modify, and view schemas. A schema describes the syntax, structure, and semantics of your data.
  - Type properties
    The properties of a type define the characteristics of the data objects of that type.
  - Item restrictions
    Item restrictions are an optional feature you can use to specify valid or invalid data objects for an item type. Item restrictions are grouped into three categories: Value, Character, and Range.
  - Components
  - Partitioning
  - Type inheritance
  - Schema analyzer
  - Distinguishable objects
  - Functions and Expressions
    - Expressions and evaluations
    - Using functions
    - Syntax of a function
    - Function argument syntax
    - Functions that convert character-set encoding to the native code page
    - General functions
    - Bidirectional functions
    - Bit manipulation and testing functions
    - Conversion functions
    - Date/time functions
    - Error handling functions
    - External interface functions
    - Inspection functions
    - Logical functions
    - Lookup and reference functions
      - CHOOSE
      - DBLOOKUP
      - DBQUERY
      - DDEQUERY
      - EXTRACT
      - GETANDSET
      - GETDIRECTORY
      - GETITXUID
        The GETITXUID function returns a universally unique identifier (UUID).
      - GETLOCALE
        The GETLOCALE function returns the locale setting of the computer.
      - GETFILENAME
      - GETPARTITIONNAME
      - GETRESOURCEALIAS
        The GETRESOURCEALIAS function returns the resource alias value specified in a Resource Registry resource name file (.mrn).
      - GETRESOURCENAME
      - GETTXINSTALLDIRECTORY
        The GETTXINSTALLDIRECTORY function returns the HCL OneTest™ Data product installation directory.
      - INDEX
      - INDEXABS
      - LASTERRORCODE
      - LASTERRORMSG
      - LOOKDOWN
      - LOOKUP
      - MEMBER
      - SEARCHDOWN
      - SEARCHUP
      - SORTDOWN
      - SORTDOWNBY
      - SORTUP
      - SORTUPBY
      - UNIQUE
      - GETENV
        The GETENV function returns the value of the environment variable. If no variable exists, an empty string is returned.
      - GETOSNAME
        The GETOSNAME function returns the name of the operating system.
    - Math and statistics functions
    - Text functions
    - XML functions
    - Custom functions
    - Date and time format strings
    - Number format strings
    - RUN function return codes
    - Character set codes for CPACKAGE, CSERIESTOTEXT, and CTEXT
Troubleshooting HCL OneTest™ Server
While working with HCL OneTest™ Server, you might encounter some problems that you can easily troubleshoot.
All Guides (PDF)
You can find the link to view or download the content of the release notes, system requirements, and persona guides of HCL OneTest™ Server as a PDF file.
Security considerations
For HCL OneTest™ Server, you can take actions to ensure that your installation is secure, customize your security settings, and set up user access controls.
Notices

EXTRACT

Use EXTRACT whenever you need only particular members of a series returned-those that meet a certain condition. An example might be only POs that contain back-ordered items.

The EXTRACT function can only be used in a map rule. It cannot be used in a component rule.

The EXTRACT function returns all members of a series for which a specified condition is true.

Syntax:: EXTRACT (series-object-expression, single-condition-expression)
Meaning:: EXTRACT (objects_to_extract, condition_to_evaluate)
Returns:: A series object.

The result is each member of series_to_search for which the condition specified by condition_to_evaluate evaluates to "true". EXTRACT returns "none", if no member of series_to_search has a corresponding condition_to_evaluate that evaluates to "true".

Examples

EXTRACT ( PO:Transaction , Store# = Location:PO:Transaction )
This example returns all POs, individually, whose Location is a particular Store#.
EXTRACT ( Row:DBSelect , ProcessFlag Column:Row:DBSelect = "Y" )
This example returns all Rows that have a ProcessFlag Column value of "Y".

Related Functions

CHOOSE
LOOKUP
SEARCHDOWN
SEARCHUP