Description
In many cases, you may want your query to know the current logged in user, what page the query is on, or other Confluence related metadata. This is easily done using the RUN and various Prevarious pre-defined variables. For SQL
For SQL for Confluence release 5.2 and later, a special substitution variable @user_id@ is available as well. The SQL macros will replace replaces this text with the user id ID of the currently logged in user or anonymous or anonymous, if the user is not logged in.