Menu
Reply To Topic Topic: Tokens For use with the Reports Module
:
Posted By Deleted User on 7/12/2012 12:44 AM
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)
Username: 
Security Code:
CAPTCHA image
Enter the code shown above in the box below.
Subject:
RE: Tokens For use with the Reports Module
Message:
Smilies

Submit

Cancel
Subscribe:
Topic Review