Question
Code Error interface
My code appears to be correct, however i receive the following error message when i change to design view.
Error:
My code is the following:
a!localVariables(
local!DatosPedidos: a!queryRecordType(
recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!DatosPedidosLineasPedidos: a!queryRecordType(
recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido',
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!DatosPedidosRecepFiltro: a!queryRecordType(
recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
filters: a!queryFilter(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{eeea3ae1-9516-46e3-8caa-327a9154b43d}recepcionado',
operator: "=",
value: true
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!DatosPedidosFacturadoFiltro: a!queryRecordType(
recordType: 'recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas',
filters: a!queryFilter(
field: 'recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{d95fb6de-1b02-4867-8312-974781dde99a}estadoFact',
operator: "=",
value: "Facturación Aceptada"
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!DatosPedidosImpRecep: a!queryRecordType(
recordType: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones',
filters: a!queryFilter(
field: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{3ea89e40-8997-4318-8e85-7e49ebc0a7de}validada',
operator: "=",
value: true
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
local!DatosPedidosFacturados: a!queryRecordType(
recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
filters: a!queryFilter(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{85bbd90f-fc62-46a3-9bcf-3590b7745510}facturado',
operator: "=",
value: true
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data,
{
a!sectionLayout(
label: "KPIs",
labelIcon: "bar-chart",
labelSize: "LARGE",
labelColor: "#434343",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Pedidos Realizados:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
count(
local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
)
},
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
},
align: "LEFT"
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD",
showBorder: true,
showShadow: false,
decorativeBarColor: "#dd7e6b"
)
}
),
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Pedidos Recepcionados:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
count(
local!DatosPedidosRecepFiltro['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
)
},
color: "#000000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
}
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD"
)
}
),
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Pedidos Facturados:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
count(
local!DatosPedidosFacturados['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
)
},
color: "#000000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
}
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD"
)
}
)
}
)
}
),
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Importe Total en Pedidos:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
dollar(
sum(
local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{50cb6461-d663-4038-a178-da96ddc870d0}importeTotal']
)
)
},
color: "STANDARD",
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
}
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD"
)
}
),
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Importe Recepcionado:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
dollar(
sum(
local!DatosPedidosImpRecep['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{f7c1d09c-e69f-4478-9115-87202de7fefc}TotalRecepcionado']
)
)
},
color: "#000000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
}
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD"
)
}
),
a!columnLayout(
contents: {
a!cardLayout(
contents: {
a!richTextDisplayField(
labelPosition: "COLLAPSED",
value: {
a!richTextItem(
text: { "Importe Facturado:" },
color: "#980000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
),
char(10),
a!richTextItem(
text: {
dollar(
sum(
local!DatosPedidosFacturadoFiltro['recordType!{51d44df6-c727-4443-8114-aef8a7509b41}CPF Maestro Facturas.fields.{e832ec1e-f394-4193-896c-b1e74035964e}totalFact']
)
)
},
color: "#000000",
size: "MEDIUM_PLUS",
style: { "STRONG" }
)
}
)
},
height: "AUTO",
style: "#fce5cd",
marginBelow: "STANDARD"
)
}
)
}
),
a!gaugeField(
label: "% Pedidos Facturados",
percentage: (
count(
local!DatosPedidosFacturados['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
) / count(
local!DatosPedidos['recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido']
)
) * 100,
primarytext: a!gaugePercentage()
),
a!cardLayout(
contents: {
a!lineChartField(
data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
config: a!lineChartConfig(
primaryGrouping: a!grouping(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{4097e2aa-8ce4-4ed1-9224-2ece219ef208}fechaEmision',
alias: "fechaEmision_primaryGrouping",
interval: "AUTO"
),
measures: {
a!measure(
function: "COUNT",
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
alias: "idPedido_count_measure1"
)
},
dataLimit: 100
),
label: "Pedidos realizados por fecha ",
labelPosition: "ABOVE",
xAxisTitle: "Fecha Emisión",
yAxisTitle: "Número de pedidos realizados",
showLegend: false,
showDataLabels: false,
showTooltips: true,
connectNulls: false,
colorScheme: "SUNSET",
height: "MEDIUM",
xAxisStyle: "STANDARD",
yAxisStyle: "STANDARD",
refreshAfter: "RECORD_ACTION"
)
},
height: "AUTO",
style: "#f3f3f3",
marginBelow: "STANDARD"
),
a!cardLayout(
contents: {
a!sectionLayout(
label: "Estados",
labelColor: "#980000",
contents: {
a!columnsLayout(
columns: {
a!columnLayout(
contents: {
a!pieChartField(
data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
config: a!pieChartConfig(
primaryGrouping: a!grouping(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{bbcdbad7-589d-4a3a-bf5b-db8e83b2a6a7}EstadoRecepcionDefi',
alias: "EstadoRecepcionDefi_primaryGrouping"
),
measures: {
a!measure(
function: "COUNT",
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
alias: "idPedido_count_measure1"
)
},
dataLimit: 100
),
label: "Estado Recepciones",
labelPosition: "ABOVE",
showDataLabels: true,
colorScheme: "SUNSET",
style: "DONUT",
seriesLabelStyle: "ON_CHART",
height: "MEDIUM",
refreshAfter: "RECORD_ACTION"
)
}
),
a!columnLayout(
contents: {
a!pieChartField(
data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
config: a!pieChartConfig(
primaryGrouping: a!grouping(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{e5339b1a-541c-429f-86df-916153a199bc}estadoFactMultiple',
alias: "estadoFactMultiple_primaryGrouping"
),
measures: {
a!measure(
function: "COUNT",
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
alias: "idPedido_count_measure1"
)
},
dataLimit: 100
),
label: "Estado Facturación",
labelPosition: "ABOVE",
showDataLabels: true,
colorScheme: "SUNSET",
style: "DONUT",
seriesLabelStyle: "ON_CHART",
height: "MEDIUM",
refreshAfter: "RECORD_ACTION"
)
}
),
a!columnLayout(
contents: {
a!pieChartField(
data: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos',
config: a!pieChartConfig(
primaryGrouping: a!grouping(
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{e11e6206-fc23-4a4b-9819-4db5a5bab685}nomProveedor',
alias: "nomProveedor_primaryGrouping"
),
measures: {
a!measure(
function: "COUNT",
field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{7309402c-2312-4a4e-bdaa-5654789bffb2}idPedido',
alias: "idPedido_count_measure1"
)
},
dataLimit: 100
),
label: "Pedidos por Proveedor",
labelPosition: "ABOVE",
showDataLabels: true,
showTooltips: false,
showAsPercentage: true,
colorScheme: "SUNSET",
style: "DONUT",
seriesLabelStyle: "ON_CHART",
height: "MEDIUM",
refreshAfter: "RECORD_ACTION"
)
}
)
}
)
}
)
},
height: "AUTO",
style: "#f3f3f3",
marginBelow: "STANDARD"
),
a!cardLayout(
contents: {
a!barChartField(
data: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido',
config: a!barChartConfig(
primaryGrouping: a!grouping(
field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{69e9a834-b2fb-4f35-a36d-3c526c97f4ac}Material',
alias: "Material_primaryGrouping"
),
measures: {
a!measure(
function: "SUM",
field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{e78c5b35-026f-4713-8404-05077c6c9152}Cantidad',
alias: "Cantidad_sum_measure1"
),
a!measure(
function: "SUM",
field: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido.fields.{bd0fe4ca-322c-422e-89e5-97e5194817a1}CantRecepAcum',
alias: "CantRecepAcum_sum_measure2"
)
},
dataLimit: 100
),
label: "Cantidades por Material",
labelPosition: "ABOVE",
xAxisTitle: "Material",
yAxisTitle: "Cantidad Total",
stacking: "NONE",
showLegend: true,
showTooltips: true,
colorScheme: "SUNSET",
height: "MEDIUM",
xAxisStyle: "STANDARD",
yAxisStyle: "STANDARD",
refreshAfter: "RECORD_ACTION"
)
},
height: "AUTO",
style: "#f3f3f3",
marginBelow: "STANDARD"
)
}
)I have been trying to find the error but I couldn't solve the problem. Any help would be useful.
Thanks!