Hi All,
I'm trying to create data-model so I would be able to use the "Pivot" for all my fields.
I run into trouble defining my multi-value field, the Pivot doesn't allow it to be added to the table and I couldn't fix this.
I'm sending the data using JSON, my data model definition for this field looks like this:
{
"displayName": "Location Vehicle Pair",
"required": false,
"multivalue": true,
"comment": "",
"hidden": false,
"properties": {
"location-name": {"type": "string","displayName": "Location Name"},
"vehicle-type": {"type": "string","displayName": "Vehicle Type"}
},
"fieldName": "location-vehicle-pair"
}
An example of this field in the event:
"location-vehicle-pair": [{"location-name": "Paris","vehicle-type": "Bus"},{"location-name": "London","vehicle-type": "Train"}]
In props.conf file I defined:
FIELDALIAS-location-vehicle-pair-location-name=location-vehicle-pair{}.location-name as location-vehicle-pair-location-name
FIELDALIAS-location-vehicle-pair-vehicle-type=location-vehicle-pair{}.vehicle-type as location-vehicle-pair-vehicle-type
Which works for array fields and not for this, this: location-vehicle-pair{}.vehicle-type works in search but not here.
The other fields in this event are all single values or arrays, and they all work for me in the Pivot (arrays with use of props.conf file FIELDALIAS)
I would rather not use regex if possible.
Do anyone know what's the problem with my definitions?
Thanks!
... View more
