Dear App Experts,
is there a way to update a object type Variable with a Variable Mapping Select Element?
I was not able to do it with the definition seen below. Is there a way to update the “timestamp_variable.fc_plus_1” variable here or will i need a entire seperate variable for each mapping?
{
“id”: “cost_center_overview_single_select_timestamp_variable_mapping_select_element”,
“type”: “variableMappingSelect”,
“source”: “cost_center_forecast_month_datasource”,“sourceOptions”: {
“sql”: “Select *, to_char(forecast_month + interval ‘1 month’, ‘YYYY-MM’) as fc_plus_1, to_char(forecast_month + interval ‘2 month’, ‘YYYY-MM’) as fc_plus_2, to_char(forecast_month + interval ‘3 month’, ‘YYYY-MM’) as fc_plus_3, to_char(forecast_month + interval ‘4 month’, ‘YYYY-MM’) as fc_plus_4, to_char(forecast_month + interval ‘5 month’, ‘YYYY-MM’) as fc_plus_5, to_char(forecast_month + interval ‘6 month’, ‘YYYY-MM’) as fc_plus_6, to_char(forecast_month + interval ‘7 month’, ‘YYYY-MM’) as fc_plus_7, to_char(forecast_month + interval ‘8 month’, ‘YYYY-MM’) as fc_plus_8, to_char(forecast_month + interval ‘9 month’, ‘YYYY-MM’) as fc_plus_9, to_char(forecast_month + interval ‘10 month’, ‘YYYY-MM’) as fc_plus_10, to_char(forecast_month + interval ‘11 month’, ‘YYYY-MM’) as fc_plus_11, to_char(forecast_month + interval ‘12 month’, ‘YYYY-MM’) as fc_plus_12 from inputTable”,
“sort”: [
{
“name”: “forecast_month”,
“order”: “desc”
}
]
},
“config”: {
“selectByDefault”: {
“valueColumn”: “fc_month”,
“value”: “2022-05”
},
“$label”: {
“type”: “string”,
“value”: “{{timestamp_variable.fc_plus_1}} {{timestamp_test}}”
},
“labelColumn”: “fc_month”,
“mappings”: [
{
> “valueColumn”: “fc_plus_1”,
> “variable”: “timestamp_variable.fc_plus_1”
**> **
**> **
> },
{
“valueColumn”: “fc_plus_1”,
“variable”: “timestamp_test”
}
]
},