asked on October 26, 2016
Hi,
In flatview, data display is not compatible with other views(rounding off values if values contains ,comma). but, In Compact and Classic views data displays as expected. Attached screenshot for reference. Please look at "Steps" field data in JSON(but, having some of the values are seperated with comma and defined it as "number" in metadata). here is my JSON:
[{"account":{"type":"string","caption":"Account"},"steps":{"type":"number","caption":"Steps"},"beginbalance":{"type":"number","caption":"BeginBalance"}},{"account":"0001","beginbalance":174,"steps":"68.1,68.2,68.3"},{"account":"0002","beginbalance":1664,"steps":"135.1,136.2,137.2"},{"account":"0003","beginbalance":1190,"steps":"39,39.1,39.3"},{"account":"0004","beginbalance":174,"steps":"48.2,48.4"},{"account":"0005","beginbalance":1664,"steps":"51"},{"account":"0006","beginbalance":1190,"steps":"113"},{"account":"0007","beginbalance":174,"steps":"117"},{"account":"0008","beginbalance":1664,"steps":"133.10"},{"account":"0009","beginbalance":1190,"steps":"133.11"},{"account":"0002","beginbalance":174,"steps":"133.8"},{"account":"0003","beginbalance":1664,"steps":"52.0"},{"account":"0002","beginbalance":1190,"steps":"54.0"}]
Thanks & Regards, Sunilkumar.V
⋅ October 26, 2016
Kumar,
Honestly saying, it's not clear to me what the difference between flat and compact view.
Could you please provide any sample? Regards,
Dmytro
⋅ October 26, 2016
Kumar,
Thank you for additional information.
It happens because in the flat "Steps" is always a number and formatting is applied. But in compact/classic view member's caption is an original "string" value.
I'm not sure if it meets your needs but you can use "string" type to see same values in all views.
⋅ October 27, 2016
Hi,
Thanks for the response.
yes, you are right. If we use "string" type it won't get sorted. Actually, we are using "Steps" column as for sequence tracking so, it should be identical in all views.
Any suggestion by applying any property can we display same order in flatview like as classic view?
Thanks & Regards,
Sunilkumar.V
⋅ October 27, 2016
Hello Kumar,
We have looked through your data carefully and there are some things which need to be specified. First thing is that you are passing several numbers as a string for Steps which has number type. In this situation, the component will parse only the first number from the string and skip all the rest. That is why, if you want to see the data like "39,39.1,39.3" in flat and classic view, please set string type for Steps, but if you want the component to aggregate it, then the type should be a number. Could you please share your ideas how it should work for your case?
Best regards,
Dmytro.
⋅ October 31, 2016
Hello Kumar,
The sequence of numbers can't be treated as a number and a string at the same time. That is why the behavior may be inconsistent with different views. We recommend you to modify the data structure to fit your needs.
Best regards,
Dmytro.
