
【场景】WebApi 查询单据转换规则
【案例】
表单标识 单据转换规则 BOS_ConverRule
<1>根据名称查询
```json
{
"FormId": "BOS_ConvertRule",
"FieldKeys": "FNumber,FName",
"FilterString": [
{
"Left": "(",
"FieldName": "FName",
"Compare": "=",
"Value": "采购申请单至采购订单-仅携带",
"Right": ")",
"Logic": "and"
}
],
"OrderString": "",
"TopRowCount": 0,
"StartRow": 0,
"Limit": 2000,
"SubSystemId": ""
}
```


<2>根据源单标识和目标单标识查询
a)打开设计器,表单BOS_ConverRule,扩展增加两个文本字段,字段名指向fsourceformid, ftargetformid
(需要修改字段的存储类型为varchar)


```json
{
"FormId": "BOS_ConvertRule",
"FieldKeys": "FNumber,FName",
"FilterString": [
{
"Left": "(",
"FieldName": "F_Jac_TextSrc",
"Compare": "=",
"Value": "PUR_Requisition",
"Right": ")",
"Logic": "and"
},
{
"Left": "(",
"FieldName": "F_Jac_TextTgt",
"Compare": "=",
"Value": "PUR_PurchaseOrder",
"Right": ")",
"Logic": "and"
},
],
"OrderString": "",
"TopRowCount": 0,
"StartRow": 0,
"Limit": 2000,
"SubSystemId": ""
}
```

【备注】其他字段查询的逻辑同<2>,需要自行增加字段,物理表t_meta_convertrule