`
Vasile
  • 浏览: 37976 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Documentum/DQL: alter type to add/mofify an attribute's search operators

阅读更多
Two sample dql statements:
ALTER TYPE <custom_type> MODIFY <attribute_name> (SET default_search_op = 1) PUBLISH;
ALTER TYPE <custom_type> ADD <attribute_name> <attribute_datatype> (SET label_text='<LABEL_TEXT>', set default_search_op = 1, truncate allowed_search_ops, set allowed_search_ops[0]= 13, set allowed_search_ops[1]= 2, set allowed_search_ops[2]= 3, set allowed_search_ops[3]= 4, set allowed_search_ops[4]= 1) PUBLISH

NOTE : This setting is inherited by subtypes but can be overridden if required by executing the same dql syntax on the subtype.

To validate that the value was set correctly, you can use Webtop and check the new default, or you can use iapi and check the the value explicitly:
get,c,t<type_name>.<attr_name>,default_search_op
get,c,t<type_name>.<attr_name>,allowed_search_ops

Please note that value of default_search_op must be one value of allowed_search_ops.

Below is a map of the integer values that corresponding to each operator:

EQUALS = 1
NOT_EQUALS = 2
GREATER_THAN = 3
LESS_THAN = 4
GREATER_EQUALS = 5
LESS_EQUALS = 6
BEGINS_WITH = 7
CONTAINS = 8
DOES_NOT_CONTAIN = 9
ENDS_WITH = 10
IN = 11
NOT_IN = 12
BETWEEN = 13
IS_NULL = 14
IS_NOT_NULL = 15
NOT = 16
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics