Reference - Macro methods

Macro expressions allow you to use a large variety of methods. The following categories list the methods according to the type of provided functionality:

Data manipulation
Data conversion
Text manipulation
Advanced text processing
Date and time modification
Mathematical operations
E-commerce
User membership and permissions
Transformations

Keep in mind that the recommended macro syntax is to use infix notation for the first parameter of methods.

For example: {% “word”.ToUpper() %} instead of {% ToUpper(“word”) %}

Data manipulation

Method	Return type	Parameters	Description
GetValue	object	ISimpleDataContainer container string column object defaultValue	Gets the value of the specified data column of an object that implements the ISimpleDataContainer interface. You can specify a default value used if the requested data is null.
GetProperty	object	IHierarchicalObject object string property object defaultValue	Gets the value of the specified property of an IHierarchicalObject object. You can specify a default value used if the requested property is null.
GetItem	object	IEnumerable collection int index object defaultValue	Gets the object at the specified index of a collection. You can specify a default value used if the requested object is null.
OrderBy	AbstractObjectCollection	AbstractObjectCollection collection string orderBy	Returns the collection of objects, with the order defined by the specified SQL ORDER BY clause. If the macro is saved by a user without the Administrator privilege level, the method only allows the following SQL syntax: one or more column names (separated by commas) the ASC and DESC keywords
Where	AbstractObjectCollection	AbstractObjectCollection collection string where	Filters a collection of objects according to the specified SQL Where condition. If the macro is saved by a user without the Administrator privilege level, the method only allows the following SQL syntax in the where condition: column names, values and basic operators: =, !=, >, < AND & OR operators, parentheses column BETWEEN value AND value column LIKE value column IN (values) column IS NULL NOT keyword for the above expressions (NOT BETWEEN, NOT LIKE, NOT IN, IS NOT NULL) Other expressions and SQL functions are not supported.
TopN	AbstractObjectCollection	AbstractObjectCollection collection int topn	Returns only the specified number of objects in the collection.
Columns	AbstractObjectCollection	AbstractObjectCollection collection string columns	Returns the collection of objects containing only the specified data columns. If the macro is saved by a user without the Administrator privilege level, the method only allows the following SQL syntax: one or more column names (separated by commas) SQL aliases for columns defined using the AS keyword (must be upper case)
Filter	InfoObjectCollection	IEnumerable collection string condition	Filters a collection of objects according to the specified macro condition.
ClassNames	TreeNodeCollection	TreeNodeCollection collection string classNames	Filters a TreeNodeCollection of pages according to the specified page types. The second parameter must contain a list of allowed page type code names, separated by semicolons.
InList	bool	object object IEnumerable collection	Returns a true value if the object exists within the specified collection.
All	bool	IEnumerable collection string condition	Returns a true value if all of the objects in the collection match the given condition. Specify the condition as a macro expression.
Any	bool	IEnumerable collection string condition	Returns a true value if at least one object in the collection matches the given condition. Specify the condition as a macro expression. If you leave out the condition parameter, the method returns true if the collection contains at least one object. Throws an exception if the collection is null.
Exists	bool	IEnumerable collection string condition	Returns a true value if at least one object in the collection matches the given condition. Specify the condition as a macro expression. If you leave out the condition parameter, the method returns true if the collection contains at least one object. Returns false if the collection is null.
RandomSelection	IList	IEnumerable items int numberOfItems	Returns randomly selected objects from the collection. You can optionally specify the number of items.
SelectInterval	IList	IEnumerable items int lowerBound int upperBound	Returns the specified interval of objects from the collection.
Cache	object	object expression int cacheMinutes bool condition string cacheItemName string cacheItemNameParts CMSCacheDependency cacheDependency	Evaluates the specified macro expressions and stores the result in the server-side application cache. The system only evaluates the expression if the result is not found in the cache. See also: Caching the results of macros
GetCacheDependency	CMSCacheDependency	string[] dependencies	Returns a CMSCacheDependency object based on the specified dummy cache keys (one or more string parameters). See also: Setting cache dependencies Caching the results of macros

> Back to the list of macro method categories

Data conversion

Method	Return type	Parameters	Description
ToString	string	object value string defaultValue string culture string format	Converts an object to a string. Returns the optional default value if the conversion is not possible. You can also specify the culture context and a formatting string used for the conversion.
ToInt	int	object value int defaultValue	Converts an object to an integer number. Returns the optional default value if the conversion is not possible.
ToBool	bool	object value bool defaultValue	Converts an object to a boolean value. Returns the optional default value if the conversion is not possible.
ToDouble	double	object value double defaultValue string culture	Converts an object to a double number. Returns the optional default value if the conversion is not possible. You can also specify a culture code to determine the formatting of the decimal number.
ToGuid	guid	object value Guid defaultValue	Converts an object to a GUID value. Returns the optional default value if the conversion is not possible.
ToDateTime	DateTime	object value DateTime defaultValue string culture	Converts an object to a DateTime value. Returns the optional default value if the conversion is not possible. You can also specify a culture code to determine the date format.
FromOADate	DateTime	double value	Converts a double representation of a date and time value (OLE Automation Date) to a DateTime object.
ToTimeSpan	TimeSpan	object value	Converts an object to a TimeSpan value. Returns null if the conversion is not possible.
ToBaseInfo	BaseInfo	object value BaseInfo defaultValue	Converts an object to a BaseInfo — the general type for Kentico system objects and pages. Returns the optional default value if the conversion is not possible.
List	ArrayList	object items	Converts a list of objects to an ArrayList.

> Back to the list of macro method categories

Text manipulation

Method	Return type	Parameters	Description
Contains	bool	string text string search	Returns a true value if the string specified by the second parameter occurs within the first string.
EndsWith	bool	string text string findText	Indicates whether the string specified by the second parameter occurs at the end of the first string.
Format	string	string value string format	Replaces all formatting expressions in a string using the text equivalents specified in the second parameter. Based on composite formatting.
FormatNotEmpty	string	string value string format string emptyResult	If the first parameter is not empty or null, replaces all formatting expressions in the string using the text equivalents specified in the second parameter. Returns the optional third parameter if the value is null or empty. Based on composite formatting.
GetMatch	string	string text string regex	Matches the string value to the specified regular expression and returns the match.
IndexOf	int	string text string searchFor	Returns the index of the first occurrence of the second string within the first string.
LastIndexOf	int	string text string searchFor	Returns the index of the last occurrence of the second string within the first string.
LimitLength	string	string text int length string padString bool wholeWords	Limits the length of the string to the specified number of characters. The padString parameter allows you to set a string that the method appends to the end of the limited result. The length of the parameter is included in the maximum length. If you set the wholeWords parameter to true, the method preserves the last word in the string.
LoremIpsum	string	int length	Generates lorem Ipsum text. You can specify the number of generated characters (1000 by default).
Matches	bool	string text string regex	Indicates whether the string matches the specified regular expression.
NotContains	bool	string text string search	Returns a true value if the string specified by the second parameter does NOT occur within the first string.
PadLeft	string	string text int length string paddingString	Adds leading characters to the string until the total length matches the second parameter. By default, the method uses spaces as the padding character, but you can optionally specify a different character.
PadRight	string	string text int length string paddingString	Adds trailing characters to the string until the total length matches the second parameter. By default, the method uses spaces as the padding character, but you can optionally specify a different character.
RegexReplace	string	string text string regex string replacement	Replaces strings that match the regular expression pattern within the first string using the replacement string.
Remove	string	string text int position int length	Deletes characters from the string, starting at the specified index. By default, the method removes all remaining characters from the specified position. You can optionally specify the number of characters to be removed.
Replace	string	string text string replace string replacement	Replaces all occurrences of the second string within the first string using the replacement string.
Split	string[]	string text string delimiters bool removeEmpty	Separates the string into an array of substrings according to the specified delimiting characters. If the optional third parameter is true, the method removes empty substrings from the result.
StartsWith	bool	string text string findText	Indicates whether the string specified by the second parameter occurs at the start of the first string.
Substring	string	string text int index int length	Returns a substring starting at the specified index. By default, the method returns all remaining characters from the specified index. You can optionally specify the number of characters to be returned.
ToLower	string	string text	Converts the entire string to lower case.
ToUpper	string	string text	Converts the entire string to upper case.
Trim	string	string text string charsToTrim	Removes all leading and trailing occurrences of characters from the string. By default, the method trims white space characters, but you can optionally specify a different set of characters (as a string).
TrimEnd	string	string text string charsToTrim	Removes all trailing occurrences of characters from the string. By default, the method trims white space characters, but you can optionally specify a different set of characters (as a string).
TrimStart	string	string text string charsToTrim	Removes all leading occurrences of characters from the string. By default, the method trims white space characters, but you can optionally specify a different set of characters (as a string).

Tips: To perform lexicographical comparison of strings, use the basic comparison operators (==, <, >, <=, >=). Add macro parameters to specify case sensitivity and the culture context of text operations.

> Back to the list of macro method categories

Advanced text processing

Method	Return type	Parameters	Description
GetResourceString	string	string resourceStringKey string culture	Translates the specified resource (localization) string. By default, the target language of the localization depends on the current culture. You can specify the target language using the optional parameter.
JSEscape	string	string text	Escapes the string for safe usage in JavaScript. Adds the \ escape character before special characters used by JavaScript (quotes, etc.).
Localize	string	string inputText string culture	Resolves localization expressions within the specified text. By default, the target language of the localization depends on the current culture. You can specify the target language using the optional parameter.
MapPath	string	string path	Returns the physical file path that matches the specified virtual path.
ResolveBBCode	string	string text	Resolves BBCode tags in the specified text, for example: {% ResolveBBCode(“[quote]Sample text[/quote]”) %}.
ResolveMacroExpressions	string	string expression	Resolves the specified macro expression (without the {% %} parentheses).
ResolveMacros	string	string inputText	Resolves all macros within the specified text.
ResolveUrl	string	string url	Converts relative URLs starting with ~/ to relative URLs containing the current application path (so they can be resolved by clients). Absolute URLs remain unchanged.
StripTags	string	string text	Removes all HTML tags from the specified text.
SQLEscape	string	string text	Escapes the string for safe usage in SQL commands (to avoid SQL injection).
UnresolveUrl	string	string url	Converts relative URLs containing the application path to relative URLs starting with ~/. Absolute URLs remain unchanged.
UrlEncode	string	string url	Applies URL encoding to the specified string.

> Back to the list of macro method categories

Date and time modification

Method	Return type	Parameters	Description
AddMilliseconds	DateTime	DateTime datetime int milliseconds	Adds the specified number of milliseconds to a DateTime value.
AddSeconds	DateTime	DateTime datetime int seconds	Adds the specified number of seconds to a DateTime value.
AddMinutes	DateTime	DateTime datetime int minutes	Adds the specified number of minutes to a DateTime value.
AddHours	DateTime	DateTime datetime int hours	Adds the specified number of hours to a DateTime value.
AddDays	DateTime	DateTime datetime int days	Adds the specified number of days to a DateTime value.
AddWeeks	DateTime	DateTime datetime int weeks	Adds the specified number of weeks to a DateTime value.
AddMonths	DateTime	DateTime datetime int months	Adds the specified number of months to a DateTime value.
AddYears	DateTime	DateTime datetime int years	Adds the specified number of years to a DateTime value.
ToShortDateString	string	DateTime datetime	Converts the value of the DateTime parameter to an equivalent short date string representation.
ToShortTimeString	string	DateTime datetime	Converts the value of the DateTime parameter to an equivalent short time string representation.

> Back to the list of macro method categories

Mathematical operations

The macro autocomplete help only shows the mathematical methods as members of the Math namespace, for example {% Math.Abs(-2) %}. However, the system resolves the methods even without the namespace.

Method	Return type	Parameters	Description
Abs	double	double number	The absolute value of the specified number.
Acos	double	double number	The angle whose cosine is the specified number.
Asin	double	double number	The angle whose sine is the specified number.
Atan	double	double number	The angle whose tangent is the specified number.
Average	double	InfoObjectCollection collection string columnName	The average of all numbers in the specified data column of the objects in the collection.
Ceiling	double	double number	The smallest whole number greater than or equal to the specified number.
Cos	double	double number	The cosine of the specified angle.
Cosh	double	double number	The hyperbolic cosine of the specified angle.
Exp	double	double number	e raised to the specified power.
Floor	double	double number	The largest whole number lesser than or equal to the specified number.
GetRandomInt	int	int minValue int maxValue int seed	Generates a random positive integer. You can use the optional parameters to specify the range of possible numbers, and the seed number for the generator.
GetRandomDouble	double	int minValue int maxValue int seed	Generates a random positive decimal number. You can use the optional parameters to specify the range of possible numbers, and the seed number for the generator.
IsOdd	bool	int number	Returns a true value if the specified number is odd.
IsEven	bool	int number	Returns a true value if the specified number is even.
Log	double	double number	The base e logarithm of a specified number.
Log10	double	double number	The base 10 logarithm of a specified number.
Max	double	double parameters	The maximum from the given list of numbers.
Maximum	double	InfoObjectCollection collection string columnName	The maximum of all numbers in the specified data column of the objects in the collection.
Min	double	double parameters	The minimum from the given list of numbers.
Minimum		InfoObjectCollection collection string columnName	The minimum of all numbers in the specified data column of the objects in the collection.
Modulo	int	int left int right	The modulo of two integer numbers.
Pow	double	double base double exp	The number raised to the specified power.
Percent	double	double percent	Multiples the specified number by 0.01.
Round	double	double number int digits string mode	The number nearest to the specified value. The optional second parameter sets the number of fractional digits in the rounded value. You can use the third parameter to set the rounding mode for numbers half-way between two other numbers. Supported variants are: AwayFromZero - rounds to the nearest number away from zero ToEven - rounds toward the nearest even number
Sign	double	double number	Returns a value indicating the sign of a number: -1 (the number is less than zero) 0 (the number is zero) 1 (the number is greater than zero)
Sin	double	double number	The sine of the specified angle.
Sinh	double	double number	The hyperbolic sine of the specified angle.
Sqrt	double	double number	The square root of a specified number.
Sum	double	InfoObjectCollection collection string columnName	The sum of all numbers in the specified data column of the objects in the collection.
Tan	double	double number	The tangent of the specified angle.
Tanh	double	double number	The hyperbolic tangent of the specified angle.

> Back to the list of macro method categories

E-commerce

SKU properties

Method	Return type	Parameters	Description
GetPrice	string	object (SKUInfo) sku object (CurrencyInfo) currency	Returns the price of the specified product (object sku) in the specified currency (object currency).
GetSKUPriceSaving	string	object (int) SKUID	Returns the amount of saved money in the current user’s shopping cart currency based on the difference between the final selling price and the retail price of the SKU specified with the ID (object SKUID). If the selling price is bigger than the retail price, 0 is returned. If product prices are displayed with discounts on the live site, the amount is calculated with discounts. If product prices are displayed with taxes on the live site, the amount is calculated also with taxes. The price from the SKUPrice column is used as the final selling price; the price from the SKURetailPrice column is used as the retail price.
GetSKUOriginalPrice	string	object (int) SKUID	Depending on what is the bigger number, returns the price from the SKURetailPrice column or the price before applying discounts of the SKU specified with the ID (object SKUID) in the current user’s shopping cart currency. If both prices equals the price from the SKUPrice column, 0 is returned. If product prices are displayed with taxes on the live site, the price is returned with taxes.
IsOptionUsedInVariants	bool	int skuID	Returns true if the product option with the specified ID (int skuID) is used in any existing product variant.

Method	Return type	Parameters	Description
GetManufacturer	object	int id string column	Returns an object from the specified column (string column) of the manufacturer with the specified ID (int id).
GetDepartment	object	int id string column	Returns an object from the specified column (string column) of the department with the specified ID (int id**).
GetSupplier	object	int id string column	Returns an object from the specified column (string column) of the supplier with the specified ID (int id**).
GetInternalStatus	object	int id string column	Returns an object from the specified column (string column) of the internal status with the specified ID (int id**).
GetPublicStatusName	string	object (int) statusId	Returns the value from the SKUPublicStatusID column of the public status with the specified ID (object statusId).
GetPublicStatus	object	int id string column	Returns an object from the specified column (string column) of the public status with the specified ID (int id**).
GetMainSiteCurrency	CurrencyInfo	int siteID	Returns the currency used on the site with the specified ID (int siteID).
GetShoppingCartItemsCount	int		Returns the number of products in the current shopping cart.
GetCouponsMessage	string	object (DiscountInfo) Discount	Returns an info message about coupons and their redemption of the specified discount (object Discount).
GetMultiBuyCouponsMessage	string	object (MultiBuyDiscountInfo) MultiBuyDiscount	Returns an info message about coupons and their redemption of the specified Buy X Get Y discount (object MultiBuyDiscount).
CheckCustomerSiteID	string	object (CustomerInfo) Customer	Returns true if the specified customer (object Customer) is anonymous on the current site or has login credentials to the current site.
GetMassUnit	string		Returns the mass unit of the Kentico instance.
FormatPrice	string	double price bool round	Returns the specified price (double price) formatted according to the current currency settings. Set whether you also want to round the price (bool round).

URLs

Method	Return type	Parameters	Description
GetAddToShoppingCartLink	string	object (int) productId object (bool) enabled	Returns the URL for adding the specified product (object productId) to the current user’s shopping cart. You can specify whether the product is enabled (object enabled). The image in the link is located in “~/CMSModules/CMS_Ecommerce/addorder.png”.
GetAddToWishListLink	string	object (int) productId	Returns the URL for adding the specified product (object productId) to the current user’s wishlist. The image in the link is located in “~/CMSModules/CMS_Ecommerce/addtowishlist.png”.
GetRemoveFromWishListLink	string	object (string) productId	Returns the URL for removing the specified product (object productId) from the current user’s wishlist.
ShoppingCartURL	string	string siteName	Returns the URL of the current user’s shopping cart on the specified site (string siteName).
WishlistURL	string	string siteName	Returns the URL of the current user’s wishlist on the specified site (string siteName).
GetProductUrl	string	object (int, string) skuId	Returns the URL of the product specified by the identifier (object SKUID), which is the primary key.
GetProductUrlForFeed	string	object (Guid) skuGUID object (string) skuName object (string) siteName	Returns the URL of the specified product (object skuGUID) with the specified name (object skuName) with the feed query string parameter in the URL for the feed on the specified site (object siteName).
GetEproductUrl	string	Guid fileToken string fileName int siteId	Returns the URL for downloading an e-product specified with a unique download URL (Guid fileToken), a file name (string fileName), and an ID of the site on which the order with the e-product took place (int siteId).
GetProductUrlByGUID	string	object (Guid) skuGuid object (string) skuName object (string) siteName	Returns the user-friendly URL of the product specified by the GUID (object skuGuid) and name (object skuName) of the product. You can specify the site name of the product’s site (object siteName).
GetProductImage	string	object (string) imageUrl object (string) alt object (int) maxSideSize object (int) width object (int) height	Returns the complete HTML code of the URL of the specified product image (object imageURL) on the current site with the alternative text (object alt). You can specify the maximum width (object maxSideSize), or the required width (object width) and height (object height).

> Back to the list of macro method categories

User membership and permissions

Method	Return type	Parameters	Description
CheckPrivilegeLevel	bool	object user (UserInfo) UserPrivilegeLevelEnum privilegeLevel	Checks the user’s privilege level. Returns a true value if the user’s privilege level matches the required UserPrivilegeLevelEnum value or is higher. You can check the following levels: {% CurrentUser.CheckPrivilegeLevel(UserPrivilegeLevelEnum.Editor) %} {% CurrentUser.CheckPrivilegeLevel(UserPrivilegeLevelEnum.Admin) %} {% CurrentUser.CheckPrivilegeLevel(UserPrivilegeLevelEnum.GlobalAdmin) %}
GetFormattedUserName	string	object user (UserInfo) bool isLiveSite	Returns the formatted username of the specified user object. The default format is <full name> (<nickname>) if the user has a nickname, otherwise <full name> (<username>). The isLiveSite parameter determines whether the macro displays the username on the live website.
HasAnyMembership	bool	object user (UserInfo)	Checks whether the user belongs to any membership in the system.
HasMembership	bool	object user (UserInfo) string userMemberships bool allMemberships	Checks if a user belongs to the specified memberships. Enter the code names of memberships through the userMemberships parameter. When checking multiple memberships, use semicolons (;) to separate the code names. If the allMemberships parameter is true, the user must belong to all specified memberships for the check to succeed. To check whether the user belongs to a membership on a global level, add the period character (.) prefix before the membership code name.
IsAuthorizedPerResource	bool	object user (UserInfo) string resource string permission	Evaluates whether a user has a specific permission for a resource (module). Use code names to identify the resource and permission.
IsAuthorizedPerUIElement	bool	object user (UserInfo) string resource string elementName	Evaluates whether a user is allowed to access a specific UI element of a resource (module). Use code names to identify the resource and element.
IsInGroup	bool	object user (UserInfo) string userGroup	Checks if a user belongs to a group (community or workgroup).
IsInRole	bool	object user (UserInfo) string userRole bool allRoles	Checks if a user belongs to the specified roles. Enter the code names of roles through the userRole parameter. When checking multiple roles, use semicolons (;) to separate the code names. If the allRoles parameter is true, the user must belong to all specified roles for the check to succeed. To check whether the user belongs to a role on a global level, add the period character (.) prefix before the role code name.

> Back to the list of macro method categories

Transformations

ApplyTransformation

string

IEnumerable collection
string transformationName
string contentBeforeTransformationName
string contentAfterTransformationName

Applies Text / XML transformations to a collection of items.

Transform

string

IEnumerable collection
string transformationText

Applies ad-hoc transformation code (Text / XML type) to a collection of items.

When writing Text / XML transformations, you can use most ASCX transformation methods inside macro expressions.

Outside of transformations, the macro autocomplete only offers the methods under the Transformation namespace, for example Transformation.GetDocumentUrl(). However, you can manually enter the methods even without the namespace.

> Back to the list of macro method categories

Data manipulation

Data conversion

Text manipulation

Advanced text processing

Date and time modification

Mathematical operations

E-commerce

SKU properties

Properties related to SKU

URLs

User membership and permissions

Transformations