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
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值