I have an issue when opening queries from the query manager that contain the $[USER] placeholder.
When opened, $[USER] is always replaced by the actual user id. When then saving the query again, the user's id is saved instead of the $[USER] placeholder. Beforehand the $[USER] tag was saved back.
So currently saving:
SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = $[USER]
Leads to the query
SELECT T0.U_NAME FROM OUSR T0 WHERE INTERNAL_K = 6
being saved because the $[USER] is replaced automatically in the query manager.
We have this since upgrading from 9.0 to 9.2 PL8. Does anyone know how to work around this or if this is fixed in a later release?