# Page refresh not updating page layout **URL:** \ **Category:** Dash Python\ **Created:** [September 10, 2021, 11:53pm UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516 "2021-09-10T23:53:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![johnwhite10](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@johnwhite10](https://community.plotly.com/u/johnwhite10)\ **Post date:** [September 10, 2021, 11:53pm UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/1 "2021-09-10T23:53:27Z")
Hello all, I am struggling with the idea of updating my dataTables with new rows on page refresh. I also have a dropdown to filter rows of interest according to a column value. I learned how to do that here: [https://dash.plotly.com/live-updates](https://dash.plotly.com/live-updates). However, the datatables don’t update after wrapping `layout`rendering in a function. I have explored other routes like `dcc.Interval` with `dcc.Store` in order to update dataTables, but all hit a dead end since multiple same Outputs aren’t allowed in callbacks (table1 and table2). So I figured a layout refresh would be the most efficient way to go. Live datatable updates aren’t needed in my case, so a page refresh and retriggering `get_data` would be perfect. Any ideas that I may be missing? ```auto def get_data(): conn_indicator = psycopg2.connect( # creds ) # Stats Tab sql1 = "some query" metadata_df = pd.read_sql(sql1, con=conn_indicator) sql2 = "some query" df = pd.read_sql(sql2, con=conn_indicator) return metadata_df, df # Initial load metadata_df, strat_perf_df, strat_trade_df, positions_df, positions_perf_df = get_data() def serve_layout(): metadata_df, df = get_data() return html.Div( [ dcc.Tabs( [ dcc.Tab( label="Stats", children=[ html.H5("Metadata Table"), dash_table.DataTable( id="table1", columns=[{"name": i, "id": i} for i in metadata_df.columns], data=metadata_df.to_dict("records"), ), html.H5("Df Stats"), dash_table.DataTable( id="table2", columns=[{"name": i, "id": i} for i in df.columns], data=df.to_dict("records"), ), ], ), dcc.Tab( label="Breakdown", children=[ html.P("Breakdown Tab"), ], ), ] ), html.P("Select the Run ID"), dcc.Dropdown( id="run-id-dropdown", options=[{"label": i, "value": i} for i in df["run_id"].tolist()] ), ] ) layout = serve_layout() # Updates the datatables under the Stats tab through Run ID @app.callback( [Output("table1", "data"), Output("table2", "data")], [Input("run-id-dropdown", "value")], ) def update_stats(value): if dash.callback_context.triggered[0]["prop_id"] == ".": return dash.no_update table1_df = metadata_df.loc[metadata_df["run_id"] == value] table2_df = df.loc[df["run_id"] == value] return table1_df.to_dict("records"), table2_df.to_dict("records") ``` ---
**Author:** ![AnnMarieW](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@AnnMarieW](https://community.plotly.com/u/AnnMarieW)\ **Post date:** [September 11, 2021, 12:57am UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/2 "2021-09-11T00:57:01Z")
Hey @johnwhite10 welcome to the Dash community 🙂 I’m not sure if this is causing the problem, but try changing: ```auto layout = serve_layout() ``` to ```auto layout = serve_layout ``` This is from the [Live Updates | Dash for Python Documentation | Plotly](https://dash.plotly.com/live-updates) page you mentioned in your post: ![image](https://us1.discourse-cdn.com/flex024/uploads/plot/original/3X/0/a/0a00ca2a6b530266614e710aeafb1352c021b836.png) ---
**Author:** ![johnwhite10](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@johnwhite10](https://community.plotly.com/u/johnwhite10)\ **Post date:** [September 11, 2021, 1:01am UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/3 "2021-09-11T01:01:10Z")
Thank you 🙂 I have tried that already but I am met with this error: ```auto Callback error updating page-content.children dash.exceptions.InvalidCallbackReturnValue: The callback for `` returned a value having type `function` which is not JSON serializable. The value in question is either the only value returned, or is in the top level of the returned list, and has string representation `` In general, Dash properties can only be dash components, strings, dictionaries, numbers, None, or lists of those. ``` ---
**Author:** ![AnnMarieW](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@AnnMarieW](https://community.plotly.com/u/AnnMarieW)\ **Post date:** [September 11, 2021, 1:08am UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/4 "2021-09-11T01:08:06Z")
hmm, maybe ```auto app.layout = serve_layout ``` ---
**Author:** ![johnwhite10](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@johnwhite10](https://community.plotly.com/u/johnwhite10)\ **Post date:** [September 11, 2021, 1:21am UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/5 "2021-09-11T01:21:11Z")
Hm, the `app.layout` doesn’t work since this is a child page rendered from: ```auto @app.callback(Output("page-content", "children"), [Input("url", "pathname")]) def display_page(pathname): if pathname == "/page1": return page1.layout elif pathname == "/page2": return page2.layout else: return index_page ``` Error: ```auto AttributeError: module 'apps.page1' has no attribute 'layout' dash.exceptions.InvalidCallbackReturnValue: The callback for `` returned a value having type `function` which is not JSON serializable. The value in question is either the only value returned, or is in the top level of the returned list, and has string representation `` In general, Dash properties can only be dash components, strings, dictionaries, numbers, None, or lists of those. ``` ---
**Author:** ![johnwhite10](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@johnwhite10](https://community.plotly.com/u/johnwhite10)\ **Post date:** [September 11, 2021, 9:56am UTC](https://community.plotly.com/t/page-refresh-not-updating-page-layout/56516/6 "2021-09-11T09:56:14Z")
Solved! Ended up using dash\_extensions: [https://github.com/thedirtyfew/dash-extensions](https://github.com/thedirtyfew/dash-extensions) and [https://pypi.org/project/dash-extensions/](https://pypi.org/project/dash-extensions/) It seems like their `DashProxy` instance has built in updates on page reload!