Skip to Content
avatar image
Former Member

Saving queries containing $[USER] in SAP B1 9.2

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers