Kentico Xperience 13 documentation and ASP.NET Core

Most documentation about running Xperience applications under ASP.NET Core can be found in a dedicated section: Developing Xperience applications using ASP.NET Core. The rest of the documentation still applies, but some code samples and scenarios might need slight modifications for Core projects.

Certain pages allow you to switch between Core and MVC 5 content using a selector located under the page heading.

All major differences between the MVC 5 and Core platforms are summarized in Migrating to ASP.NET Core.

×

Defining report parameters

Reports and their data can be filtered using parameters.

To create parameters for reports:

  1. Open the Reporting application.
  2. Select the report in the tree.
  3. Switch to the Parameters tab.
  4. Click New field.
  5. Define the properties of the parameter (using the field editor).
    Creating report parameters
  6. Click Save.
  7. Switch to the General tab.
  8. Add the parameter to the queries of the report objects (table, graph or value).
    • All parameters that you define can be used in the query using the @<parametername> expression (e.g., DocumentCreatedByUserID = @UserIDParameter).

For an example of using parameters in reports, see the Defining report parameters section of Example - simple report.

Context parameters

In your queries, you can use parameters that provide information about the current context when the report is viewed, such as current user, current site, etc.

  • @CMSContextCurrentUserID
  • @CMSContextCurrentUserName
  • @CMSContextCurrentUserDisplayName
  • @CMSContextCurrentSiteID
  • @CMSContextCurrentSiteName
  • @CMSContextCurrentSiteDisplayName
  • @CMSContextCurrentDomain
  • @CMSContextCurrentTime
  • @CMSContextCurrentNodeID
  • @CMSContextCurrentCulture
  • @CMSContextCurrentDocumentID
  • @CMSContextCurrentAliasPath
  • @CMSContextCurrentDocumentName

For example, if you want to display a list of all expired documents of the current website, you can use a query like this:

SELECT NodeAliasPath AS [Node path], DocumentCulture AS [Culture]
FROM View_CMS_Tree_Joined
WHERE DocumentPublishTo < @CMSContextCurrentTime AND NodeSiteID = @CMSContextCurrentSiteID

Displaying parameter values in the report using macros

If you need to display the parameter values in the report, you can place the following macro expression in the report text: {%parametername%}

For example:

List of pages expired on or before {%CMSContextCurrentTime%}

displays:

List of pages expired on or before 2/12/2013 12:06:49 PM

You can use this syntax for both custom report parameters and context parameters.


Was this page helpful?