Skip to end of banner
Go to start of banner

How to use Confluence metadata in SQL queries

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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 Self-Service Reports for Confluence and various Pre-defined variables. For SQL for Confluence release 5.2 and later, a special substitution variable @user_id@ is available as well. The SQL macros will replace this text with the user id of the currently logged in user or anonymous if the user is not logged in.

  • No labels

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.

Error formatting macro: appfire-confluence-analytics: java.lang.NullPointerException: Cannot invoke "com.atlassian.confluence.xhtml.api.MacroDefinition.getMacroId()" because "macroDefinition" is null