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
