Date fields are shown as numbers even though mapping is set

I checked and the date is correctly set as "date string" but still shows incorrectly. Also, another field - ADME Assay/Admin Route - is set as "string" but it shows as count 1 and even when I click on the cell with 1 it still shows 1 instead of showing the value in the cell.
Wouldn't it work to just use customizeCell function to manually set comma-separated values for the fields that contain that data? 

Hi Maksim,

We were able to just always show 'count', then use complex customizeCell function to show in parentheses the individual values for string types. We were not yet able to show dates correctly and most probably will need to format them manually too in customizeCell. Currently I am not working on the issues, but within 2 weeks will come back to it.

Thank you,

Nikita

I was working on the issue further and found that when the first element in the data array is an actual date, then dates are shown correctly, but when it is null, - the type of the field is set as number which is causing the issue. I can't seem to be able to explicitly set the data type, could you help with that?

getmeasures: function (d) {
var aggbycols = d.columns.filter(function (col) { return !col.groupby && col.key != "compoundid" });
return aggbycols.map(function (col) {
var measureobj = { uniqueName: col.key.includes("reg-") ? col.key : col.label.toLowerCase(), active: true };
if (col.type == "float")
measureobj["aggregation"] = "average";
else if (col.type == "date" || (col.key.includes("reg-") && col.key.toLowerCase().includes("date")))
measureobj["aggregation"] = "max";
else
measureobj["aggregation"] = "count";
return measureobj;
});
},

getmapping: function (d) {
var mapping = {
resultid: {
type: "id"
}
};
d.columns.forEach(function (col) {
if (!col.groupby) {
if (col.type == "float")
mapping[col.label] = { type: "number" };
else if (col.type == "date")
mapping[col.label] = { type: "date string" };
else if ((col.key.includes("reg-") && col.key.toLowerCase().includes("date")))
mapping[col.key] = { type: "date string" };
/*else if (col.type == "date")
mapping[col.label] = { type: "date string" };
else if (col.type == "text")
mapping[col.label] = { type: "string" };*/
}

});

return mapping;
},

I checked both functions and they do provide 'max' as aggregation and 'date string' for the type for dates in mapping. However, flexmonster does not listen to these explicit specifications.

Here is how I am defining flexview:

```
me.flexview = new Flexmonster({
container: divflex,
componentFolder: "https://cdn.flexmonster.com/",
//licenseKey: "Z71X-XAAB4Q-045773-4D350T",
toolbar: true,
customizeCell: (cell, data) => scil.Registration.FlexViewer.customizecellfunction(cell, data, ret.data),
report: {
dataSource: {
data: ret.data
},
mapping: scil.Registration.FlexViewer.getmapping(ret),
slice: {
columns: scil.Registration.FlexViewer.getcols(ret),
rows: scil.Registration.FlexViewer.getrows(ret),
measures: scil.Registration.FlexViewer.getmeasures(ret)
}
}
});
```

Thank you!

I tried it now like that:

me.flexview = new Flexmonster({
  container: divflex,
  componentFolder: "https://cdn.flexmonster.com/",
  toolbar: true,
  customizeCell: (cell, data) => scil.Registration.FlexViewer.customizecellfunction(cell, data, ret.data),
  report: {
  dataSource: {
    data: ret.data,
    mapping: scil.Registration.FlexViewer.getmapping(ret)
  },
  slice: {
    columns: scil.Registration.FlexViewer.getcols(ret),
    rows: scil.Registration.FlexViewer.getrows(ret),
    measures: scil.Registration.FlexViewer.getmeasures(ret)
  }
}
});

But the issue is still there. mapping object looks like:

{
  TonyTestProtocol/CustomDate: {type: 'date string'}
  TonyTestProtocol/IC50: {type: 'number'}
  TonyTestProtocol/R2: {type: 'number'}
  reg-date: {type: 'date string'}
  resultid: {type: 'id'}
}

'reg-date' stays as 'date string' but 'TonyTestProtocol/CustomDate' is switched to 'number' type. I have also tried manually specifying the mapping in place instead of using the function but the result stays the same.

The issue happens only when the first value in the data array for the key is null. If its a real date - everything works fine, but it looks as if mapping object is just ignored and Flexmonster implicitly determines types.

Found the issue: keys should be all lowercased. I made a mistake of not having same keys across mapping and uniqueName in other objects. Thank you! Its working fine now.