多处理结果表格式
从域中选择所有资产并带注解属性。每一种资产都可能有多注注数,当多注数时,最近注数应排序到表顶
上头表ViewConfig似似下例
- JSON系统
- YAML
狗万新闻c{ "TableViewConfig": { "Resources": { "Asset": { "Id": { "name": "assetId" }, "Signifier": { "name": "assetName" }, "StringAttribute": { "LongExpression": { "name": "note" }, "CreatedOn": { "name": "noteCreatedOn" }, "Order": [ { "Field": { "name": "noteCreatedOn", "order": "DESC" } } ] }, "Domain": { "Id": { "name": "domainId" } }, "Filter": { "Field": { "name": "domainId", "operator": "EQUALS", "value": "f342423f-54fd-4643-935b-adbd9e7f5e25" } }, "Order": [ { "Field": { "name": "assetName" } } ] } }, "Columns": [ { "Column": { "fieldName": "assetId" } }, { "Column": { "fieldName": "assetName" } }, { "Column": { "fieldName": "note" } } ] } }狗万新闻c--- TableViewConfig: Resources: Asset: Id: name: "assetId" Signifier: name: "assetName" StringAttribute: LongExpression: name: "note" CreatedOn: name: "noteCreatedOn" Order: - Field: name: "noteCreatedOn" order: "DESC" Domain: Id: name: "domainId" Filter: Field: name: "domainId" operator: "EQUALS" value: "f342423f-54fd-4643-935b-adbd9e7f5e25" Order: - Field: name: "assetName" Columns: - Column: fieldName: "assetId" - Column: fieldName: "assetName" - Column: fieldName: "note"视请求格式而定,结果可能不同excel或CSV格式中,每个资产都为每个注值在新行复制
类似使用SQL查询并发双表并存一对多关系与SQL不同的是,如果选择带注注和三大职责的资产,则该资产使用Excel表三行,非六行,注列第三行为空
JSON格式则不向结果添加重复行反之,它返回发现的第一个注解并丢弃其他注解
首注缺失商业资产1
{ "iTotalDisplayRecords": 3, "iTotalRecords": 3, "aaData": [ { "assetId": "c20d5b39-6c5d-411b-adcb-82a1dd3851cc", "assetName": "Business Term 1", "note": "Second Note" }, { "assetId": "1a6a8f73-43b0-4a29-84c3-baaa3467be70", "assetName": "Business Term 2", "note": "Single note on BT2" }, { "assetId": "7329349e-0631-41a7-a740-738979d887c6", "assetName": "Business Term 3", "note": "Single Note on BT3" } ] }表格格式不重复行时,可添加分组映射构造列内段内
- JSON系统
- YAML
狗万新闻c{ "TableViewConfig": { "Resources": { "Asset": { "Id": { "name": "assetId" }, "Signifier": { "name": "assetName" }, "StringAttribute": { "LongExpression": { "name": "note" }, "CreatedOn": { "name": "noteCreatedOn" }, "Order": [ { "Field": { "name": "noteCreatedOn", "order": "DESC" } } ] }, "Domain": { "Id": { "name": "domainId" } }, "Filter": { "Field": { "name": "domainId", "operator": "EQUALS", "value": "f342423f-54fd-4643-935b-adbd9e7f5e25" } }, "Order": [ { "Field": { "name": "assetName" } } ] } }, "Columns": [ { "Column": { "fieldName": "assetId" } }, { "Column": { "fieldName": "assetName" } }, { "Group": { "name": "Notes", "Columns": [ { "Column": { "fieldName": "note" } } ] } } ] } }狗万新闻c--- TableViewConfig: Resources: Asset: Id: name: "assetId" Signifier: name: "assetName" StringAttribute: LongExpression: name: "note" CreatedOn: name: "noteCreatedOn" Order: - Field: name: "noteCreatedOn" order: "DESC" Domian: Id: name: "domainId" Filter: Field: name: "domainId" operator: "EQUALS" value: "f342423f-54fd-4643-935b-adbd9e7f5e25" Order: - Field: name: "assetName" Columns: - Column: fieldName: "assetId" - Column: fieldName: "assetName" - Group: name: "Notes" Columns: - Column: fieldName: "note"A级分组映射允许单父组合多项结果A级分组必须接收用户定义名称,格式化结果时使用
{ "iTotalDisplayRecords": 3, "iTotalRecords": 3, "aaData": [ { "assetId": "c20d5b39-6c5d-411b-adcb-82a1dd3851cc", "assetName": "Business Term 1", "Notes": [ { "note": "Second Note" }, { "note": "First note" } ] }, { "assetId": "1a6a8f73-43b0-4a29-84c3-baaa3467be70", "assetName": "Business Term 2", "Notes": [ { "note": "Single note on BT2" } ] }, { "assetId": "7329349e-0631-41a7-a740-738979d887c6", "assetName": "Business Term 3", "Notes": [ { "note": "Single Note on BT3" } ] } ] }有一些规则 关于分组:
分组映射无法嵌套分组定义内分组不支持 。- 组内所有列必须关联到同父实体