Table with Summary (Mui only)

  • Updated
General

The list view can have the summary rows at the bottom (list view only)

  • Each row is an array of values.

  • A null value indicates an empty cell.

  • If a value is an object, it should have a value key and an align key.

Table with Summary1.png

Example 130. Code JSON

"appearance": {
  "summary: {
    "rows": [
      {"row": [
        "Total Accounts", null, null,
        {
          "value": "$this.count();",
          "align": "right"          
        }
        
        ]},
        {"row": [
          "Total Annual Revenue", null, null,
          {
            "value": "$this.sum(AnnualRevenue, currency);",
            "align": "right"            
          }
          ]}
          ]}

Table with summary

Code JSON
Table with Summary2.png

Example 131. Code JSON

"summary: {
  "prefixSpan": 2,
  "rows": [
    {"row": [
      "Total Accounts", {
        "value": "$this.count();",
        "align": "right"      }
    ]...  ]}
Table with Summary3.png

Example 132. Code JSON

"summary: {
  "suffixSpan": 2,
  "rows": ...
Table with Summary4.png

Example 133. Code JSON

"summary: {
  "prefixSpan": 1,
  "suffixSpan": 1,
  "rows": ...
Table with Summary5.png

Use "prefixSpan": 1 for the multi-selection check box column.

Example 134. Code JSON

"summary": {
  "prefixSpan": 1,
  "rows": [
    {"row": [
      "Total Accounts",
      null,
      null,
      {
        "align": "right",
        "value": "$this.count();"      }
    ]},
    {"row": [
      "Total Annual Revenue",
      null,
      null,
      {
        "align": "right",
        "value": "$this.sum(AnnualRevenue, currency);"      }
    ]}
  ]
}
Table with Summary6.png
Table with Summary7.png

summary supports conditional entry.

Example 135. Code JSON

"appearance": {
  "renderFields": {
    "Phone": "$global.attr(showPhone); == true"  },
  "summary": [{
    "value": {
      "prefixSpan": 1,
      "rows": [
        {"row": ["Total Accounts", null, null, {"align": "right", "value": "$this.count();"}]},
        {"row": ["Total Annual Revenue", null, null, {"align": "right", "value": "$this.sum(AnnualRevenue, currency);"}]}
      ]
    },
    "condition": "$global.attr(showPhone); == true"  }, {
    "value": {
      "prefixSpan": 1,
      "rows": [
        {"row": ["Total Accounts", null, {"align": "right", "value": "$this.count();"}]},
        {"row": ["Total Annual Revenue", null, {"align": "right", "value": "$this.sum(AnnualRevenue, currency);"}]}
      ]
    },
    "condition": "$global.attr(showPhone); != true"  }]
}
Status

Release Available

Status

Framework Name

3.4

Current

MUI