Seeing some weird behavior with v10 (haven't tried test in v9)... just tossing it out in case anyone else is experiencing the same - thus justifying a bug report.
I've got a grid/detail page based on a 6-table join, a smattering of aliases and calculated fields, and 3 clauses for my where filter, all against a MySQL DB.
My grid displays just fine in preview, live preview, and published mode with all data present and accounted for.
BUT - when I click on the Hyperlink (primary key) to trigger the detail, the selected grid row data is updated/replaced with a copy of the data in the very first visible row - but only noncalculated columns. Click from one row to the next, and eventually all grid rows are identical to the first visible row (except for calculated columns, which remain as initially and correctly displayed). There is, however, no update to the underlying table data - just the displayed data. The detail view also does not display the proper data, rather, it displays the data from the first grid row - always.
This all occurs in the web/grid design page - no A5 page involved - just the bare grid design, preview, and Live Preview. No customization, javascript, Advanced, conditionals, layout options, miscellaneous or other modifying code.
Appears to be triggered by the complexity of the underlying query, as a simplified query behaves as expected.
I've got a grid/detail page based on a 6-table join, a smattering of aliases and calculated fields, and 3 clauses for my where filter, all against a MySQL DB.
My grid displays just fine in preview, live preview, and published mode with all data present and accounted for.
BUT - when I click on the Hyperlink (primary key) to trigger the detail, the selected grid row data is updated/replaced with a copy of the data in the very first visible row - but only noncalculated columns. Click from one row to the next, and eventually all grid rows are identical to the first visible row (except for calculated columns, which remain as initially and correctly displayed). There is, however, no update to the underlying table data - just the displayed data. The detail view also does not display the proper data, rather, it displays the data from the first grid row - always.
This all occurs in the web/grid design page - no A5 page involved - just the bare grid design, preview, and Live Preview. No customization, javascript, Advanced, conditionals, layout options, miscellaneous or other modifying code.
Appears to be triggered by the complexity of the underlying query, as a simplified query behaves as expected.