Syntax
alterAlternativeSortOrderCommand = ( OMBALTER ALTERNATIVE_SORT_ORDER
"QUOTED_STRING" ( ( "renameClause" [ SET
"setPropertiesClauseforLOVandD2D" ] [ SET "setReferenceIconSetClause"
] [ UNSET "unsetReferenceIconSetClause" ] {
"alterAlternativeSortOrderClauses" } ) | ( SET
"setPropertiesClauseforLOVandD2D" [ SET "setReferenceIconSetClause" ]
[ UNSET "unsetReferenceIconSetClause" ] {
"alterAlternativeSortOrderClauses" } ) | ( SET
"setReferenceIconSetClause" [ UNSET "unsetReferenceIconSetClause" ] {
"alterAlternativeSortOrderClauses" } ) | ( UNSET
"unsetReferenceIconSetClause" { "alterAlternativeSortOrderClauses" } )
| ( "alterAlternativeSortOrderClauses" {
"alterAlternativeSortOrderClauses" } ) ) )
renameClause = RENAME TO "QUOTED_STRING"
setPropertiesClauseforLOVandD2D = PROPERTIES "("
"propertyNameListforLOVandD2D" ")" VALUES "(" "propertyValueList" ")"
setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
unsetReferenceIconSetClause = ( REFERENCE | REF ) ICONSET
alterAlternativeSortOrderClauses = SET ( REF | REFERENCE )
"addAlternativeSortOrderClauseforAlter" | UNSET ( REF | REFERENCE )
"deleteAlternativeSortOrderClauses" |
"addAlternativeSortOrderReferenceClause"
propertyNameListforLOVandD2D = ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) {
"," ( "UNQUOTED_STRING" | DRILL_TO_DETAIL ) }
propertyValueList = "propertyValue" { "," "propertyValue" }
addAlternativeSortOrderClauseforAlter = ( DEFINING ITEM "QUOTED_STRING" OF
ITEM_FOLDER "QUOTED_STRING" ) | ( ORDERED ITEM "QUOTED_STRING" OF
ITEM_FOLDER "QUOTED_STRING" )
deleteAlternativeSortOrderClauses = ( DEFINING ITEM ) | ( ORDERED ITEM ) |
( ITEM "QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING" )
addAlternativeSortOrderReferenceClause = SET ( REF | REFERENCE ) ITEM
"QUOTED_STRING" OF ITEM_FOLDER "QUOTED_STRING"
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
Parameters
alterAlternativeSortOrderCommand
This clause alters an alternative sort order.
QUOTED_STRING
name of the alternative sort order.
renameClause
Renames an alternative sort order with a different name.
setPropertiesClauseforLOVandD2D
This clause sets the properties of the object.
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.
unsetReferenceIconSetClause
Unset specified Icon Set.
alterAlternativeSortOrderClauses
This clause modifies an alternative sort order.
propertyNameListforLOVandD2D
This is the list of property names.
propertyValueList
This is the list of property values.
addAlternativeSortOrderClauseforAlter
This clause sets the defining item or ordering item for the alternative sort order.
DEFINING
This sets the defining item for the alternative sort order.
ORDERED
This sets the ordered item for the alternative sort order.
deleteAlternativeSortOrderClauses
This deletes specific item references from an alternative sort order.
DEFINING
This deletes the defining item from an alternative sort order.
ITEM
This deletes a reference to an item from an alternative sort order.
ORDERED
This deletes the ordered item from an alternative sort order.
addAlternativeSortOrderReferenceClause
This adds a reference to an item to an alternative sort order.
propertyValue
This is a property value.
ALTERNATIVE_SORT_ORDER Object
