sx_list_query
Query a list of any Kingdee Three-Effect document (projects, reimbursements, loans, hours, budgets) by specifying form ID, fields, filter conditions, ordering, and pagination for read-only access.
Instructions
列表查询任意三效单据(官方 listQuery)。
form_id: 单据标识或中文别名,如 bdi_projectfile / "项目档案" fields: 字段标识,逗号分隔;分录字段写「分录标识.字段标识」, 如 "id,number,name,projectfileteam.teamstaff";留空取默认字段 params: qParams 条件数组,叶子形如 {"childGroup": false, "qKey": "number", "qCp": "like", "qValue": "ew"} 条件组形如 {"childGroup": true, "joinKey": "or", "childCondition": [ ...叶子... ]} 顶层各项之间是 and。比较符:=,>,>=,<,<=,!=,like,likeLeft order_by: 如 "id desc,name asc" data_permission: all 全部 / self 仅制单人自己
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fields | No | ||
| params | No | ||
| form_id | Yes | ||
| order_by | No | ||
| page_size | No | ||
| page_index | No | ||
| data_permission | No | all |