{
"layout": {
"title": "Four Columns Template",
"rows": [
{
"id": "2c0edd5e-095e-5f70-25e9-16e704cf0c49",
"type": "LayoutResourceCode",
"typeDesc": "Resource",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"value": "style",
"type": "Id"
},
{
"name": "resourceType",
"value": "Css",
"type": "Label"
},
{
"name": "resourceCode",
"value": "select {\n width: 600px;\n } ",
"type": "Resource"
}
]
},
{
"id": "e12f9bf3-27f1-beb1-0a68-a5b0facd091b",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Header"
},
{
"name": "height",
"type": "Integer",
"value": "60"
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "5dc54aa4-6a22-269a-d641-ac5fd3a61298",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "e12f9bf3-27f1-beb1-0a68-a5b0facd091b",
"properties": [
{
"name": "name",
"type": "Id",
"value": ""
},
{
"name": "columnSpan",
"type": "Integer",
"value": "24"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": ""
},
{
"name": "columnAppend",
"type": "Integer",
"value": ""
},
{
"name": "columnPrependTop",
"type": "Boolean",
"value": false
},
{
"name": "columnAppendBottom",
"type": "Boolean",
"value": false
},
{
"name": "columnBorder",
"type": "Boolean",
"value": false
},
{
"name": "columnBigBorder",
"type": "Boolean",
"value": false
},
{
"name": "height",
"type": "Integer",
"value": "60"
},
{
"name": "backgroundColor",
"type": "Color",
"value": "#118cd4"
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": "cdfdd-round"
},
{
"name": "textAlign",
"type": "TextAlign",
"value": "center"
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "b8a80da0-d522-3e26-d4e9-9c9d56792cae",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "5dc54aa4-6a22-269a-d641-ac5fd3a61298",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "b84d91dd-1f72-dabb-e2f0-577ac4fb7afd",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "5dc54aa4-6a22-269a-d641-ac5fd3a61298",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "900410f5-d58c-7407-c5ad-300f070eb3bb",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "b84d91dd-1f72-dabb-e2f0-577ac4fb7afd",
"properties": [
{
"name": "name",
"value": "Title",
"type": "Id"
},
{
"name": "html",
"value": "Cantidad de Empresas por Código arancelario
",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "2344fcc5-24b9-f0d1-6e96-2ac5fca8465b",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "UnIqEiD",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "9b5e4665-60dd-d123-d49a-7cb9072a0540",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Body"
},
{
"name": "height",
"type": "Integer",
"value": ""
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "9b5e4665-60dd-d123-d49a-7cb9072a0540",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Body_Content"
},
{
"name": "columnSpan",
"type": "Integer",
"value": "24"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": ""
},
{
"name": "columnAppend",
"type": "Integer",
"value": ""
},
{
"name": "columnPrependTop",
"type": "Boolean",
"value": "false"
},
{
"name": "columnAppendBottom",
"type": "Boolean",
"value": false
},
{
"name": "columnBorder",
"type": "Boolean",
"value": false
},
{
"name": "columnBigBorder",
"type": "Boolean",
"value": false
},
{
"name": "height",
"type": "Integer",
"value": ""
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "217d8bd3-9e3a-fe84-30c4-dc0867b68dc8",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "name",
"value": "RowCombo",
"type": "Id"
},
{
"name": "height",
"value": "10",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "heading",
"type": "String"
}
]
},
{
"id": "7f2eb677-38cd-cf45-1402-749103d53c24",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "217d8bd3-9e3a-fe84-30c4-dc0867b68dc8",
"properties": [
{
"name": "name",
"value": "Seleccione",
"type": "Id"
},
{
"name": "html",
"value": "Seleccione Código Arancelario ",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "818374af-6de4-1f56-bab7-8c29f910dced",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "217d8bd3-9e3a-fe84-30c4-dc0867b68dc8",
"properties": [
{
"name": "name",
"value": "acArancelario",
"type": "Id"
},
{
"name": "columnSpan",
"value": "24",
"type": "Integer"
},
{
"name": "columnPrepend",
"value": "",
"type": "Integer"
},
{
"name": "columnAppend",
"value": "",
"type": "Integer"
},
{
"name": "columnPrependTop",
"value": "false",
"type": "Boolean"
},
{
"name": "columnAppendBottom",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBigBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "cdfdd-round",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "5c814371-1e01-b82f-25a7-bcf74bdfa535",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "name",
"value": "RowCombo2",
"type": "Id"
},
{
"name": "height",
"value": "10",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "59ceb0cf-2a55-e05b-eab0-9aa46a821ed9",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "5c814371-1e01-b82f-25a7-bcf74bdfa535",
"properties": [
{
"name": "name",
"value": "Seleccione2",
"type": "Id"
},
{
"name": "html",
"value": "",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "cf4fd221-7b05-6bbb-f08f-9e7652418f11",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "5c814371-1e01-b82f-25a7-bcf74bdfa535",
"properties": [
{
"name": "name",
"value": "acArancelario2",
"type": "Id"
},
{
"name": "columnSpan",
"value": "24",
"type": "Integer"
},
{
"name": "columnPrepend",
"value": "",
"type": "Integer"
},
{
"name": "columnAppend",
"value": "",
"type": "Integer"
},
{
"name": "columnPrependTop",
"value": "false",
"type": "Boolean"
},
{
"name": "columnAppendBottom",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBigBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "cdfdd-round",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "1b5b2440-ad57-d50a-f6aa-d96f9b209626",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Row_1"
},
{
"name": "height",
"type": "Integer",
"value": "220"
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": ""
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "1b5b2440-ad57-d50a-f6aa-d96f9b209626",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Panel_1"
},
{
"name": "columnSpan",
"type": "Integer",
"value": "22"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": "1"
},
{
"name": "columnAppend",
"type": "Integer",
"value": "1"
},
{
"name": "columnPrependTop",
"type": "Boolean",
"value": false
},
{
"name": "columnAppendBottom",
"type": "Boolean",
"value": false
},
{
"name": "columnBorder",
"type": "Boolean",
"value": false
},
{
"name": "columnBigBorder",
"type": "Boolean",
"value": false
},
{
"name": "height",
"type": "Integer",
"value": ""
},
{
"name": "backgroundColor",
"type": "Color",
"value": "#e0e0e0"
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": "cdfdd-round"
},
{
"name": "textAlign",
"type": "TextAlign",
"value": "center"
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "e54e4512-e260-a7cc-1149-59da8220d908",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "cecef275-ad7b-fb9c-5809-51d0e7c3adf0",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "2a8fee77-075a-a85e-3bfd-1afee6d589db",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "cecef275-ad7b-fb9c-5809-51d0e7c3adf0",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Cantidad de Empresas por Código Arancelario
",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "fc781dae-a3a5-8881-f7fa-11319b6dcdf6",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"properties": [
{
"name": "name",
"value": "BotonT",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "076d8798-348a-3694-a509-72f0e7469570",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "3ba3b2bb-4a2c-1cd1-f6e0-bd63f0ad59f9",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "233d1ac7-a9d8-3191-d8cf-7cb8864ef548",
"properties": [
{
"name": "name",
"value": "Plantas",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "0c44c2f0-ec10-22e0-98b2-b156ce2e1d58",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "891265c6-0704-f2be-82e4-9e41ddd5339d",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "height",
"value": "220",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "891265c6-0704-f2be-82e4-9e41ddd5339d",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "columnSpan",
"value": "22",
"type": "Integer"
},
{
"name": "columnPrepend",
"value": "1",
"type": "Integer"
},
{
"name": "columnAppend",
"value": "1",
"type": "Integer"
},
{
"name": "columnPrependTop",
"value": "false",
"type": "Boolean"
},
{
"name": "columnAppendBottom",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "columnBigBorder",
"value": "false",
"type": "Boolean"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "#e0e0e0",
"type": "Color"
},
{
"name": "roundCorners",
"value": "cdfdd-round",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "6c34005e-65a3-0ccb-65f2-706b1022d419",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "height",
"value": "5",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "64ce17c7-43d5-b105-2c81-34a6fda368ea",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "name",
"value": "BotonG",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "44346fc8-bdd2-3afc-ae1f-c9fb664b5235",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "height",
"value": "5",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "449ae86d-9f70-2e95-4fc5-cd52bca338a6",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "2bdbc406-2aa7-9f19-10eb-9eb721b0e9ce",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "449ae86d-9f70-2e95-4fc5-cd52bca338a6",
"properties": [
{
"name": "name",
"value": "",
"type": "Id"
},
{
"name": "html",
"value": "Seleccionar Año:
",
"type": "Html"
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "dbea44a9-d4b2-2b12-5596-d3da84b5011e",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "name",
"value": "SelectAnyo",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "df6a6123-cf1a-1bc9-cd76-a5edd62ec8f1",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "f534163a-f037-eb71-27d2-9c675378c869",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "2158506a-2a8c-d3ef-bebe-b942ffa89118",
"properties": [
{
"name": "name",
"value": "Grafico",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "3e473f64-ea48-6e5d-6e34-a16845ebc1eb",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "80ee452e-ec84-f906-5977-f16e9be4ccd4",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "cbeefe1f-143d-ad9f-6e11-a96818590c49",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"value": "Imprimir",
"type": "Id"
},
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "roundCorners",
"value": "",
"type": "RoundCorners"
},
{
"name": "textAlign",
"value": "center",
"type": "TextAlign"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "acc6bde2-e5bd-a52f-ad6a-db14cf956bdf",
"type": "LayoutSpace",
"typeDesc": "Space",
"parent": "UnIqEiD",
"properties": [
{
"name": "height",
"value": "",
"type": "Integer"
},
{
"name": "backgroundColor",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "64b07960-f21e-b93e-4911-8c2c025d0d3b",
"type": "LayoutRow",
"typeDesc": "Row",
"parent": "UnIqEiD",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Footer"
},
{
"name": "height",
"type": "Integer",
"value": "50"
},
{
"name": "backgroundColor",
"type": "Color",
"value": "#e0e0e0"
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": "cdfdd-round"
},
{
"name": "textAlign",
"type": "TextAlign",
"value": "right"
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "e03427a4-44c1-d56c-e8e5-ec4b6b48a612",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "64b07960-f21e-b93e-4911-8c2c025d0d3b",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Footer_Text"
},
{
"name": "columnSpan",
"type": "Integer",
"value": "20"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": ""
},
{
"name": "columnAppend",
"type": "Integer",
"value": ""
},
{
"name": "columnPrependTop",
"type": "Boolean",
"value": "false"
},
{
"name": "columnAppendBottom",
"type": "Boolean",
"value": "false"
},
{
"name": "columnBorder",
"type": "Boolean",
"value": false
},
{
"name": "columnBigBorder",
"type": "Boolean",
"value": false
},
{
"name": "height",
"type": "Integer",
"value": "40"
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": "right"
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "b45069a3-a949-0502-b04e-c736d142c232",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "e03427a4-44c1-d56c-e8e5-ec4b6b48a612",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Text"
},
{
"name": "html",
"type": "Html",
"value": " "
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
},
{
"id": "e5c22f13-2f56-9638-5a05-b675a84fc695",
"type": "LayoutColumn",
"typeDesc": "Column",
"parent": "64b07960-f21e-b93e-4911-8c2c025d0d3b",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Footer_Image"
},
{
"name": "columnSpan",
"type": "Integer",
"value": "4"
},
{
"name": "columnPrepend",
"type": "Integer",
"value": ""
},
{
"name": "columnAppend",
"type": "Integer",
"value": "0"
},
{
"name": "columnPrependTop",
"type": "Boolean",
"value": false
},
{
"name": "columnAppendBottom",
"type": "Boolean",
"value": false
},
{
"name": "columnBorder",
"type": "Boolean",
"value": false
},
{
"name": "columnBigBorder",
"type": "Boolean",
"value": false
},
{
"name": "height",
"type": "Integer",
"value": ""
},
{
"name": "backgroundColor",
"type": "Color",
"value": ""
},
{
"name": "roundCorners",
"type": "RoundCorners",
"value": ""
},
{
"name": "textAlign",
"type": "TextAlign",
"value": "left"
},
{
"name": "cssClass",
"type": "String",
"value": ""
}
]
},
{
"id": "68d6b48f-a44c-99af-7261-38b98e99259e",
"type": "LayoutHtml",
"typeDesc": "Html",
"parent": "e5c22f13-2f56-9638-5a05-b675a84fc695",
"properties": [
{
"name": "name",
"type": "Id",
"value": "Image"
},
{
"name": "html",
"type": "Html",
"value": "\n\n "
},
{
"name": "fontSize",
"value": "",
"type": "Integer"
},
{
"name": "color",
"value": "",
"type": "Color"
},
{
"name": "cssClass",
"value": "",
"type": "String"
}
]
}
]
},
"components": {
"rows": [
{
"id": "SELECTORS",
"name": "Selects",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Selects",
"type": "Label"
}
]
},
{
"id": "301ed13f-9260-53cf-847e-520aaee59a5a",
"type": "ComponentsSelect",
"typeDesc": "Select Component",
"parent": "SELECTORS",
"properties": [
{
"name": "name",
"value": "ComboArancelario",
"type": "Id"
},
{
"name": "parameter",
"value": "${p:Codigo}",
"type": "Parameter"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "valueAsId",
"value": "false",
"type": "Boolean"
},
{
"name": "externalPlugin",
"value": "",
"type": "String"
},
{
"name": "dataSource",
"value": "CodArancelario",
"type": "Datasource"
},
{
"name": "valuesArray",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "${p:acArancelario}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postFetch",
"value": "",
"type": "JavaScript"
},
{
"name": "preChange",
"value": "",
"type": "JavaScript"
},
{
"name": "postChange",
"value": "function Producto() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('cod','0');\n}",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
},
{
"name": "extraOptions",
"value": "[]",
"type": "OptionArray"
}
]
},
{
"id": "ff5fbd4a-65a4-88da-a592-1c30d32138d4",
"type": "ComponentsSelect",
"typeDesc": "Select Component",
"parent": "SELECTORS",
"properties": [
{
"name": "name",
"value": "ddlAnyo",
"type": "Id"
},
{
"name": "parameter",
"value": "${p:anyo}",
"type": "Parameter"
},
{
"name": "listeners",
"value": "['${p:cod}']",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[[\"cod\",\"cod\"]]",
"type": "ValuesArray"
},
{
"name": "valueAsId",
"value": "true",
"type": "Boolean"
},
{
"name": "externalPlugin",
"value": "",
"type": "String"
},
{
"name": "dataSource",
"value": "sqlAnyo",
"type": "Datasource"
},
{
"name": "valuesArray",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "htmlObject",
"value": "SelectAnyo",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postFetch",
"value": "",
"type": "JavaScript"
},
{
"name": "preChange",
"value": "",
"type": "JavaScript"
},
{
"name": "postChange",
"value": "function Producto() {\n //alert(\"msg\"+a.series);\n Dashboards.fireChange('anyo','0');\n}",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
},
{
"name": "extraOptions",
"value": "[]",
"type": "OptionArray"
}
]
},
{
"id": "GENERIC",
"name": "Generic",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Generic",
"type": "Label"
}
]
},
{
"id": "f37281ff-1de5-d756-e3ca-42d435dd5b4e",
"type": "ComponentsParameter",
"typeDesc": "Simple parameter",
"parent": "GENERIC",
"properties": [
{
"name": "name",
"value": "Codigo",
"type": "Id"
},
{
"name": "propertyValue",
"value": "Codigo",
"type": "String"
},
{
"name": "parameterViewRole",
"value": "unused",
"type": "parameterViewRoleCustom"
},
{
"name": "bookmarkable",
"value": "false",
"type": "Boolean"
}
]
},
{
"id": "e188a0bf-a040-133c-5620-35a4d54f0ae6",
"type": "ComponentsParameter",
"typeDesc": "Simple parameter",
"parent": "GENERIC",
"properties": [
{
"name": "name",
"value": "cod",
"type": "Id"
},
{
"name": "propertyValue",
"value": "cod",
"type": "String"
},
{
"name": "parameterViewRole",
"value": "unused",
"type": "parameterViewRoleCustom"
},
{
"name": "bookmarkable",
"value": "false",
"type": "Boolean"
}
]
},
{
"id": "d477be50-ae55-eb34-b3ee-cd12ee76ed4c",
"type": "ComponentsParameter",
"typeDesc": "Simple parameter",
"parent": "GENERIC",
"properties": [
{
"name": "name",
"value": "anyo",
"type": "Id"
},
{
"name": "propertyValue",
"value": "anyo",
"type": "String"
},
{
"name": "parameterViewRole",
"value": "unused",
"type": "parameterViewRoleCustom"
},
{
"name": "bookmarkable",
"value": "false",
"type": "Boolean"
}
]
},
{
"id": "OTHERCOMPONENTS",
"name": "Others",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Others",
"type": "Label"
}
]
},
{
"id": "4c73d1f0-7140-6e42-65d4-0a8cf59fcc97",
"type": "ComponentsTable",
"typeDesc": "table Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "TablaPlantas",
"type": "Id"
},
{
"name": "expandContainerObject",
"value": "",
"type": "String"
},
{
"name": "listeners",
"value": "['${p:Codigo}']",
"type": "Listeners"
},
{
"name": "oLanguage",
"value": "{\n \"sProcessing\": \"Procesando...\",\n \"sLengthMenu\": \"Mostrar _MENU_ registros\",\n \"sZeroRecords\": \"No se encontraron resultados\",\n \"sEmptyTable\": \"Ningún dato disponible en esta tabla\",\n \"sInfo\": \"Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros\",\n \"sInfoEmpty\": \"Mostrando registros del 0 al 0 de un total de 0 registros\",\n \"sInfoFiltered\": \"(filtrado de un total de _MAX_ registros)\",\n \"sInfoPostFix\": \"\",\n \"sSearch\": \"Buscar:\",\n \"sUrl\": \"\",\n \"sInfoThousands\": \",\",\n \"sLoadingRecords\": \"Cargando...\",\n \"oPaginate\": {\n \"sFirst\": \"Primero\",\n \"sLast\": \"Último\",\n \"sNext\": \"Siguiente\",\n \"sPrevious\": \"Anterior\"\n },\n \"oAria\": {\n \"sSortAscending\": \": Activar para ordenar la columna de manera ascendente\",\n \"sSortDescending\": \": Activar para ordenar la columna de manera descendente\"\n }\n}",
"type": "JavaScript"
},
{
"name": "colSortable",
"value": "[]",
"type": "Array"
},
{
"name": "parameters",
"value": "[[\"Codigo\",\"Codigo\"]]",
"type": "ValuesArray"
},
{
"name": "expandParameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "colHeaders",
"value": "[\"Código\",\"Descripción\",\"Total Empresas\"]",
"type": "Array"
},
{
"name": "colTypes",
"value": "[]",
"type": "colTypesCustom"
},
{
"name": "colFormats",
"value": "[]",
"type": "Array"
},
{
"name": "colWidths",
"value": "[\"20%\",\"60%\",\"10%\"]",
"type": "Array"
},
{
"name": "info",
"value": "true",
"type": "Boolean"
},
{
"name": "sort",
"value": "true",
"type": "Boolean"
},
{
"name": "expandOnClick",
"value": "false",
"type": "Boolean"
},
{
"name": "paginate",
"value": "true",
"type": "Boolean"
},
{
"name": "displayLength",
"value": "4",
"type": "Integer"
},
{
"name": "lengthChange",
"value": "false",
"type": "Boolean"
},
{
"name": "filter",
"value": "true",
"type": "Boolean"
},
{
"name": "colSearchable",
"value": "[]",
"type": "Array"
},
{
"name": "drawCallback",
"value": "",
"type": "JavaScript"
},
{
"name": "dataSource",
"value": "PlantasxCodA",
"type": "Datasource"
},
{
"name": "sDom",
"value": "",
"type": "JavaScript"
},
{
"name": "sortBy",
"value": "[]",
"type": "SortByArray"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "priority",
"value": "5",
"type": "Integer"
},
{
"name": "tableStyle",
"value": "themeroller",
"type": "TableStyle"
},
{
"name": "paginationType",
"value": "two_button",
"type": "PaginationType"
},
{
"name": "htmlObject",
"value": "${p:Plantas}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "paginateServerside",
"value": "false",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "function f() {\n$('.dataBarContainer a').each(function(k,v) {\nvar value = sprintf('%.2f',$(this).attr('title').substr($(this).attr('title').indexOf(':')+1));\n$(this).attr('title', value); \n});\n}",
"type": "JavaScript"
},
{
"name": "postFetch",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "preChange",
"value": "",
"type": "JavaScript"
},
{
"name": "postChange",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "Seleccionar Código Arancelario ",
"type": "Html"
},
{
"name": "extraOptions",
"value": "[]",
"type": "OptionArray"
},
{
"name": "clickAction",
"value": "function cod(a) {\n // alert(\"msg\"+a.series);\n alert(\"Seleccione año en la parte inferior de la tabla, para Visualizar los Montos de Ventas de las 10 Principales Empresas\");\n Dashboards.fireChange('cod',a.series);\n}",
"type": "JavaScript"
}
]
},
{
"id": "a83d092f-0045-3fb6-0f47-8cadf6ad9266",
"type": "ComponentsexportButton",
"typeDesc": "Export Button Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "ExportT",
"type": "Id"
},
{
"name": "label",
"value": "Exportar",
"type": "String"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "componentName",
"value": "TablaPlantas",
"type": "String"
},
{
"name": "outputType",
"value": "csv",
"type": "String"
},
{
"name": "htmlObject",
"value": "${p:BotonT}",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
}
]
},
{
"id": "7f573dcf-5755-7b71-adcb-4c6eb5b03d01",
"type": "ComponentsexportButton",
"typeDesc": "Export Button Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "ExportG",
"type": "Id"
},
{
"name": "label",
"value": "Exportar",
"type": "String"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "parameters",
"value": "[]",
"type": "ValuesArray"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "componentName",
"value": "MontoVentas",
"type": "String"
},
{
"name": "outputType",
"value": "csv",
"type": "String"
},
{
"name": "htmlObject",
"value": "BotonG",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
}
]
},
{
"id": "ba62827f-3b68-f00b-9f4b-f1869d456ba7",
"type": "ComponentsbuttonComponent",
"typeDesc": "Button Component",
"parent": "OTHERCOMPONENTS",
"properties": [
{
"name": "name",
"value": "PDF",
"type": "Id"
},
{
"name": "label",
"value": "Exportar PDF",
"type": "String"
},
{
"name": "listeners",
"value": "[]",
"type": "Listeners"
},
{
"name": "expression",
"value": "function f() { window.print() }",
"type": "JavaScript"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "buttonStyle",
"value": "themeroller",
"type": "TableStyle"
},
{
"name": "htmlObject",
"value": "Imprimir",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "preChange",
"value": "",
"type": "JavaScript"
},
{
"name": "postChange",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
}
]
},
{
"id": "CHARTS",
"name": "Charts",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "Charts",
"type": "Label"
}
]
},
{
"id": "d8259b64-8304-5a02-81a0-761db02360c0",
"type": "ComponentscccBarChart",
"typeDesc": "CCC Bar Chart",
"parent": "CHARTS",
"properties": [
{
"name": "name",
"value": "MontoVentas",
"type": "Id"
},
{
"name": "title",
"value": "Principales 10 empresas que producen el Código Arancelario y sus montos de ventas",
"type": "String"
},
{
"name": "listeners",
"value": "['${p:cod}','${p:anyo}']",
"type": "Listeners"
},
{
"name": "customfunction",
"value": "",
"type": "JavaScript"
},
{
"name": "parameters",
"value": "[[\"cod\",\"cod\"],[\"anyo\",\"anyo\"]]",
"type": "ValuesArray"
},
{
"name": "dataSource",
"value": "Ventas",
"type": "Datasource"
},
{
"name": "height",
"value": "400",
"type": "Integer"
},
{
"name": "width",
"value": "",
"type": "Integer"
},
{
"name": "refreshPeriod",
"value": "",
"type": "Integer"
},
{
"name": "priority",
"value": 5,
"type": "Integer"
},
{
"name": "colors",
"value": "[]",
"type": "Array"
},
{
"name": "htmlObject",
"value": "Grafico",
"type": "HtmlObject"
},
{
"name": "executeAtStart",
"value": "true",
"type": "Boolean"
},
{
"name": "preExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "postFetch",
"value": "",
"type": "JavaScript"
},
{
"name": "postExecution",
"value": "",
"type": "JavaScript"
},
{
"name": "preChange",
"value": "",
"type": "JavaScript"
},
{
"name": "postChange",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltip",
"value": "",
"type": "Html"
},
{
"name": "extensionPoints",
"value": "[[\"xAxisLabel_textAngle\",\"-Math.PI/3\"],[\"xAxisLabel_textAlign\",\"right\"],[\"xAxisLabel_textBaseline\",\"top\"],[\"axisGrid_strokeStyle\",\"lightgray\"]]",
"type": "ValuesArray"
},
{
"name": "animate",
"value": true,
"type": "Boolean"
},
{
"name": "barSizeMax",
"value": 2000,
"type": "Float"
},
{
"name": "barSizeRatio",
"value": 0.9,
"type": "Float"
},
{
"name": "barStackedMargin",
"value": 0,
"type": "Float"
},
{
"name": "baseAxisClickAction",
"value": "",
"type": "JavaScript"
},
{
"name": "baseAxisDoubleClickAction",
"value": "",
"type": "JavaScript"
},
{
"name": "baseAxisGrid",
"value": "false",
"type": "Boolean"
},
{
"name": "baseAxisLabelSpacingMin",
"value": "",
"type": "Float"
},
{
"name": "baseAxisOffset",
"value": 0,
"type": "Float"
},
{
"name": "baseAxisOverlappedLabelsMode",
"value": "hide",
"type": "cccBaseAxisOverlappedLabelsModeCustom"
},
{
"name": "baseAxisPosition",
"value": "",
"type": "cccBaseAxisPositionCustom"
},
{
"name": "baseAxisSize",
"value": "",
"type": "String"
},
{
"name": "baseAxisSizeMax",
"value": "",
"type": "String"
},
{
"name": "baseAxisTicks",
"value": true,
"type": "Boolean"
},
{
"name": "baseAxisTitle",
"value": "Empresa",
"type": "String"
},
{
"name": "baseAxisTitleAlign",
"value": "",
"type": "cccBaseAxisTitleAlignCustom"
},
{
"name": "baseAxisTitleFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "baseAxisTitleMargins",
"value": "0",
"type": "String"
},
{
"name": "baseAxisTitleSize",
"value": "",
"type": "String"
},
{
"name": "baseAxisTitleSizeMax",
"value": "",
"type": "String"
},
{
"name": "baseAxisTooltipAutoContent",
"value": "value",
"type": "cccBaseAxisTooltipAutoContentCustom"
},
{
"name": "baseAxisTooltipEnabled",
"value": true,
"type": "Boolean"
},
{
"name": "baseAxisTooltipFormat",
"value": "",
"type": "JavaScript"
},
{
"name": "baseAxisVisible",
"value": true,
"type": "Boolean"
},
{
"name": "categoryRole",
"value": "",
"type": "String"
},
{
"name": "clearSelectionMode",
"value": "emptySpaceClick",
"type": "cccClearSelectionModeCustom"
},
{
"name": "clickable",
"value": false,
"type": "Boolean"
},
{
"name": "clickAction",
"value": "",
"type": "JavaScript"
},
{
"name": "color2AxisColors",
"value": "[]",
"type": "Array"
},
{
"name": "color2AxisLegendClickMode",
"value": "toggleVisible",
"type": "cccColor2AxisLegendClickModeCustom"
},
{
"name": "color2AxisLegendDrawLine",
"value": "",
"type": "Boolean"
},
{
"name": "color2AxisLegendDrawMarker",
"value": "",
"type": "Boolean"
},
{
"name": "color2AxisLegendShape",
"value": "",
"type": "cccColor2AxisLegendShapeCustom"
},
{
"name": "color2AxisLegendVisible",
"value": true,
"type": "Boolean"
},
{
"name": "color2AxisTransform",
"value": "",
"type": "JavaScript"
},
{
"name": "color2AxisUnbound",
"value": "",
"type": "String"
},
{
"name": "colorRole",
"value": "",
"type": "String"
},
{
"name": "colorTransform",
"value": "",
"type": "JavaScript"
},
{
"name": "colorUnbound",
"value": "",
"type": "String"
},
{
"name": "compatVersion",
"value": 2,
"type": "Float"
},
{
"name": "contentMargins",
"value": "0",
"type": "String"
},
{
"name": "contentPaddings",
"value": "0",
"type": "String"
},
{
"name": "crosstabMode",
"value": true,
"type": "Boolean"
},
{
"name": "ctrlSelectMode",
"value": true,
"type": "Boolean"
},
{
"name": "dataCategoriesCount",
"value": "",
"type": "Float"
},
{
"name": "dataIgnoreMetadataLabels",
"value": false,
"type": "Boolean"
},
{
"name": "dataMeasuresInColumns",
"value": false,
"type": "Boolean"
},
{
"name": "dataPartRole",
"value": "",
"type": "String"
},
{
"name": "dataSeparator",
"value": "~",
"type": "String"
},
{
"name": "doubleClickAction",
"value": "",
"type": "JavaScript"
},
{
"name": "groupedLabelSep",
"value": " ~ ",
"type": "String"
},
{
"name": "hoverable",
"value": false,
"type": "Boolean"
},
{
"name": "ignoreNulls",
"value": true,
"type": "Boolean"
},
{
"name": "interactive",
"value": "",
"type": "Boolean"
},
{
"name": "isMultiValued",
"value": false,
"type": "Boolean"
},
{
"name": "leafContentOverflow",
"value": "auto",
"type": "cccLeafContentOverflowCustom"
},
{
"name": "legend",
"value": "false",
"type": "Boolean"
},
{
"name": "legendAlign",
"value": "",
"type": "cccLegendAlignCustom"
},
{
"name": "legendClickMode",
"value": "toggleVisible",
"type": "cccLegendClickModeCustom"
},
{
"name": "legendDrawLine",
"value": "",
"type": "Boolean"
},
{
"name": "legendDrawMarker",
"value": "",
"type": "Boolean"
},
{
"name": "legendFont",
"value": "10px sans-serif",
"type": "String"
},
{
"name": "legendItemPadding",
"value": 2.5,
"type": "Float"
},
{
"name": "legendMargins",
"value": "0",
"type": "String"
},
{
"name": "legendMarkerSize",
"value": 15,
"type": "Float"
},
{
"name": "legendPaddings",
"value": "5",
"type": "String"
},
{
"name": "legendPosition",
"value": "bottom",
"type": "cccLegendPositionCustom"
},
{
"name": "legendShape",
"value": "",
"type": "cccLegendShapeCustom"
},
{
"name": "legendSize",
"value": "",
"type": "String"
},
{
"name": "legendSizeMax",
"value": "",
"type": "String"
},
{
"name": "legendTextMargin",
"value": 6,
"type": "Float"
},
{
"name": "legendVisible",
"value": true,
"type": "Boolean"
},
{
"name": "margins",
"value": "3",
"type": "String"
},
{
"name": "measuresIndexes",
"value": "[]",
"type": "Array"
},
{
"name": "multiChartColumnsMax",
"value": 3,
"type": "Float"
},
{
"name": "multiChartIndexes",
"value": "[]",
"type": "Array"
},
{
"name": "multiChartMax",
"value": "",
"type": "Float"
},
{
"name": "multiChartOverflow",
"value": "grow",
"type": "cccMultiChartOverflowCustom"
},
{
"name": "multiChartRole",
"value": "",
"type": "String"
},
{
"name": "multiChartSingleColFillsHeight",
"value": true,
"type": "Boolean"
},
{
"name": "multiChartSingleRowFillsHeight",
"value": true,
"type": "Boolean"
},
{
"name": "nullInterpolationMode",
"value": "none",
"type": "cccNullInterpolationModeCustom"
},
{
"name": "orientation",
"value": "horizontal",
"type": "cccOrientationCustom"
},
{
"name": "ortho2AxisDesiredTickCount",
"value": "",
"type": "Float"
},
{
"name": "ortho2AxisDomainRoundMode",
"value": "tick",
"type": "cccOrtho2AxisDomainRoundModeCustom"
},
{
"name": "ortho2AxisDomainScope",
"value": "global",
"type": "cccOrtho2AxisDomainScopeCustom"
},
{
"name": "ortho2AxisFixedMax",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisFixedMin",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisGrid",
"value": false,
"type": "Boolean"
},
{
"name": "ortho2AxisLabelSpacingMin",
"value": "",
"type": "Float"
},
{
"name": "ortho2AxisMinorTicks",
"value": true,
"type": "Boolean"
},
{
"name": "ortho2AxisOffset",
"value": 0,
"type": "Float"
},
{
"name": "ortho2AxisOriginIsZero",
"value": "",
"type": "Boolean"
},
{
"name": "ortho2AxisOverlappedLabelsMode",
"value": "hide",
"type": "cccOrtho2AxisOverlappedLabelsModeCustom"
},
{
"name": "ortho2AxisPosition",
"value": "",
"type": "cccOrtho2AxisPositionCustom"
},
{
"name": "ortho2AxisSize",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisSizeMax",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisTickExponentMax",
"value": "",
"type": "Float"
},
{
"name": "ortho2AxisTickExponentMin",
"value": "",
"type": "Float"
},
{
"name": "ortho2AxisTickFormatter",
"value": "",
"type": "JavaScript"
},
{
"name": "ortho2AxisTicks",
"value": true,
"type": "Boolean"
},
{
"name": "ortho2AxisTitle",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisTitleAlign",
"value": "",
"type": "cccOrtho2AxisTitleAlignCustom"
},
{
"name": "ortho2AxisTitleFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "ortho2AxisTitleMargins",
"value": "0",
"type": "String"
},
{
"name": "ortho2AxisTitleSize",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisTitleSizeMax",
"value": "",
"type": "String"
},
{
"name": "ortho2AxisVisible",
"value": true,
"type": "Boolean"
},
{
"name": "ortho2AxisZeroLine",
"value": true,
"type": "Boolean"
},
{
"name": "orthoAxisDesiredTickCount",
"value": "",
"type": "Float"
},
{
"name": "orthoAxisDomainRoundMode",
"value": "tick",
"type": "cccOrthoAxisDomainRoundModeCustom"
},
{
"name": "orthoAxisDomainScope",
"value": "global",
"type": "cccOrthoAxisDomainScopeCustom"
},
{
"name": "orthoAxisFixedMax",
"value": "",
"type": "String"
},
{
"name": "orthoAxisFixedMin",
"value": "",
"type": "String"
},
{
"name": "orthoAxisGrid",
"value": false,
"type": "Boolean"
},
{
"name": "orthoAxisLabelSpacingMin",
"value": "",
"type": "Float"
},
{
"name": "orthoAxisMinorTicks",
"value": true,
"type": "Boolean"
},
{
"name": "orthoAxisOffset",
"value": 0,
"type": "Float"
},
{
"name": "orthoAxisOriginIsZero",
"value": "",
"type": "Boolean"
},
{
"name": "orthoAxisOverlappedLabelsMode",
"value": "hide",
"type": "cccOrthoAxisOverlappedLabelsModeCustom"
},
{
"name": "orthoAxisPosition",
"value": "",
"type": "cccOrthoAxisPositionCustom"
},
{
"name": "orthoAxisSize",
"value": "-",
"type": "String"
},
{
"name": "orthoAxisSizeMax",
"value": "",
"type": "String"
},
{
"name": "orthoAxisTickExponentMax",
"value": "",
"type": "Float"
},
{
"name": "orthoAxisTickExponentMin",
"value": "",
"type": "Float"
},
{
"name": "orthoAxisTickFormatter",
"value": "",
"type": "JavaScript"
},
{
"name": "orthoAxisTicks",
"value": true,
"type": "Boolean"
},
{
"name": "orthoAxisTitle",
"value": "Monto de Venta",
"type": "String"
},
{
"name": "orthoAxisTitleAlign",
"value": "",
"type": "cccOrthoAxisTitleAlignCustom"
},
{
"name": "orthoAxisTitleFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "orthoAxisTitleMargins",
"value": "0",
"type": "String"
},
{
"name": "orthoAxisTitleSize",
"value": "",
"type": "String"
},
{
"name": "orthoAxisTitleSizeMax",
"value": "",
"type": "String"
},
{
"name": "orthoAxisVisible",
"value": true,
"type": "Boolean"
},
{
"name": "orthoAxisZeroLine",
"value": true,
"type": "Boolean"
},
{
"name": "overflowMarkersVisible",
"value": true,
"type": "Boolean"
},
{
"name": "paddings",
"value": "0",
"type": "String"
},
{
"name": "panelSizeRatio",
"value": 0.9,
"type": "Float"
},
{
"name": "percentValueFormat",
"value": "",
"type": "JavaScript"
},
{
"name": "plot2",
"value": false,
"type": "Boolean"
},
{
"name": "plot2AreasVisible",
"value": false,
"type": "Boolean"
},
{
"name": "plot2ColorAxis",
"value": 2,
"type": "Float"
},
{
"name": "plot2DotsVisible",
"value": true,
"type": "Boolean"
},
{
"name": "plot2LinesVisible",
"value": true,
"type": "Boolean"
},
{
"name": "plot2NullInterpolationMode",
"value": "none",
"type": "cccPlot2NullInterpolationModeCustom"
},
{
"name": "plot2OrthoAxis",
"value": 1,
"type": "Float"
},
{
"name": "plot2Series",
"value": "[]",
"type": "Array"
},
{
"name": "plot2SeriesIndexes",
"value": -1,
"type": "Array"
},
{
"name": "plot2Stacked",
"value": false,
"type": "Boolean"
},
{
"name": "plot2TrendLabel",
"value": "",
"type": "String"
},
{
"name": "plot2TrendType",
"value": "",
"type": "String"
},
{
"name": "plot2ValuesAnchor",
"value": "",
"type": "cccPlot2ValuesAnchorCustom"
},
{
"name": "plot2ValuesFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "plot2ValuesMask",
"value": "{value}",
"type": "String"
},
{
"name": "plot2ValuesVisible",
"value": false,
"type": "Boolean"
},
{
"name": "plotFrameVisible",
"value": true,
"type": "Boolean"
},
{
"name": "renderCallback",
"value": "",
"type": "JavaScript"
},
{
"name": "selectable",
"value": false,
"type": "Boolean"
},
{
"name": "selectionChangedAction",
"value": "",
"type": "JavaScript"
},
{
"name": "seriesInRows",
"value": false,
"type": "Boolean"
},
{
"name": "seriesRole",
"value": "",
"type": "String"
},
{
"name": "smallAspectRatio",
"value": "",
"type": "Float"
},
{
"name": "smallContentMargins",
"value": "0",
"type": "String"
},
{
"name": "smallContentPaddings",
"value": "0",
"type": "String"
},
{
"name": "smallHeight",
"value": "",
"type": "String"
},
{
"name": "smallMargins",
"value": "2%",
"type": "String"
},
{
"name": "smallPaddings",
"value": "0",
"type": "String"
},
{
"name": "smallTitleAlign",
"value": "",
"type": "cccSmallTitleAlignCustom"
},
{
"name": "smallTitleFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "smallTitleMargins",
"value": "0",
"type": "String"
},
{
"name": "smallTitlePaddings",
"value": "0",
"type": "String"
},
{
"name": "smallTitlePosition",
"value": "top",
"type": "cccSmallTitlePositionCustom"
},
{
"name": "smallTitleSize",
"value": "",
"type": "String"
},
{
"name": "smallTitleSizeMax",
"value": "",
"type": "String"
},
{
"name": "smallWidth",
"value": "",
"type": "String"
},
{
"name": "stacked",
"value": false,
"type": "Boolean"
},
{
"name": "timeSeries",
"value": false,
"type": "Boolean"
},
{
"name": "timeSeriesFormat",
"value": "%Y-%m-%d",
"type": "String"
},
{
"name": "titleAlign",
"value": "",
"type": "cccTitleAlignCustom"
},
{
"name": "titleFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "titleMargins",
"value": "0",
"type": "String"
},
{
"name": "titlePaddings",
"value": "0",
"type": "String"
},
{
"name": "titlePosition",
"value": "top",
"type": "cccTitlePositionCustom"
},
{
"name": "titleSize",
"value": "",
"type": "String"
},
{
"name": "titleSizeMax",
"value": "",
"type": "String"
},
{
"name": "tooltipArrowVisible",
"value": "",
"type": "Boolean"
},
{
"name": "tooltipEnabled",
"value": true,
"type": "Boolean"
},
{
"name": "tooltipFade",
"value": true,
"type": "Boolean"
},
{
"name": "tooltipFollowMouse",
"value": false,
"type": "Boolean"
},
{
"name": "tooltipFormat",
"value": "",
"type": "JavaScript"
},
{
"name": "tooltipGravity",
"value": "",
"type": "cccTooltipGravityCustom"
},
{
"name": "tooltipHtml",
"value": true,
"type": "Boolean"
},
{
"name": "tooltipOffset",
"value": "",
"type": "Float"
},
{
"name": "tooltipOpacity",
"value": 0.9,
"type": "Float"
},
{
"name": "tooltipUseCorners",
"value": "",
"type": "Boolean"
},
{
"name": "trendAreasVisible",
"value": false,
"type": "Boolean"
},
{
"name": "trendColorAxis",
"value": 2,
"type": "Float"
},
{
"name": "trendDotsVisible",
"value": false,
"type": "Boolean"
},
{
"name": "trendLabel",
"value": "",
"type": "String"
},
{
"name": "trendLinesVisible",
"value": true,
"type": "Boolean"
},
{
"name": "trendOrthoAxis",
"value": 1,
"type": "Float"
},
{
"name": "trendStacked",
"value": false,
"type": "Boolean"
},
{
"name": "trendType",
"value": "",
"type": "String"
},
{
"name": "trendValuesAnchor",
"value": "right",
"type": "cccTrendValuesAnchorCustom"
},
{
"name": "trendValuesFont",
"value": "12px sans-serif",
"type": "String"
},
{
"name": "trendValuesMask",
"value": "",
"type": "String"
},
{
"name": "trendValuesVisible",
"value": false,
"type": "Boolean"
},
{
"name": "userSelectionAction",
"value": "",
"type": "JavaScript"
},
{
"name": "valueFormat",
"value": "",
"type": "JavaScript"
},
{
"name": "valueRole",
"value": "",
"type": "String"
},
{
"name": "valuesAnchor",
"value": "",
"type": "cccValuesAnchorCustom"
},
{
"name": "valuesFont",
"value": "10px sans-serif",
"type": "String"
},
{
"name": "valuesMask",
"value": "",
"type": "String"
},
{
"name": "valuesVisible",
"value": "",
"type": "Boolean"
}
],
"meta_cdwSupport": "true"
}
]
},
"datasources": {
"rows": [
{
"id": "SQL",
"name": "SQL Queries",
"type": "Label",
"typeDesc": "Group",
"parent": "UnIqEiD",
"properties": [
{
"name": "Group",
"value": "SQL Queries",
"type": "Label"
}
]
},
{
"id": "4bb14b05-163e-7ee3-d565-8f35c99a1639",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "CodArancelario",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT DISTINCT\n \"dimension_codigoarancelario\".\"codigo\" as Cod, (\"dimension_codigoarancelario\".\"codigo\" || ' - ' || \"dimension_codigoarancelario\".\"descripcion_ref\") as descr\nFROM\n \"dimension_codigoarancelario\"\nWHERE \n character_length(\"dimension_codigoarancelario\".\"codigo\") = 2\nORDER BY\n Cod asc",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[]",
"type": "CdaParameters"
},
{
"name": "outputMode",
"value": "include",
"type": "OutputMode"
},
{
"name": "cdacolumns",
"value": "[]",
"type": "CdaColumnsArray"
},
{
"name": "cdacalculatedcolumns",
"value": "[]",
"type": "CdaCalculatedColumnsArray"
},
{
"name": "output",
"value": "[]",
"type": "IndexArray"
},
{
"name": "cacheDuration",
"value": 3600,
"type": "Integer"
},
{
"name": "cache",
"value": "true",
"type": "Boolean"
}
],
"meta": "CDA",
"meta_conntype": "sql.jndi",
"meta_datype": "sql"
},
{
"id": "fd4ea723-52fc-6df4-c185-8335d8ab49c7",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "CodArancelario2",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT\n \"dimension_codigoarancelario\".\"codigo\" || ' - ' || \"dimension_codigoarancelario\".\"descripcion_ref\"\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${Codigo} || '%'\nGROUP BY\n \"dimension_codigoarancelario\".\"codigo\",\"dimension_codigoarancelario\".\"descripcion_ref\"",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"Codigo\",\"Codigo\",\"String\",\"\"]]",
"type": "CdaParameters"
},
{
"name": "outputMode",
"value": "include",
"type": "OutputMode"
},
{
"name": "cdacolumns",
"value": "[]",
"type": "CdaColumnsArray"
},
{
"name": "cdacalculatedcolumns",
"value": "[]",
"type": "CdaCalculatedColumnsArray"
},
{
"name": "output",
"value": "[]",
"type": "IndexArray"
},
{
"name": "cacheDuration",
"value": 3600,
"type": "Integer"
},
{
"name": "cache",
"value": "true",
"type": "Boolean"
}
],
"meta": "CDA",
"meta_conntype": "sql.jndi",
"meta_datype": "sql"
},
{
"id": "a16b869c-1bfc-f194-06c1-3bf87101d741",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "PlantasxCodA",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "SELECT \n \"dimension_codigoarancelario\".\"codigo\" AS codigo,\n \"dimension_codigoarancelario\".\"descripcion_ref\" AS Descrip,\n count(distinct(\"hechos_bienesproducidos_empresa\".\"id_empresa\")) AS total\nFROM\n \"hechos_bienesproducidos_empresa\" INNER JOIN \"dimension_codigoarancelario\" ON \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\" = \"dimension_codigoarancelario\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${Codigo}||'%'\nGROUP BY\n codigo,\n Descrip\nORDER BY\n 1 ASC",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"Codigo\",\"Codigo\",\"String\",\"\"]]",
"type": "CdaParameters"
},
{
"name": "outputMode",
"value": "include",
"type": "OutputMode"
},
{
"name": "cdacolumns",
"value": "[]",
"type": "CdaColumnsArray"
},
{
"name": "cdacalculatedcolumns",
"value": "[]",
"type": "CdaCalculatedColumnsArray"
},
{
"name": "output",
"value": "[]",
"type": "IndexArray"
},
{
"name": "cacheDuration",
"value": 3600,
"type": "Integer"
},
{
"name": "cache",
"value": "true",
"type": "Boolean"
}
],
"meta": "CDA",
"meta_conntype": "sql.jndi",
"meta_datype": "sql"
},
{
"id": "9ff42054-4d5d-557f-2c52-dc9e928ad75c",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "Ventas",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "(SELECT\n \"dimension_empresa\".\"razon_social\" AS Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") AS Monto\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY\n Empresa\nORDER BY Monto DESC\nLIMIT 10)\nUNION\n(SELECT \n 'Otras Empresas' as Empresa,\n sum(\"hechos_bienesproducidos_empresa\".\"medida_monto_venta\") as Monto \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod} AND CAST(dimension_tiempo.anyo AS text) = ${anyo} AND dimension_empresa.id not in (\n SELECT\n \"hechos_bienesproducidos_empresa\".\"id_empresa\" \nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_empresa\" ON \"hechos_bienesproducidos_empresa\".\"id_empresa\" = \"dimension_empresa\".\"id\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\n AND CAST(dimension_tiempo.anyo AS text) = ${anyo}\nGROUP BY 1 \n )\nORDER BY Monto DESC) \nORDER BY 2 ASC \n",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"cod\",\"cod\",\"String\",\"\"],[\"anyo\",\"anyo\",\"String\",\"\"]]",
"type": "CdaParameters"
},
{
"name": "outputMode",
"value": "include",
"type": "OutputMode"
},
{
"name": "cdacolumns",
"value": "[]",
"type": "CdaColumnsArray"
},
{
"name": "cdacalculatedcolumns",
"value": "[]",
"type": "CdaCalculatedColumnsArray"
},
{
"name": "output",
"value": "[]",
"type": "IndexArray"
},
{
"name": "cacheDuration",
"value": 3600,
"type": "Integer"
},
{
"name": "cache",
"value": "true",
"type": "Boolean"
}
],
"meta": "CDA",
"meta_conntype": "sql.jndi",
"meta_datype": "sql"
},
{
"id": "546211ef-c107-b90f-1585-1a4f5830ab63",
"type": "Componentssql_sqlJndi",
"typeDesc": "sql over sqlJndi",
"parent": "SQL",
"properties": [
{
"name": "name",
"value": "sqlAnyo",
"type": "Id"
},
{
"name": "access",
"value": "public",
"type": "Access"
},
{
"name": "jndi",
"value": "smid",
"type": "Jndi"
},
{
"name": "query",
"value": "(SELECT '--Seleccione--')\nUNION\n(SELECT\n CAST(dimension_tiempo.anyo AS text) as anyo\nFROM\n \"dimension_codigoarancelario\" INNER JOIN \"hechos_bienesproducidos_empresa\" ON \"dimension_codigoarancelario\".\"id\" = \"hechos_bienesproducidos_empresa\".\"id_codigo_arancelario\"\n INNER JOIN \"dimension_tiempo\" ON \"hechos_bienesproducidos_empresa\".\"id_itempo\" = \"dimension_tiempo\".\"id\"\nWHERE\n dimension_codigoarancelario.codigo LIKE ${cod}\nGROUP BY\n anyo)\nORDER BY 1 desc\n ",
"type": "SqlQuery"
},
{
"name": "parameters",
"value": "[[\"cod\",\"cod\",\"String\",\"\"]]",
"type": "CdaParameters"
},
{
"name": "outputMode",
"value": "include",
"type": "OutputMode"
},
{
"name": "cdacolumns",
"value": "[]",
"type": "CdaColumnsArray"
},
{
"name": "cdacalculatedcolumns",
"value": "[]",
"type": "CdaCalculatedColumnsArray"
},
{
"name": "output",
"value": "[]",
"type": "IndexArray"
},
{
"name": "cacheDuration",
"value": 3600,
"type": "Integer"
},
{
"name": "cache",
"value": "true",
"type": "Boolean"
}
],
"meta": "CDA",
"meta_conntype": "sql.jndi",
"meta_datype": "sql"
}
]
},
"filename": "/cde/dashboard/Cuadro 2.cdfde"
}