siebel l 验证重复记录

使用BC

创建计算字段  F5 Duplidate flag

calc value = BCHasRows("FS Shipping", "F5 - Shipping Order Line Item Transactions", "[Serial Number]='"+[Serial Number]+"' and [Order Item Id]='"+[Order Item Id]+"'", "All")

这里Serial Number就是不允许有相同的serial number

Order Item Id   - parent bc的row_id

FS Shipping   - BO

F5 - Shipping Order Line Item Transactions -  BC

function BCHasRows

BOName

BCName

SearchSpec

Visibility

返回Y ,如果根据searchspec找到一条记录.

在对应的字段上加上validation message

Serial Number    Validation = NOT [F5 Duplidate flag]

Validation Message = No duplicate allowed.