| All Verbs | /Utilidades/Consultas/Cubos/DefinicionGrupo |
|---|
import datetime
import decimal
from marshmallow.fields import *
from servicestack import *
from typing import *
from dataclasses import dataclass, field
from dataclasses_json import dataclass_json, LetterCase, Undefined, config
from enum import Enum, IntEnum
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class PivotGridGrupo:
codigo: Decimal = decimal.Decimal(0)
nombre: Optional[str] = None
observaciones: Optional[str] = None
usuario: Optional[str] = None
fecha_creacion: datetime.datetime = datetime.datetime(1, 1, 1)
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Tabla:
codigo: Decimal = decimal.Decimal(0)
propietario: Optional[str] = None
tipo: Optional[str] = None
nombre: Optional[str] = None
alias: Optional[str] = None
descripcion: Optional[str] = None
para_reportes: Optional[str] = None
crear_al_iniciar: Optional[str] = None
campo_empresa: int = 0
campo_unico: int = 0
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Columna:
codigo_tabla: Decimal = decimal.Decimal(0)
codigo: Decimal = decimal.Decimal(0)
nombre: Optional[str] = None
alias: Optional[str] = None
descripcion: Optional[str] = None
tipo_dato: Optional[str] = None
obligatorio_formas: Optional[str] = None
hint: Optional[str] = None
mayuscula: Optional[str] = None
tamano: int = 0
escala: int = 0
tipo: Optional[str] = None
vlr_defecto: Optional[str] = None
permite_editar: Optional[str] = None
orden: int = 0
dinamico: Optional[str] = None
clase_control: Optional[str] = None
join_lookup: Decimal = decimal.Decimal(0)
es_i_d: Optional[str] = None
mascara: Optional[str] = None
mostrar_en_lista: Optional[str] = None
info_adicional: Optional[str] = None
where_defecto: Optional[str] = None
tiene_resumen: Optional[str] = None
formato_resumen: Optional[str] = None
tipo_resumen: Optional[str] = None
posicion_resumen: Optional[str] = None
resumen_en_grupo: Optional[str] = None
resumen_en_total: Optional[str] = None
indice_grupo: int = 0
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Frame:
codigo: Decimal = decimal.Decimal(0)
sql: Optional[str] = None
campos1: Optional[List[str]] = None
campos2: Optional[List[str]] = None
tabla_frame: Optional[DefinicionTabla] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DetalleIndices:
codigo_tabla: Decimal = decimal.Decimal(0)
nombre_indice: Optional[str] = None
codigo_columna: Decimal = decimal.Decimal(0)
tipo_calculo: Optional[str] = None
secuencia: Optional[str] = None
nombre_columna: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ColCountByScreen:
lg: int = 0
md: int = 0
sm: int = 0
xs: int = 0
class ItemTypeForm(str, Enum):
SIMPLE = 'simple'
GROUP = 'group'
TABBED = 'tabbed'
EMPTY = 'empty'
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EmptyItemForm:
item_type: Optional[ItemTypeForm] = None
visible_index: int = 0
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class dxForm:
col_count_by_screen: Optional[ColCountByScreen] = None
label_location: Optional[str] = None
read_only: bool = False
items: Optional[List[EmptyItemForm]] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ValidationRule:
type: Optional[str] = None
message: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class LookupGrid:
allow_clearing: bool = False
display_expr: Optional[str] = None
value_expr: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ColumnGrid:
caption: Optional[str] = None
data_field: Optional[str] = None
data_type: Optional[str] = None
visible_index: int = 0
validation_rules: Optional[List[ValidationRule]] = None
lookup: Optional[LookupGrid] = None
allow_editing: bool = False
encode_html: bool = False
editor_options: Optional[Dict[str, Object]] = None
group_index: Optional[int] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EditingGrid:
allow_adding: bool = False
allow_deleting: bool = False
allow_updating: bool = False
mode: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryGroupItems:
column: Optional[str] = None
display_format: Optional[str] = None
show_in_group_footer: bool = False
summary_type: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryTotalItems:
column: Optional[str] = None
display_format: Optional[str] = None
summary_type: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummary:
group_items: Optional[List[gridSummaryGroupItems]] = None
total_items: Optional[List[gridSummaryTotalItems]] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class dxDataGrid:
columns: Optional[List[ColumnGrid]] = None
show_column_lines: bool = False
show_row_lines: bool = False
row_alternation_enabled: bool = False
show_borders: bool = False
editing: Optional[EditingGrid] = None
summary: Optional[gridSummary] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DefinicionTabla:
tabla: Optional[Tabla] = None
columnas: Optional[List[Columna]] = None
lookups: Optional[List[DetalleJoinTabla]] = None
frames: Optional[List[Frame]] = None
detalle_llave: Optional[List[DetalleIndices]] = None
form: Optional[dxForm] = None
data_grid: Optional[dxDataGrid] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class Vista:
codigo: Decimal = decimal.Decimal(0)
codigo_blob: Decimal = decimal.Decimal(0)
nombre: Optional[str] = None
descripcion: Optional[str] = None
sql: Optional[str] = None
codigo_tabla: Decimal = decimal.Decimal(0)
guardar_binario: Optional[str] = None
tipo_consulta: Optional[str] = None
exportacion_default: Optional[str] = None
tipo_exportacion: Optional[str] = None
parametros_exportacion: int = 0
codigo_ayuda: Optional[str] = None
ejecutar_en_adm: Optional[str] = None
info_adicional: Optional[str] = None
ejec_multiempresa: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DetalleJoinTabla:
codigo: Decimal = decimal.Decimal(0)
campo_a_mostrar: Optional[str] = None
campos1: Optional[List[str]] = None
campos2: Optional[List[str]] = None
operadores: Optional[List[str]] = None
datos: Optional[List[Dict[str, Object]]] = None
codigo_tabla1: Decimal = decimal.Decimal(0)
sql: Optional[str] = None
tabla_detalle: Optional[DefinicionTabla] = None
vista: Optional[Vista] = None
version: Optional[str] = None
ordenar: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class PivotGridConf:
codigo: Decimal = decimal.Decimal(0)
nombre: Optional[str] = None
crear_chart: Optional[str] = None
configuration: Optional[str] = None
chart: Optional[str] = None
observaciones: Optional[str] = None
id_vista: Decimal = decimal.Decimal(0)
usuario: Optional[str] = None
fecha_creacion: datetime.datetime = datetime.datetime(1, 1, 1)
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DefinicionCuboRS:
tabla: Optional[Tabla] = None
descripcion: Optional[str] = None
filtros: Optional[List[Columna]] = None
filas: Optional[List[Columna]] = None
columnas: Optional[List[Columna]] = None
calculos: Optional[List[Columna]] = None
parametros: Optional[List[Columna]] = None
lookups: Optional[List[DetalleJoinTabla]] = None
dx_pivot_grid: Optional[Dict[str, Object]] = None
dx_chart: Optional[Dict[str, Object]] = None
forma_parametros: Optional[dxForm] = None
pivot_grid_conf: Optional[PivotGridConf] = None
error: Optional[str] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DefinicionGrupoCuboRS:
grupo_pivot_grid: Optional[PivotGridGrupo] = None
items: Optional[List[DefinicionCuboRS]] = None
class Lenguajes(str, Enum):
ES = 'ES'
PT = 'PT'
EN = 'EN'
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DefinicionGrupoCuboRQ:
id_grupo: int = 0
lenguaje: Optional[Lenguajes] = None
Python DefinicionGrupoCuboRQ DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .jsv suffix or ?format=jsv
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /Utilidades/Consultas/Cubos/DefinicionGrupo HTTP/1.1
Host: soluser-recaudo.sgsas.co
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length
{
IDGrupo: 0,
Lenguaje: ES
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length
{
GrupoPivotGrid:
{
Codigo: 0,
Nombre: String,
Observaciones: String,
Usuario: String
},
Items:
[
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Descripcion: String,
Filtros:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Filas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Calculos:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Parametros:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
TablaDetalle:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
TablaDetalle:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
TablaDetalle:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
]
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
},
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
],
TablaFrame:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
]
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
}
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
},
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
],
TablaFrame:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
TablaDetalle:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
]
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
},
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
],
TablaFrame:
{
Tabla:
{
Codigo: 0,
Propietario: String,
Tipo: String,
Nombre: String,
Alias: String,
Descripcion: String,
ParaReportes: String,
CrearAlIniciar: String,
CampoEmpresa: 0,
CampoUnico: 0
},
Columnas:
[
{
CodigoTabla: 0,
Codigo: 0,
Nombre: String,
Alias: String,
Descripcion: String,
TipoDato: String,
ObligatorioFormas: String,
Hint: String,
Mayuscula: String,
Tamano: 0,
Escala: 0,
Tipo: String,
VlrDefecto: String,
PermiteEditar: String,
Orden: 0,
Dinamico: String,
ClaseControl: String,
JoinLookup: 0,
EsID: String,
Mascara: String,
MostrarEnLista: String,
InfoAdicional: String,
WHEREDefecto: String,
TieneResumen: String,
FormatoResumen: String,
TipoResumen: String,
PosicionResumen: String,
ResumenEnGrupo: String,
ResumenEnTotal: String,
IndiceGrupo: 0
}
],
Lookups:
[
{
Codigo: 0,
CampoAMostrar: String,
Campos1:
[
String
],
Campos2:
[
String
],
Operadores:
[
String
],
Datos:
[
{
String: {}
}
],
CodigoTabla1: 0,
SQL: String,
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
Frames:
[
{
Codigo: 0,
SQL: String,
Campos1:
[
String
],
Campos2:
[
String
]
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
}
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
}
}
],
DetalleLlave:
[
{
CodigoTabla: 0,
NombreIndice: String,
CodigoColumna: 0,
TipoCalculo: String,
Secuencia: String,
NombreColumna: String
}
],
Form:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
DataGrid:
{
"columns":
[
{
"caption": "String",
"dataField": "String",
"dataType": "String",
"visibleIndex": 0,
"validationRules":
[
{
"type": "String",
"message": "String"
}
],
"lookup":
{
"allowClearing": false,
"displayExpr": "String",
"valueExpr": "String"
},
"allowEditing": false,
"encodeHtml": false,
"editorOptions":
{
"String": {}
},
"groupIndex": 0
}
],
"showColumnLines": false,
"showRowLines": false,
"rowAlternationEnabled": false,
"showBorders": false,
"editing":
{
"allowAdding": false,
"allowDeleting": false,
"allowUpdating": false,
"mode": "String"
},
"summary":
{
"groupItems":
[
{
"column": "String",
"displayFormat": "String",
"showInGroupFooter": false,
"summaryType": "String"
}
],
"totalItems":
[
{
"column": "String",
"displayFormat": "String",
"summaryType": "String"
}
]
}
}
},
Vista:
{
Codigo: 0,
CodigoBlob: 0,
Nombre: String,
Descripcion: String,
SQL: String,
CodigoTabla: 0,
GuardarBinario: String,
TipoConsulta: String,
ExportacionDefault: String,
TipoExportacion: String,
ParametrosExportacion: 0,
CodigoAyuda: String,
EjecutarEnAdm: String,
InfoAdicional: String,
EjecMultiempresa: String
},
Version: String,
Ordenar: String
}
],
dxPivotGrid:
{
String: {}
},
dxChart:
{
String: {}
},
FormaParametros:
{
colCountByScreen:
{
lg: 0,
md: 0,
sm: 0,
xs: 0
},
labelLocation: String,
readOnly: False,
items:
[
{
itemType: simple,
visibleIndex: 0
}
]
},
PivotGridConf:
{
Codigo: 0,
Nombre: String,
CrearChart: String,
Configuration: String,
Chart: String,
Observaciones: String,
IDVista: 0,
Usuario: String
},
Error: String
}
]
}