Skip to Content
4

Saving queries containing $[USER] in SAP B1 9.2

Nov 21, 2017 at 02:21 PM

53

avatar image
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

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers