Tokens For use with the Reports Module
Last Post 12 Jul 2012 12:44 AM by Mark Buelsing. 0 Replies.
Printer Friendly
PrevPrev NextNext
Author Messages
Mark BuelsingUser is Offline
New Member
New Member

12 Jul 2012 12:44 AM Quote Reply  
This information has been copied here from other forum entries on other sites to sumarize it in one place.

The Reports module does support passing the PortalID, TabID, ModuleID and UserID to the query by using the following SQL Parameters: @PortalID, @TabID, @ModuleID, @UserID. So if any of those four parameters are used in the Query, they will automatically be replaced with the current Portal, Tab, Module, or User ID (respectively). This is done in a secure way, to avoid SQL Injection attacks. For example, if you want to retrieve information about the current user, you can use this query:

SELECT * FROM dnn_Users WHERE UserID = @UserID

Note that you must disable caching, otherwise one User may be able to see another User's results.

Token Description
[Portal:Currency] Currency String
[Portal:Description] Portal Description
[Portal:Email] Portal Admin Email
[Portal:FooterText] Portal Copyright Text
[Portal:HomeDirectory] Portal (relative) Path of Home Directory
[Portal:LogoFile] Portal Path to Logo file
[Portal:PortalName] Portal Name
[Portal:PortalAlias] Portal URL
[Portal:TimeZoneOffset] Difference in minutes between Portal default time and UTC

[User:DisplayName] User’s Display Name
[User:Email] User’s Email Address
[User:FirstName] User’s First Name
[User:FullName] [deprecated]
[User:LastName] User’s Last Name
[User:Username] User’s Login User Name

[Membership:Approved] Is User Approved?
[Membership:CreatedDate] User Signup Date
[Membership:IsOnline] Is User Currently Online?

[Profile:Property] Use any default or custom Property defined for user profiles as listed in Profile Property Definition section of Manage User Accounts. Please use non-localized Property titles only.

[Tab:Description] Page Description Text for Search Engine
[Tab:EndDate] Page Display Until Date
[Tab:FullUrl] Page Full URL
[Tab:IconFile] Page Relative Path to Icon file
[Tab:KeyWords] Page Keywords for Search Engine
[Tab:PageHeadText] Page Header Text
[Tab:StartDate] Page Display from Date
[Tab:TabName] Page Name
[Tab:TabPath] Page Relative Path
[Tab:Title] Page Title (Window Title)
[Tab:URL] Page URL

[Module:Description] Module Definition Description
[Module:EndDate] Module Display Until Date
[Module:Footer] Module Footer Text
[Module:FriendlyName] Module Definition Name
[Module:Header] Module Header Text
[Module:HelpUrl] Module Help URL
[Module:IconFile] Module Path to Icon File
[Module:ModuleTitle] Module Title
[Module:PaneName] Module Name of Pane where UDT resides
[Module:StartDate] Module Display from Date

[DateTime:Now] Current Date and Time
[Ticks:Now] CPU Tick Count for Current Second
[Ticks:Today] CPU Tick Count since Midnight
[Ticks:TicksPerDay] CPU Ticks per Day (for calculations)

Quick Reply
Security Code:
Enter the code shown above in the box below.


Powered by Active Forums

Welcome Photographers!

We would like to make connections with amateur photographers who would like to see their beautiful images used on the Internet.

If you are interested, leave your name and email and we'll contact you when a particular photo is needed for one of our website projects. If you have a photo that fits the need, then send it to us. At the very least, you will get credit for the photo. Some projects will pay for your photo. It is an opportunity to get your work published!

Thank you

Mark Buelsing