getting user name on a query

[Former Member]

Hi,

I was trying to get the user that is logged on in a query but I can't. I tried using $user, but this only works in a formatted search, in a form.

What I want to do is run a query where the user can see its active documents, based on the logged on user.

Is there any way to use $user in such a query?

[AlexGrebennikov · Accepted solution]

Sergi, here is how to...:

1. save a query SELECT $[USER]

2. run it from Queries Manager -> you'll get error

3. go to Tools -> Queries -> User Queries -> run it.. wwau! it works!

HTH

[Former Member · Accepted solution]

Great! Thanks!

Anyway, isn't there any easier way for our users?

Thanks again!

[AlexGrebennikov · Accepted solution]

Sorry, but if we are talking about non-SDK approach then there are only 2 solutions:

- run the query as FS via Shift-F2 on the form

- run the query from User Queries menu