# Apex Persistence Example Data ### Exercise: Compare persisted chart saved in the DB to current Apex LivePicker selection to determine what is missing and what needs to be accounted for in the new schema ___ ### [Example Chart](https://apps.livestories.com/charts/12c936a3-71f0-440c-9a3f-6a462a76f078) ![](https://i.imgur.com/I4EsVFw.png) ### Example Legacy Picker for Chart ![](https://i.imgur.com/zZeZdRs.png) ___ ### Example Legacy Persisted Data ``` { "version":"legacy", "chartSpecificOptions":null, "createdAt":"2019-08-28T21:13:23.984Z", "horizontalLabel":"Nation", "title":null, "id":"12c936a3-71f0-440c-9a3f-6a462a76f078", "isAnimated":false, "isShowingIndicatorName":true, "isShowingFooter":true, "teamId":"5a130d852cdd400017ad73b0", "timeMode":"time", "trashedDate":null, "type":"bar-chart", "updatedAt":null, "verticalLabel":"People", "observationsScopes":[ { "benchmarkIds":[ ], "focalLocaleId":"T:L:C(US)", "focalPeriodId":"T:P:Y(2013-2018,+5)", "freeDimensionIds":[ "T:L:C(US)" ], "freeLocaleFilterIds":[ "T:L:C(US)" ], "freeGenericFilterIds":[ ], "highlightTier1Ids":[ "T:L:C(US)" ], "highlightTier2Ids":[ ], "indicatorId":"I:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10", "isShowingMeasureError":false, "measureId":"M:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2)", "optionalFixedFilterIds":[ ], "requiredFixedGenericFilterIds":[ "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2)>T:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:LABOR_STATUS(LF_IN)" ], "requiredFixedLocaleFilterIds":[ ], "timeRangeStartId":"T:P:Y(2006-2011,+5)", "timeRangeEndId":"T:P:Y(2013-2018,+5)" } ] } ``` ___ ### Example Livepicker Data ``` { "type":"big-table", "presentationOptions":{ "axisLabels":{ "horizontalLabel":null, "verticalLabel":null }, "showFooter":false, "showIndicatorName":true, "showSingleHandleTimeSlider":false, "benchmarkIds":[ ], "tier1HighlightsIds":[ ], "tier2HighlightsIds":[ ], "colorSettings":{ "option":"category", "values":{ "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):LOCATION(T:NATION@1.0:C(US))":"#119EB9", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):DIMENSION_CIVILIAN_STATUS_8(T:LS@1.0:OTHER:ALL)":"#E41C62", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):DIMENSION_EMP_STATUS_9(T:LS@1.0:OTHER:ALL)":"#B0DFE8", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):TIME(T:US.GOV.US.DOC.CENSUS.ACS@2.0:5YEAR(2013,2017))":"#EDC949" } } }, "selectedInstanceIdsByMeasure":{ "M:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2)":[ "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):LOCATION(T:NATION@1.0:C(US))", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):DIMENSION_CIVILIAN_STATUS_8(T:LS@1.0:OTHER:ALL)", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):DIMENSION_EMP_STATUS_9(T:LS@1.0:OTHER:ALL)", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):TIME(T:US.GOV.US.DOC.CENSUS.ACS@2.0:5YEAR(2013,2017))", "D:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:X10(2):DIMENSION_LABOR_STATUS_7(T:US.GOV.US.DOC.CENSUS.ACS.DP03@1.2:LABOR_STATUS(LF_IN))" ] } } ```