Selektions-Configuration-Json

selection.jsonc

{
  // selection configuration 
  "selection": {
    "id": "d9894513-ad86-40e5-be91-4d55f9e33c6d",
    "name": {
      "de": "Personen"
    },

    "pagination": {
      "enabled": true,
      "limit": 25,
      "limits": [
        "25",
        "50",
        "100"
      ]
    },

    // parameters to filter the data
    "parameters": [
      {
        "id": "ebe3dc54-f743-4800-bfa0-47d546b38cf8",
        "field": "CRM.Persons.Id",
        "type": "text",
        "operators": [
          "contains",
          "does not contain",
          "is equal",
          "is not equal",
          "begins with",
          "does not begin with",
          "ends with",
          "does not end with",
          "is empty",
          "is not empty"
        ],
        "display": true,
        "default": null,
        "required": false,
        "options": {},
        "order": 0
      },
      {
        "id": "4f2dad92-0c22-4a38-9661-d876d4ce16be",
        "field": "CRM.Person.Country",
        "type": "single-select",
        "operators": [
          "contains",
          "is equal",
          "is not equal"
        ],
        "display": true,
        "default": null,
        "required": false,
        // Type based control options
        "options": {
          "ajax": true,
          "source": {
            "type": "lookup",
            "id": "countries"
          },
          "data": [] // Use static data if ajax is false
        },
        "order": 1
      }
    ],

    // tables columns
    "fields": [
      {
        "id": "aac103e9-2927-4288-8a77-d5a8f77dd1db",
        "field": "CRM.Persons.Id",
        "type": "number",
        "label": {
          "de": "ID"
        },
        "description": {
          "de": "Interne ID des Datensatzes"
        },
        "display": false,
        "isPrimary": true,
        "sorting": {
          "fixed": true,
          "initial": null,
          "directions": ["asc", "desc"]
        },
        "order": 0
      }
    ],

    // Buttons rendered as the first column for each row
    "actions": [
      {
        "type": "icon-btn",
        "options": {
          "icon": "user",
          "link": "/person/$(CRM.Persons.Id)",
          "tooltip": {
            "de": "Person: $(CRM.Persons.FirstName) $(CRM.Persons.LastName)"
          }
        }
      }
    ],

    // Data sources used in the fields
    "dataSources": [
      {
        "id": "CRM.Person",
        "isPrimary": true
      },
      {
        "id": "TERP.Tickets",
        "isPrimary": false,
        "join": {
          "on": "CRM.Person",
          "foreign": "Id",
          "local": "PersonInternalId"
        }
      }
    ]
  }
}