Saving queries containing $[USER] in SAP B1 9.2

[Former Member]

Hi all,

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?

Many Thanks,

Alex

[Johan_Hakkesteegt · Accepted solution]

Hi,

This really is a none issue. Any saved query should not be changed multiple times a day by any and all users. If that happens, you should look into a different solution.

Only a user who knows what they are doing, i.e. a user who knows about the $[USER] dynamic parameter, should be allowed to change a saved query. This user should also know to change the 6 back to $[USER], in the hopefully very rare occasion that they need to make a change to the query. If it is absolutely imperitive that a "normal" user change the query, you should teach them about the $[USER] dynamic parameter.

Regards,

Johan