TableInfo
{
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
},
"property2": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
}
},
"defaultTextField": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"idField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
},
"idField": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"statusField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
},
"statusField": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"idField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"idField": {},
"searchFields": [
{
"expression": "string",
"column": {},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
},
"searchFields": [
{
"expression": "string",
"column": {
"root": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [],
"qualifiedTableName": null
},
"tableName": "string",
"columnName": "string",
"sqlType": 0,
"clrType": null,
"position": 0,
"reference": {
"itemTypes": [
0
],
"name": "string",
"table": "string",
"schema": "string",
"isRoot": true,
"columns": {
"property1": {},
"property2": {}
},
"defaultTextField": {},
"idField": {},
"statusField": {},
"searchFields": [],
"qualifiedTableName": null
},
"enum": null,
"isClient": null,
"alias": "string",
"hidden": null,
"format": "string",
"prompt": "string",
"description": "string",
"outputFormat": "string",
"required": null,
"readOnly": null,
"createMode": null,
"maxLength": null,
"min": "string",
"max": "string",
"step": "string",
"listValues": [
"string"
],
"isIDField": true,
"label": null,
"isDate": true
},
"alias": "string",
"aggregate": null,
"typeFilter": null,
"assignedFilter": null,
"statusFilters": [
0
],
"formatOptions": 0,
"calculation": {
"values": [],
"operators": [
0
]
},
"isAggregate": true,
"isCalculation": true,
"resultColumn": null,
"hasOpenStatusFilter": true,
"hasClosedStatusFilter": true,
"displayName": null,
"icon": null,
"isFileType": true,
"isFileNameLink": true,
"isSearchLink": true,
"isDocumentCount": true,
"isUserCount": true,
"isEngagementCount": true,
"isCommentCount": true,
"isPercentage": true
}
],
"qualifiedTableName": null
}