Home
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
SORTDOWN

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

SORTDOWN

Use the SORTDOWN function to sort objects in a series in descending sequence. The function returns a series containing the values from the input series in descending order.

When the character set of the data is ASCII, the objects are sorted in ASCII descending order.
For all other character sets, the objects are sorted in binary descending order.

Syntax:: SORTDOWN (series-item-expression)
Meaning:: SORTDOWN (item_series_to_sort)
Returns:: A series object

Returns the values in item_series_to_sort in descending order.

Examples

SORTDOWN ( Abbr:File )
In this example, if Abbr has these ASCII values:

ABC, GHI, DEF

SORTDOWN returns these values as a series as:

GHI, DEF, ABC

The following table displays the results of using the SORTDOWN and SORTUP functions for a typical series of ASCII text items.


Original Input Series	Result using SORTDOWN	Result using SORTUP
Clams Casino	shrimps	1 Shrimp
Grouper	raw oysters	22 Shrimp
groupers	oysters	A
Shrimp	lobster tails	A 1 A shrimp
shrimps	lobster	A1A Shrimp
lobster	groupers	AA
lobster tails	clams	AAAAA
oysters	aaaaa	Clams Casino
raw oysters	aa	Grouper
clams	a	Rock Lobster
SHRIMP	Snapper	SHRIMP
1 Shrimp	Snapper	Shark Fin Soup
22 Shrimp	Shrimp	Shrimp
A 1 A shrimp	Shark Fin Soup	Snapper
A1A Shrimp	SHRIMP	Snapper
AAAAA	Rock Lobster	a
aaaaa	Grouper	aa
aa	Clams Casino	aaaaa
AA	AAAAA	clams
A	AA	groupers
a	A1A Shrimp	lobster
Rock Lobster	A 1 A shrimp	lobster tails
Snapper	A	oysters
Snapper	22 Shrimp	raw oysters
Shark Fin Soup	1 Shrimp	shrimps

Related functions

SEARCHDOWN
SEARCHUP
SORTUP
UNIQUE