Computed Queries

request to our CUnitTemplates

get

Path parameters

group-keystringRequired

idstringRequired

presetIdinteger · int64Required

Preset-ID

Query parameters

forAdminbooleanOptional

forWorkflowbooleanOptional

Responses

200

OK

application/json

get

/cmn/computed-queries/{group-key}/{id}/presets/{presetId}

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/{group-key}/{id}/presets/{presetId} HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "version": "text",
  "info": {
    "createdAt": "2026-02-10T18:29:09.146Z",
    "createdFrom": "text",
    "updatedAt": "2026-02-10T18:29:09.146Z",
    "updatedFrom": "text"
  },
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "definition": {
        "_type": "text",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      },
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "definition": [
    {
      "_type": "text",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "userRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "groupRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "pinned": false
  }
}

put

Path parameters

group-keystringRequired

idstringRequired

presetIdinteger · int64Required

Filter-Id

Body

application/json

Adhoc Preset

versionstringOptional

Version Identifier for this Object (for PUT)

idstringOptional

Unique identifier of the Object

modestring · enumRequired

Was kann mit diesem Preset abgebildet werden QUERY oder STATEMENT

Default: QUERYPossible values:

templateIdstringRequired

template dem dieser filter zugeordnet worden ist.

templateGroupKeystringRequired

templateGroupKey dem dieser filter zugeordnet worden ist.

labelstringRequired

label für diesen filter

uiPayloadobjectOptional

Search-Dialog

queryStatementstringOptional

bei mode == STATEMENT, das vql-query

forWorkflowbooleanRequired

für Workflows vorgesehen

Default: false

Responses

200

OK

application/json

put

/cmn/computed-queries/{group-key}/{id}/presets/{presetId}

HTTPcURLJavaScriptPython

PUT /api/cmn/computed-queries/{group-key}/{id}/presets/{presetId} HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 1913

{
  "version": "text",
  "info": {},
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {},
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {},
        "id": "text",
        "userRef": {
          "id": "text"
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {},
        "id": "text",
        "groupRef": {
          "id": "text"
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {},
    "id": "text",
    "pinned": false
  }
}

200

OK

{
  "version": "text",
  "info": {
    "createdAt": "2026-02-10T18:29:09.146Z",
    "createdFrom": "text",
    "updatedAt": "2026-02-10T18:29:09.146Z",
    "updatedFrom": "text"
  },
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "definition": {
        "_type": "text",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      },
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "definition": [
    {
      "_type": "text",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "userRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "groupRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "pinned": false
  }
}

delete

Path parameters

group-keystringRequired

idstringRequired

presetIdinteger · int64Required

Filter-Id

Responses

200

OK

application/json

delete

/cmn/computed-queries/{group-key}/{id}/presets/{presetId}

HTTPcURLJavaScriptPython

DELETE /api/cmn/computed-queries/{group-key}/{id}/presets/{presetId} HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "context": "text",
  "messageValue": "text"
}

post

Path parameters

group-keystringRequired

idstringRequired

Body

application/json

CUnit-Vorlage zum erzeugen des Imports

modestring · enumOptional

Was kann mit diesem Preset abgebildet werden QUERY oder STATEMENT

Default: QUERYPossible values:

queryStatementstringOptional

bei mode == STATEMENT, das vql-query

presetIdstringOptional

ID eines Presets

Responses

200

successful operation

application/json

422

query was not valid to process

application/json

post

/cmn/computed-queries/{group-key}/{id}

HTTPcURLJavaScriptPython

POST /api/cmn/computed-queries/{group-key}/{id} HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 2752

{
  "mode": "QUERY",
  "queryStatement": "text",
  "presetId": "text",
  "adhocPreset": {
    "version": "text",
    "info": {},
    "id": "text",
    "mode": "QUERY",
    "templateId": "text",
    "templateGroupKey": "text",
    "label": "text",
    "uiPayload": {},
    "variables": [
      {
        "path": "text",
        "mandatory": true,
        "variableName": "text",
        "visible": true,
        "alignX": 1,
        "alignY": 1,
        "alignWidth": 1,
        "searchDialog": {},
        "allowDialogMultipleChoice": false
      }
    ],
    "queryStatement": "text",
    "queryPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": [
            "[Circular Reference]"
          ],
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "results": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "sortAndOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ],
    "pageable": {
      "limit": 1
    },
    "option": {
      "distinctResult": true
    },
    "transformations": [
      {
        "crossTable": {
          "rowSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "columnSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "results": [
            {
              "result": {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              },
              "cellView": "AS_IS",
              "sumColumn": false,
              "rowMode": "DATA",
              "aggregateFunction": "text"
            }
          ]
        }
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "permissionAggregation": {
      "version": "text",
      "info": {},
      "id": "text",
      "userPermissions": [
        {
          "version": "text",
          "info": {},
          "id": "text",
          "userRef": {
            "id": "text"
          },
          "operation": "READ_ONLY"
        }
      ],
      "groupPermissions": [
        {
          "version": "text",
          "info": {},
          "id": "text",
          "groupRef": {
            "id": "text"
          },
          "operation": "READ_ONLY"
        }
      ],
      "operationForAllUsers": "READ_ONLY"
    },
    "forWorkflow": false,
    "userOptions": {
      "version": "text",
      "info": {},
      "id": "text",
      "pinned": false
    }
  },
  "overrideResults": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "additionalPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          "[Circular Reference]"
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "pageable": {
    "start": 1,
    "limit": 1,
    "sortOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ]
  },
  "variableSubstitutionList": {
    "variableSubstitutions": [
      {
        "variable": {
          "path": "text",
          "mandatory": true,
          "variableName": "text",
          "visible": true,
          "alignX": 1,
          "alignY": 1,
          "alignWidth": 1,
          "searchDialog": {},
          "allowDialogMultipleChoice": false
        },
        "values": [
          "text"
        ]
      }
    ]
  }
}

{
  "definition": [
    {
      "_type": "text",
      "definition": "[Circular Reference]",
      "value": "[Circular Reference]"
    }
  ],
  "data": {}
}

post

Path parameters

group-keystringRequired

idstringRequired

Body

application/json

exportFormatstring · enumOptional

Exportformate

Possible values:

exportFilenamestringOptional

Dateiname (ohne Endung) bei einem Dateiexport

outputTypestringOptional

Ausgabe-Typ

groupIdentifierstringOptional

outputGroup Identifier (optional)

publishedbooleanOptional

ist veröffentlicht?

Default: false

Responses

200

Request is processed and returned as Stream

*/*

202

Request is accepted and processing in progress

application/json

post

/cmn/computed-queries/{group-key}/{id}/print

HTTPcURLJavaScriptPython

POST /api/cmn/computed-queries/{group-key}/{id}/print HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 2910

{
  "exportFormat": "PDF",
  "exportFilename": "text",
  "outputType": "text",
  "groupIdentifier": "text",
  "published": false,
  "presetRequest": {
    "mode": "QUERY",
    "queryStatement": "text",
    "presetId": "text",
    "adhocPreset": {
      "version": "text",
      "info": {},
      "id": "text",
      "mode": "QUERY",
      "templateId": "text",
      "templateGroupKey": "text",
      "label": "text",
      "uiPayload": {},
      "variables": [
        {
          "path": "text",
          "mandatory": true,
          "variableName": "text",
          "visible": true,
          "alignX": 1,
          "alignY": 1,
          "alignWidth": 1,
          "searchDialog": {},
          "allowDialogMultipleChoice": false
        }
      ],
      "queryStatement": "text",
      "queryPredicate": {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      },
      "results": [
        {
          "property": "text",
          "displayName": "text",
          "functions": [
            "text"
          ],
          "visible": true
        }
      ],
      "sortAndOrders": [
        {
          "property": "text",
          "functions": [
            "text"
          ],
          "direction": "ASC"
        }
      ],
      "pageable": {
        "limit": 1
      },
      "option": {
        "distinctResult": true
      },
      "transformations": [
        {
          "crossTable": {
            "rowSpecs": [
              {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              }
            ],
            "columnSpecs": [
              {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              }
            ],
            "results": [
              {
                "result": {
                  "property": "text",
                  "displayName": "text",
                  "functions": [
                    "text"
                  ],
                  "visible": true
                },
                "cellView": "AS_IS",
                "sumColumn": false,
                "rowMode": "DATA",
                "aggregateFunction": "text"
              }
            ]
          }
        }
      ],
      "arithmeticQueryTerms": [
        {
          "termName": "text",
          "terms": [
            {
              "fragment": {
                "operations": [
                  "PLUS"
                ]
              },
              "attribute": "text",
              "fixedValue": 1
            }
          ],
          "operations": [
            "PLUS"
          ]
        }
      ],
      "permissionAggregation": {
        "version": "text",
        "info": {},
        "id": "text",
        "userPermissions": [
          {
            "version": "text",
            "info": {},
            "id": "text",
            "userRef": {
              "id": "text"
            },
            "operation": "READ_ONLY"
          }
        ],
        "groupPermissions": [
          {
            "version": "text",
            "info": {},
            "id": "text",
            "groupRef": {
              "id": "text"
            },
            "operation": "READ_ONLY"
          }
        ],
        "operationForAllUsers": "READ_ONLY"
      },
      "forWorkflow": false,
      "userOptions": {
        "version": "text",
        "info": {},
        "id": "text",
        "pinned": false
      }
    },
    "overrideResults": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "additionalPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": "[Circular Reference]",
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "pageable": {
      "start": 1,
      "limit": 1,
      "sortOrders": [
        {
          "property": "text",
          "functions": [
            "text"
          ],
          "direction": "ASC"
        }
      ]
    },
    "variableSubstitutionList": {
      "variableSubstitutions": [
        {
          "variable": {
            "path": "text",
            "definition": "[Circular Reference]",
            "mandatory": true,
            "variableName": "text",
            "visible": true,
            "alignX": 1,
            "alignY": 1,
            "alignWidth": 1,
            "searchDialog": {},
            "allowDialogMultipleChoice": false
          },
          "values": [
            "text"
          ]
        }
      ]
    }
  }
}

get

Path parameters

group-keystringRequired

idstringRequired

Query parameters

forAdminbooleanOptional

forWorkflowbooleanOptional

Responses

200

OK

application/json

get

/cmn/computed-queries/{group-key}/{id}/presets

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/{group-key}/{id}/presets HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

[
  {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "mode": "QUERY",
    "templateId": "text",
    "templateGroupKey": "text",
    "label": "text",
    "uiPayload": {},
    "variables": [
      {
        "path": "text",
        "definition": {
          "attribute": "text",
          "path": "text",
          "displayName": "text",
          "displayNameOverride": false,
          "groupDisplayName": "text",
          "parentDisplayName": "text",
          "resultable": true,
          "filterable": true,
          "sortable": true,
          "visible": true,
          "functions": [
            "text"
          ],
          "sortDirection": "text",
          "constraint": {
            "minLength": 1,
            "maxLength": 1,
            "minValue": 1,
            "includeMinValue": true,
            "maxValue": 1,
            "includeMaxValue": true,
            "notNull": false,
            "notBlank": true
          },
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "modelType": "STATIC",
          "headers": [
            {
              "displayName": "text",
              "displayNameOverride": false,
              "dataType": {
                "identifier": "text",
                "jsType": "text",
                "objectRefIdentifier": "text",
                "filterOptions": {
                  "filterValues": [
                    "text"
                  ],
                  "filterDialog": {},
                  "multipleChoice": false
                },
                "functions": [
                  "text"
                ],
                "predicateOperations": [
                  "AND"
                ]
              },
              "dataTypeIdentifier": "text",
              "groupDisplayName": "text",
              "data": {}
            }
          ]
        },
        "mandatory": true,
        "variableName": "text",
        "visible": true,
        "alignX": 1,
        "alignY": 1,
        "alignWidth": 1,
        "searchDialog": {},
        "allowDialogMultipleChoice": false
      }
    ],
    "queryStatement": "text",
    "queryPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": [
            "[Circular Reference]"
          ],
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "results": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "sortAndOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ],
    "pageable": {
      "limit": 1
    },
    "option": {
      "distinctResult": true
    },
    "transformations": [
      {
        "crossTable": {
          "rowSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "columnSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "results": [
            {
              "result": {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              },
              "cellView": "AS_IS",
              "sumColumn": false,
              "rowMode": "DATA",
              "aggregateFunction": "text"
            }
          ]
        }
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "definition": [
      {
        "_type": "text",
        "definition": "[Circular Reference]",
        "value": "[Circular Reference]",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      }
    ],
    "permissionAggregation": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "userPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "userRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "groupPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "groupRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "operationForAllUsers": "READ_ONLY"
    },
    "forWorkflow": false,
    "userOptions": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "pinned": false
    }
  }
]

post

Path parameters

group-keystringRequired

idstringRequired

Body

application/json

labelstringRequired

label für diesen filter

modestring · enumRequired

QueryMode

Possible values:

uiPayloadobjectOptional

Search-Dialog

queryStatementstringOptional

Optional ein VQL Query (bei Mode:STATEMENT)

forWorkflowbooleanRequired

für Workflows vorgesehen

Default: false

Responses

200

OK

application/json

post

/cmn/computed-queries/{group-key}/{id}/presets

HTTPcURLJavaScriptPython

POST /api/cmn/computed-queries/{group-key}/{id}/presets HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 1758

{
  "label": "text",
  "mode": "QUERY",
  "permissionAggregation": {
    "version": "text",
    "info": {},
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {},
        "id": "text",
        "userRef": {
          "id": "text"
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {},
        "id": "text",
        "groupRef": {
          "id": "text"
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "queryStatement": "text",
  "forWorkflow": false
}

200

OK

{
  "version": "text",
  "info": {
    "createdAt": "2026-02-10T18:29:09.146Z",
    "createdFrom": "text",
    "updatedAt": "2026-02-10T18:29:09.146Z",
    "updatedFrom": "text"
  },
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "definition": {
        "_type": "text",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      },
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "definition": [
    {
      "_type": "text",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "userRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "groupRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "pinned": false
  }
}

post

Path parameters

group-keystringRequired

idstringRequired

Body

application/json

CUnit-Vorlage zum erzeugen des Imports

modestring · enumOptional

Was kann mit diesem Preset abgebildet werden QUERY oder STATEMENT

Default: QUERYPossible values:

queryStatementstringOptional

bei mode == STATEMENT, das vql-query

presetIdstringOptional

ID eines Presets

Responses

200

OK

application/json

post

/cmn/computed-queries/{group-key}/{id}/presets/adhoc

HTTPcURLJavaScriptPython

POST /api/cmn/computed-queries/{group-key}/{id}/presets/adhoc HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 2752

{
  "mode": "QUERY",
  "queryStatement": "text",
  "presetId": "text",
  "adhocPreset": {
    "version": "text",
    "info": {},
    "id": "text",
    "mode": "QUERY",
    "templateId": "text",
    "templateGroupKey": "text",
    "label": "text",
    "uiPayload": {},
    "variables": [
      {
        "path": "text",
        "mandatory": true,
        "variableName": "text",
        "visible": true,
        "alignX": 1,
        "alignY": 1,
        "alignWidth": 1,
        "searchDialog": {},
        "allowDialogMultipleChoice": false
      }
    ],
    "queryStatement": "text",
    "queryPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": [
            "[Circular Reference]"
          ],
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "results": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "sortAndOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ],
    "pageable": {
      "limit": 1
    },
    "option": {
      "distinctResult": true
    },
    "transformations": [
      {
        "crossTable": {
          "rowSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "columnSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "results": [
            {
              "result": {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              },
              "cellView": "AS_IS",
              "sumColumn": false,
              "rowMode": "DATA",
              "aggregateFunction": "text"
            }
          ]
        }
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "permissionAggregation": {
      "version": "text",
      "info": {},
      "id": "text",
      "userPermissions": [
        {
          "version": "text",
          "info": {},
          "id": "text",
          "userRef": {
            "id": "text"
          },
          "operation": "READ_ONLY"
        }
      ],
      "groupPermissions": [
        {
          "version": "text",
          "info": {},
          "id": "text",
          "groupRef": {
            "id": "text"
          },
          "operation": "READ_ONLY"
        }
      ],
      "operationForAllUsers": "READ_ONLY"
    },
    "forWorkflow": false,
    "userOptions": {
      "version": "text",
      "info": {},
      "id": "text",
      "pinned": false
    }
  },
  "overrideResults": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "additionalPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          "[Circular Reference]"
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "pageable": {
    "start": 1,
    "limit": 1,
    "sortOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ]
  },
  "variableSubstitutionList": {
    "variableSubstitutions": [
      {
        "variable": {
          "path": "text",
          "mandatory": true,
          "variableName": "text",
          "visible": true,
          "alignX": 1,
          "alignY": 1,
          "alignWidth": 1,
          "searchDialog": {},
          "allowDialogMultipleChoice": false
        },
        "values": [
          "text"
        ]
      }
    ]
  }
}

200

OK

{
  "version": "text",
  "info": {
    "createdAt": "2026-02-10T18:29:09.146Z",
    "createdFrom": "text",
    "updatedAt": "2026-02-10T18:29:09.146Z",
    "updatedFrom": "text"
  },
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "definition": {
        "_type": "text",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      },
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "definition": [
    {
      "_type": "text",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "userRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "groupRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "pinned": false
  }
}

post

Body

application/json

statementstringRequired

das statement

limitinteger · int32Optional

optionaler wert für limit (wird gerne zusätzlich von tools mitgegeben)

offsetinteger · int64Optional

optionaler wert für offset (wird gerne zusätzlich von tools mitgegeben)

Responses

200

OK

application/json

post

/cmn/computed-queries/execute

HTTPcURLJavaScriptPython

POST /api/cmn/computed-queries/execute HTTP/1.1
Host: localhost:53907
Content-Type: application/json
Accept: */*
Content-Length: 286

{
  "statement": "text",
  "limit": 1,
  "offset": 1,
  "variableSubstitutionList": {
    "variableSubstitutions": [
      {
        "variable": {
          "path": "text",
          "mandatory": true,
          "variableName": "text",
          "visible": true,
          "alignX": 1,
          "alignY": 1,
          "alignWidth": 1,
          "searchDialog": {},
          "allowDialogMultipleChoice": false
        },
        "values": [
          "text"
        ]
      }
    ]
  }
}

200

OK

{
  "definition": [
    {
      "_type": "text",
      "definition": "[Circular Reference]",
      "value": "[Circular Reference]"
    }
  ],
  "data": {}
}

get

Responses

200

OK

application/json

get

/cmn/computed-queries

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

[
  {
    "key": "text",
    "label": "text"
  }
]

get

Path parameters

group-keystringRequired

Responses

200

OK

application/json

get

/cmn/computed-queries/{group-key}

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/{group-key} HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

[
  {
    "templateIdentifier": "text",
    "label": "text",
    "group": {
      "key": "text",
      "label": "text"
    }
  }
]

get

Path parameters

group-keystringRequired

idstringRequired

presetIdinteger · int64Required

Filter-Id

Query parameters

forAdminbooleanOptional

forWorkflowbooleanOptional

Responses

200

OK

application/json

get

/cmn/computed-queries/{group-key}/{id}/presets/{presetId}/validate

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/{group-key}/{id}/presets/{presetId}/validate HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "checkedPreset": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "mode": "QUERY",
    "templateId": "text",
    "templateGroupKey": "text",
    "label": "text",
    "uiPayload": {},
    "variables": [
      {
        "path": "text",
        "definition": {
          "attribute": "text",
          "path": "text",
          "displayName": "text",
          "displayNameOverride": false,
          "groupDisplayName": "text",
          "parentDisplayName": "text",
          "resultable": true,
          "filterable": true,
          "sortable": true,
          "visible": true,
          "functions": [
            "text"
          ],
          "sortDirection": "text",
          "constraint": {
            "minLength": 1,
            "maxLength": 1,
            "minValue": 1,
            "includeMinValue": true,
            "maxValue": 1,
            "includeMaxValue": true,
            "notNull": false,
            "notBlank": true
          },
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "modelType": "STATIC",
          "headers": [
            {
              "displayName": "text",
              "displayNameOverride": false,
              "dataType": {
                "identifier": "text",
                "jsType": "text",
                "objectRefIdentifier": "text",
                "filterOptions": {
                  "filterValues": [
                    "text"
                  ],
                  "filterDialog": {},
                  "multipleChoice": false
                },
                "functions": [
                  "text"
                ],
                "predicateOperations": [
                  "AND"
                ]
              },
              "dataTypeIdentifier": "text",
              "groupDisplayName": "text",
              "data": {}
            }
          ]
        },
        "mandatory": true,
        "variableName": "text",
        "visible": true,
        "alignX": 1,
        "alignY": 1,
        "alignWidth": 1,
        "searchDialog": {},
        "allowDialogMultipleChoice": false
      }
    ],
    "queryStatement": "text",
    "queryPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": [
            "[Circular Reference]"
          ],
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "results": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "sortAndOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ],
    "pageable": {
      "limit": 1
    },
    "option": {
      "distinctResult": true
    },
    "transformations": [
      {
        "crossTable": {
          "rowSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "columnSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "results": [
            {
              "result": {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              },
              "cellView": "AS_IS",
              "sumColumn": false,
              "rowMode": "DATA",
              "aggregateFunction": "text"
            }
          ]
        }
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "definition": [
      {
        "_type": "text",
        "definition": "[Circular Reference]",
        "value": "[Circular Reference]",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      }
    ],
    "permissionAggregation": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "userPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "userRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "groupPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "groupRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "operationForAllUsers": "READ_ONLY"
    },
    "forWorkflow": false,
    "userOptions": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "pinned": false
    }
  },
  "validationErrors": [
    {
      "path": "text",
      "type": "RESULT"
    }
  ]
}

get

Path parameters

group-keystringRequired

idstringRequired

Query parameters

filterablebooleanOptional

resultablebooleanOptional

verbosebooleanOptional

visibilitystring · enumOptionalPossible values:

Responses

200

OK

application/json

get

/cmn/computed-queries/{group-key}/{id}/fields

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/{group-key}/{id}/fields HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "attributes": [
    {
      "_type": "text",
      "definition": "[Circular Reference]",
      "value": "[Circular Reference]",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ]
}

get

Responses

200

OK

application/json

get

/cmn/computed-queries/workflow-presets

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/workflow-presets HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

[
  {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "mode": "QUERY",
    "templateId": "text",
    "templateGroupKey": "text",
    "label": "text",
    "uiPayload": {},
    "variables": [
      {
        "path": "text",
        "definition": {
          "attribute": "text",
          "path": "text",
          "displayName": "text",
          "displayNameOverride": false,
          "groupDisplayName": "text",
          "parentDisplayName": "text",
          "resultable": true,
          "filterable": true,
          "sortable": true,
          "visible": true,
          "functions": [
            "text"
          ],
          "sortDirection": "text",
          "constraint": {
            "minLength": 1,
            "maxLength": 1,
            "minValue": 1,
            "includeMinValue": true,
            "maxValue": 1,
            "includeMaxValue": true,
            "notNull": false,
            "notBlank": true
          },
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "modelType": "STATIC",
          "headers": [
            {
              "displayName": "text",
              "displayNameOverride": false,
              "dataType": {
                "identifier": "text",
                "jsType": "text",
                "objectRefIdentifier": "text",
                "filterOptions": {
                  "filterValues": [
                    "text"
                  ],
                  "filterDialog": {},
                  "multipleChoice": false
                },
                "functions": [
                  "text"
                ],
                "predicateOperations": [
                  "AND"
                ]
              },
              "dataTypeIdentifier": "text",
              "groupDisplayName": "text",
              "data": {}
            }
          ]
        },
        "mandatory": true,
        "variableName": "text",
        "visible": true,
        "alignX": 1,
        "alignY": 1,
        "alignWidth": 1,
        "searchDialog": {},
        "allowDialogMultipleChoice": false
      }
    ],
    "queryStatement": "text",
    "queryPredicate": {
      "type": "JUNCTION",
      "operator": "AND",
      "children": [
        {
          "type": "JUNCTION",
          "operator": "AND",
          "children": [
            "[Circular Reference]"
          ],
          "property": "text",
          "values": [
            "text"
          ],
          "visible": true,
          "functions": [
            "text"
          ]
        }
      ],
      "property": "text",
      "values": [
        "text"
      ],
      "visible": true,
      "functions": [
        "text"
      ]
    },
    "results": [
      {
        "property": "text",
        "displayName": "text",
        "functions": [
          "text"
        ],
        "visible": true
      }
    ],
    "sortAndOrders": [
      {
        "property": "text",
        "functions": [
          "text"
        ],
        "direction": "ASC"
      }
    ],
    "pageable": {
      "limit": 1
    },
    "option": {
      "distinctResult": true
    },
    "transformations": [
      {
        "crossTable": {
          "rowSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "columnSpecs": [
            {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            }
          ],
          "results": [
            {
              "result": {
                "property": "text",
                "displayName": "text",
                "functions": [
                  "text"
                ],
                "visible": true
              },
              "cellView": "AS_IS",
              "sumColumn": false,
              "rowMode": "DATA",
              "aggregateFunction": "text"
            }
          ]
        }
      }
    ],
    "arithmeticQueryTerms": [
      {
        "termName": "text",
        "terms": [
          {
            "fragment": {
              "operations": [
                "PLUS"
              ]
            },
            "attribute": "text",
            "fixedValue": 1
          }
        ],
        "operations": [
          "PLUS"
        ]
      }
    ],
    "definition": [
      {
        "_type": "text",
        "definition": "[Circular Reference]",
        "value": "[Circular Reference]",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      }
    ],
    "permissionAggregation": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "userPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "userRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "groupPermissions": [
        {
          "version": "text",
          "info": {
            "createdAt": "2026-02-10T18:29:09.146Z",
            "createdFrom": "text",
            "updatedAt": "2026-02-10T18:29:09.146Z",
            "updatedFrom": "text"
          },
          "id": "text",
          "groupRef": {
            "id": "text",
            "label": "text",
            "description": "text",
            "active": true
          },
          "operation": "READ_ONLY"
        }
      ],
      "operationForAllUsers": "READ_ONLY"
    },
    "forWorkflow": false,
    "userOptions": {
      "version": "text",
      "info": {
        "createdAt": "2026-02-10T18:29:09.146Z",
        "createdFrom": "text",
        "updatedAt": "2026-02-10T18:29:09.146Z",
        "updatedFrom": "text"
      },
      "id": "text",
      "pinned": false
    }
  }
]

get

Path parameters

idstringRequired

Responses

200

OK

application/json

get

/cmn/computed-queries/workflow-presets/{id}

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/workflow-presets/{id} HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "version": "text",
  "info": {
    "createdAt": "2026-02-10T18:29:09.146Z",
    "createdFrom": "text",
    "updatedAt": "2026-02-10T18:29:09.146Z",
    "updatedFrom": "text"
  },
  "id": "text",
  "mode": "QUERY",
  "templateId": "text",
  "templateGroupKey": "text",
  "label": "text",
  "uiPayload": {},
  "variables": [
    {
      "path": "text",
      "definition": {
        "_type": "text",
        "attribute": "text",
        "path": "text",
        "displayName": "text",
        "displayNameOverride": false,
        "groupDisplayName": "text",
        "parentDisplayName": "text",
        "resultable": true,
        "filterable": true,
        "sortable": true,
        "visible": true,
        "functions": [
          "text"
        ],
        "sortDirection": "text",
        "constraint": {
          "minLength": 1,
          "maxLength": 1,
          "minValue": 1,
          "includeMinValue": true,
          "maxValue": 1,
          "includeMaxValue": true,
          "notNull": false,
          "notBlank": true
        },
        "dataType": {
          "identifier": "text",
          "jsType": "text",
          "objectRefIdentifier": "text",
          "filterOptions": {
            "filterValues": [
              "text"
            ],
            "filterDialog": {},
            "multipleChoice": false
          },
          "functions": [
            "text"
          ],
          "predicateOperations": [
            "AND"
          ]
        },
        "dataTypeIdentifier": "text",
        "modelType": "STATIC",
        "headers": [
          {
            "displayName": "text",
            "displayNameOverride": false,
            "dataType": {
              "identifier": "text",
              "jsType": "text",
              "objectRefIdentifier": "text",
              "filterOptions": {
                "filterValues": [
                  "text"
                ],
                "filterDialog": {},
                "multipleChoice": false
              },
              "functions": [
                "text"
              ],
              "predicateOperations": [
                "AND"
              ]
            },
            "dataTypeIdentifier": "text",
            "groupDisplayName": "text",
            "data": {}
          }
        ]
      },
      "mandatory": true,
      "variableName": "text",
      "visible": true,
      "alignX": 1,
      "alignY": 1,
      "alignWidth": 1,
      "searchDialog": {},
      "allowDialogMultipleChoice": false
    }
  ],
  "queryStatement": "text",
  "queryPredicate": {
    "type": "JUNCTION",
    "operator": "AND",
    "children": [
      {
        "type": "JUNCTION",
        "operator": "AND",
        "children": [
          {
            "type": "JUNCTION",
            "operator": "AND",
            "children": "[Circular Reference]",
            "property": "text",
            "values": [
              "text"
            ],
            "visible": true,
            "functions": [
              "text"
            ]
          }
        ],
        "property": "text",
        "values": [
          "text"
        ],
        "visible": true,
        "functions": [
          "text"
        ]
      }
    ],
    "property": "text",
    "values": [
      "text"
    ],
    "visible": true,
    "functions": [
      "text"
    ]
  },
  "results": [
    {
      "property": "text",
      "displayName": "text",
      "functions": [
        "text"
      ],
      "visible": true
    }
  ],
  "sortAndOrders": [
    {
      "property": "text",
      "functions": [
        "text"
      ],
      "direction": "ASC"
    }
  ],
  "pageable": {
    "limit": 1
  },
  "option": {
    "distinctResult": true
  },
  "transformations": [
    {
      "crossTable": {
        "rowSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "columnSpecs": [
          {
            "property": "text",
            "displayName": "text",
            "functions": [
              "text"
            ],
            "visible": true
          }
        ],
        "results": [
          {
            "result": {
              "property": "text",
              "displayName": "text",
              "functions": [
                "text"
              ],
              "visible": true
            },
            "cellView": "AS_IS",
            "sumColumn": false,
            "rowMode": "DATA",
            "aggregateFunction": "text"
          }
        ]
      }
    }
  ],
  "arithmeticQueryTerms": [
    {
      "termName": "text",
      "terms": [
        {
          "fragment": {
            "operations": [
              "PLUS"
            ]
          },
          "attribute": "text",
          "fixedValue": 1
        }
      ],
      "operations": [
        "PLUS"
      ]
    }
  ],
  "definition": [
    {
      "_type": "text",
      "attribute": "text",
      "path": "text",
      "displayName": "text",
      "displayNameOverride": false,
      "groupDisplayName": "text",
      "parentDisplayName": "text",
      "resultable": true,
      "filterable": true,
      "sortable": true,
      "visible": true,
      "functions": [
        "text"
      ],
      "sortDirection": "text",
      "constraint": {
        "minLength": 1,
        "maxLength": 1,
        "minValue": 1,
        "includeMinValue": true,
        "maxValue": 1,
        "includeMaxValue": true,
        "notNull": false,
        "notBlank": true
      },
      "dataType": {
        "identifier": "text",
        "jsType": "text",
        "objectRefIdentifier": "text",
        "filterOptions": {
          "filterValues": [
            "text"
          ],
          "filterDialog": {},
          "multipleChoice": false
        },
        "functions": [
          "text"
        ],
        "predicateOperations": [
          "AND"
        ]
      },
      "dataTypeIdentifier": "text",
      "modelType": "STATIC",
      "headers": [
        {
          "displayName": "text",
          "displayNameOverride": false,
          "dataType": {
            "identifier": "text",
            "jsType": "text",
            "objectRefIdentifier": "text",
            "filterOptions": {
              "filterValues": [
                "text"
              ],
              "filterDialog": {},
              "multipleChoice": false
            },
            "functions": [
              "text"
            ],
            "predicateOperations": [
              "AND"
            ]
          },
          "dataTypeIdentifier": "text",
          "groupDisplayName": "text",
          "data": {}
        }
      ]
    }
  ],
  "permissionAggregation": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "userPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "userRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "groupPermissions": [
      {
        "version": "text",
        "info": {
          "createdAt": "2026-02-10T18:29:09.146Z",
          "createdFrom": "text",
          "updatedAt": "2026-02-10T18:29:09.146Z",
          "updatedFrom": "text"
        },
        "id": "text",
        "groupRef": {
          "id": "text",
          "label": "text",
          "description": "text",
          "active": true
        },
        "operation": "READ_ONLY"
      }
    ],
    "operationForAllUsers": "READ_ONLY"
  },
  "forWorkflow": false,
  "userOptions": {
    "version": "text",
    "info": {
      "createdAt": "2026-02-10T18:29:09.146Z",
      "createdFrom": "text",
      "updatedAt": "2026-02-10T18:29:09.146Z",
      "updatedFrom": "text"
    },
    "id": "text",
    "pinned": false
  }
}

get

Responses

200

OK

application/json

get

/cmn/computed-queries/dialect-info

HTTPcURLJavaScriptPython

GET /api/cmn/computed-queries/dialect-info HTTP/1.1
Host: localhost:53907
Accept: */*

200

OK

{
  "functions": [
    {
      "identifier": "text",
      "aggregate": false,
      "messageCode": "text"
    }
  ],
  "dataTypes": [
    {
      "identifier": "text",
      "jsType": "text",
      "objectRefIdentifier": "text",
      "filterOptions": {
        "filterValues": [
          "text"
        ],
        "filterDialog": {},
        "multipleChoice": false
      },
      "functions": [
        "text"
      ],
      "predicateOperations": [
        "AND"
      ]
    }
  ]
}