OMBCREATE ALTERNATIVE_SORT_ORDER

Purpose

Creates an Alternative Sort Order.

Prerequisites

Should be in the context of a Business Definition Module.

Syntax

createAlternativeSortOrderCommand =  OMBCREATE ALTERNATIVE_SORT_ORDER 
          "QUOTED_STRING" [ SET "setPropertiesClauseforLOVandD2D" ] [ SET 
          "setReferenceIconSetClause" ] [ "addAlternativeSortOrderDefClause" ] [
           "addAlternativeSortOrderOrdClause" ] { 
          "addAlternativeSortOrderReferenceClause" }
     setPropertiesClauseforLOVandD2D =  PROPERTIES "(" 
          "propertyNameListforLOVandD2D" ")" VALUES "(" "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addAlternativeSortOrderDefClause =  SET ( REF | REFERENCE ) DEFINING ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     addAlternativeSortOrderOrdClause =  SET ( REF | REFERENCE ) ORDERED ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     addAlternativeSortOrderReferenceClause =  SET ( REF | REFERENCE ) ITEM 
          "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
     propertyNameListforLOVandD2D =  ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) { 
          "," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createAlternativeSortOrderCommand

This command creates an alternative sort order.

QUOTED_STRING

Specify the name of the alternative sort order to be created.

setPropertiesClauseforLOVandD2D

Used to set properties (core, logical, physical, user-defined) for an alternative sort order. Valid properties are shown below:

getPropertiesClauseforLOVandD2D

Basic properties for ALTERNATIVE_SORT_ORDER: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the alternative sort order 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the alternative sort order 

Name: DRILL_TO_DETAIL
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether the alternative sort order enables drilling between the item folders containing the items that use the alternative sort order 

Name: RETRIEVE_VALUES_GROUP_SIZE
Type: Number
Valid Values: Any valid character string in supported character set.
Default: '100'
The number of rows to be fetched from the database at a time 

Name: CACHE_VALUES
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the list of values should be cached in memory 

Name: REQUIRE_SEARCH
Type: Boolean
Valid Values: Y,N
Default: 'N'
Whether search criteria should be requested 

Name: SHOW_IN_NAVIGATOR
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be shown in the item navigator 

Name: SORTED_DISTINCT
Type: Boolean
Valid Values: Y,N
Default: 'Y'
Whether the values should be displayed sorted with duplicates hidden

setReferenceIconSetClause

Set specified Icon Set.

addAlternativeSortOrderDefClause

This clause adds a defining item.

addAlternativeSortOrderOrdClause

This clause adds an ordering item.

addAlternativeSortOrderReferenceClause

This adds a reference to an item to an alternative sort order.

propertyNameListforLOVandD2D

This is the list of property names.

propertyValueList

This is the list of property values.

propertyValue

This is a property value.

ALTERNATIVE_SORT_ORDER Object

Table 6-1 ALTERNATIVE_SORT_ORDER Object

Property	Type	Choices	Min	Max	Default	Description
DEPLOYABLE	BOOLEAN	true, false	none	none	true	Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true