I'm working with a migration over to PowerServer 2022 R3. The previous version they were running in was PB 2017 R3.
This datawindow in question was working just fine in the old version of PowerServer.
This datawindow has two visible columns. One column is a code column. Column name is option_code. The second column is that same option_code column that is used to place a drop down datawindow in. That dddw shows a value based on what that code is.
When we run the application in PB Classic, it works just fine.
However, when we run it in PowerServer, nothing retrieves.
We are successfully setting the transaction object. However, it just returns zero rows.
I'm wondering if something might be causing an issue with the use of a column more than once.
Or if the name of the column in the dddw matching the column name in the main datawindow could cause a problem.
Any thoughts would be appreciated.