In the Review Definition Contents tab there is the ability to add a WHERE clause under Include application entitlements. When a sub-select is used (without table aliasing) using a column name with an underscore, that column name gets converted to camel case. It appears to work at first but after returning to edit the review, column_name becomes columnName.
It appears to save correctly after selecting the OK button:
But when you re-edit the review, the column name has been modified:
Defect ACM-78739 has been created for this issue.
Use an alias in the SQL SELECT for the table or view and then it will parse correctly without modifying the column name in the sub-select.
For example, if the SQL statement is as follows,
SELECT id FROM PV_APPLICATION_ENTITLEMENT WHERE alt_name LIKE '%Manage%'
Change to the example below:
SELECT ae.id FROM PV_APPLICATION_ENTITLEMENT ae WHERE ae.alt_name LIKE '%Manage%'