---
title: Reference - Transformation methods
related:
- https://docs.kentico.com/k11/developing-websites/loading-and-displaying-data-on-websites/writing-transformations.md
- https://docs.kentico.com/k11/custom-development/miscellaneous-custom-development-tasks/adding-custom-methods-to-transformations.md
- https://docs.kentico.com/k11/macro-expressions/reference-macro-methods.md
---
> Agent instructions:
> **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown.
>
> - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version.
> - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt).
This reference provides information about the default methods specifically designed for use in [transformations](https://docs.kentico.com/k11/developing-websites/loading-and-displaying-data-on-websites/writing-transformations.md):
> **Note:** **Important**
>
> The listed methods are available for both **ASCX** and **Text / XML** transformations (the examples are in ASCX format).
>
> For **Text / XML** transformations, use macro method equivalents with identical signatures. If you encounter problems, use the macro autocomplete help to find information about potential syntax differences.
> **Info:** **Notes**
>
> - All transformation methods return _**string**_ values (unless otherwise specified).
> - In addition to the listed method, **ASCX** transformations allow you to call any type of inline code, including ASP.NET system methods, Kentico API or custom API.
> - For **Text / XML** transformations, you can also use general macro methods. See: [Reference - Macro methods](https://docs.kentico.com/k11/macro-expressions/reference-macro-methods.md)
## Data loading
| Method | Parameters | Description and examples |
| ---------------- | ----------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Eval | string columnName
_bool encode_ | Loads the value from the specified column of the transformed object's data. Returns the value as an _object_ data type. Use only for ASCX transformations.
The optional boolean parameter specifies whether the method HTML encodes the loaded value. When not specified, the encoding depends on the value of the _CMSHTMLEncodeEval_ web.config key (false by default). |
| Eval | string columnName | Loads the value from a column of the transformed object's data, and returns it as an object of the specified type. Use only for ASCX transformations.
("NodeAliasPath") %> |
| EvalCDATA | string columnName
_bool encapsulate_ | Loads the value from the specified column of the transformed object's data and escapes all occurrences of the **]]>** sequence in the returned string.
Depending on the optional boolean parameter (true by default), the method wraps the whole string in the **** enclosure. |
| EvalJSString | string columnName | Loads the value from the specified column of the transformed object's data. Encodes the returned text to be used in JavaScript code and encapsulates it into ' characters. |
| GetEditableValue | string controlId | Loads the content of an editable region on the page. Specify the region using the control ID (web part control ID). |
| GetNotEmpty | object columnsOjb | Returns the value of the first data column that is not empty or _null_. The parameter must provide a list of column names separated by semicolons. |
| GetColumnName | string columns
_bool allowEmptyColumn_ | Returns the value of the first column that is present in the data of the transformed object. The parameter must provide a list of column names separated by semicolons.
By default, the method only returns columns that are not _null_ or empty. Set the optional second parameter to _true_ to allow empty values. |
| Property | Description and examples |
| ------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DataItem | Gets the currently transformed data item. |
| DataItemIndex | Gets the data item index for the current transformation container. You have to use _Container.DataItemIndex_ to get the index in the current binding context. |
| DataItemCount | Gets the total number of data items in the current transformation container. If pagination is used, the _DataItemCount_ returns the number of items on the current page. |
| DataRowView | Gets a _DataRowView_ of the transformed record's data. |
| DisplayIndex | Gets the current position of the data item as displayed in a control. |
| DocumentCustomData | Gets the value of custom page data fields (culture specific). Use the \["nodename"] notation to retrieve data stored in the specified node of the XML.
See also: [Storing custom data for all page types](https://docs.kentico.com/k11/custom-development/working-with-pages-in-the-api/storing-custom-data-for-all-page-types.md) |
| EditableItems | Gets the content of the specified editable region on the page. |
| NodeCustomData | Gets the value of custom page data fields (shared for all culture versions). Use the \["nodename"] notation to retrieve data stored in the specified node of the XML.
See also: [Storing custom data for all page types](https://docs.kentico.com/k11/custom-development/working-with-pages-in-the-api/storing-custom-data-for-all-page-types.md) |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Boolean operations
| Method | Parameters | Description and examples |
| ------------------------ | --------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| If | object value
object trueResult
object falseResult | Returns a result according to the boolean value of the first parameter. |
| IfCompare | object value
object comparableValue
object falseResult
object trueResult | Compares the values of the first and the second parameter.
If the parameters are different or are both _null_, the method returns the third parameter.
If the parameters are equal, the fourth parameter is returned. |
| IfEmpty | object value
object emptyResult
object nonEmptyResult | Checks for emptiness of the value in the first parameter.
If the first parameter is _null_, the method returns the second parameter.
If the first parameter is not _null_, the third parameter is returned. |
| IfTrue | object value
object trueResult | Checks whether the first parameter contains a true boolean value.
If true, the method returns the second parameter.
If false, an empty string is returned. |
| IsFirst | - | Returns a _true_ value if the transformed data item is the first in the provided data. If pagination is used, the method returns a _true_ value for the first item on the current page. |
| IsLast | - | Returns a _true_ value if the transformed data item is the last in the provided data. If pagination is used, the method returns a _true_ value for the last item on the current page. |
| IsCurrentDocument | - | Returns a _true_ value if the transformed page is equal to the page where the transformation is being displayed. |
| IsDocumentOnSelectedPath | - | Returns a _true_ value if the transformed page is present on the [alias path](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/setting-page-aliases.md) of the page where the transformation is being displayed (i.e. if the transformed page is an ancestor of the current page). |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## URLs and page links
| Method | Parameters | Description and examples |
| ---------------------------- | --------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetAbsoluteUrl | string relativeUrl
_int siteId_
_object siteNameObj_
_string domainName_ | Converts relative URLs to absolute URLs. You can specify the target domain name in the absolute URL using either a site ID, site code name or explicitly.
If you leave all optional parameters empty, the method generates the absolute URL using the domain of the current site.
("NodeSiteID")) %> |
| GetAttachmentIcon | object attachmentGuidColumn | Returns the attachment file type icon according to the extension of the file identified by the given GUID column. |
| GetAttachmentUrl | object attachmentFileName
object nodeAliasPath
_string variant_ | Returns the URL of the attachment file specified by name in the first parameter, loaded from the page whose alias path matches the second parameter. For example, you can use the method for working with [grouped](https://docs.kentico.com/k11/managing-website-content/configuring-the-environment-for-content-editors/creating-grouped-page-attachments.md) and [unsorted](https://docs.kentico.com/k11/managing-website-content/working-with-files/page-attachments.md) attachments.
You can optionally generate a URL for an [image variant](https://docs.kentico.com/k11/developing-websites/managing-responsive-images.md) of the attachment by specifying an image variant definition identifier.
The method returns the same URL as the _GetAttachmentUrlByDocumentId_ method, but without loading the whole page, which results in better performance. |
| GetAttachmentUrlByDocumentId | object attachmentFileName
object attachmentDocumentId
_string variant_ | Returns the URL of the attachment file specified by name in the first parameter, loaded from the page whose ID matches the second parameter.
You can optionally generate a URL for an [image variant](https://docs.kentico.com/k11/developing-websites/managing-responsive-images.md) of the attachment by specifying an image variant definition identifier. |
| GetAttachmentUrlByGUID | object attachmentGuid
object attachmentFileName
_string variant_ | Returns the URL of the attachment file specified by an attachment GUID value.
You can optionally generate a URL for an [image variant](https://docs.kentico.com/k11/developing-websites/managing-responsive-images.md) of the attachment by specifying an image variant definition identifier.
The method's file name parameter does not have to correspond with the real file name.
") %> |
| GetDocumentLink | _bool encodeName_ | Returns a HTML link ( tag) that leads to the transformed page. By default, the method HTML encodes the page name in the link title. Set the optional parameter to false to disable the encoding. |
| GetDocumentUrl | | Returns the URL of the specified page. The method does not evaluate [custom URL extensions](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/extensionless-and-custom-urls.md) set for the page. |
| GetDocumentUrlById | object documentIdObj | Returns the URL of the specified page. The method evaluates [custom URL extensions](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/extensionless-and-custom-urls.md) set for the page if the system is set to use extensionless URLs. |
| GetDocumentUrlByGUID | object nodeGuid
object nodeAlias | Returns a [permanent URL](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/linking-pages-and-files.md) of the specified page (with the NodeGUID in the query string). |
| GetFileIcon | object fileExtension | Returns an tag displaying a font icon that represents the MIME type of the specified file extension. |
| GetFileIconClass | string extension | Returns the name of a CSS class, which you can use to display font icons representing the MIME type of the specified file extension. Assign the class to an tag to display the icon.
("DocumentExtensions")) %>"> |
| GetForumPostUrl | object postIDPath
object fourmID | Returns the URL of the [forum](https://docs.kentico.com/k11/community-features/forums.md) post specified by the path in the first parameter, from the forum specified by the identifier in the second parameter. |
| GetMediaFileUrl | object fileGUID
object fileName | Returns the URL of the specified [media file](https://docs.kentico.com/k11/managing-website-content/working-with-files/media-library-files.md). The media file is specified by the file GUID in the first parameter and the file name in the second parameter.
Note: _GetMediaFileUrl_ requires different parameters when used as a macro method for _Text / XML_ transformations:
_libraryId_ – the ID of the media library containing the file (the value in the media file's _FileLibraryID_ column).
_filePath_ – the file's media library path and extension (the value in the media file's _FilePath_ column).
_fileGuid_ – the file's GUID identifier (the value in the media file's _FileGuid_ column).
_fileName_ – the file's name, without the extension (the value in the media file's _FileName_ column).
_useSecureLinks_ – true/false value indicating whether the link evaluates media library permissions.
(optional) _downloadLink_ – true/false value indicating whether the link forces a file download (i.e. uses the _attachment_ content-disposition).
For example: _{% GetMediaFileUrl(FileLibraryID, FilePath, FileGuid, FileName, true) %}_ |
| GetMetaFileUrl | object fileGUID
object fileName | Returns the URL of the specified meta file. The file is specified by the file GUID in the first parameter and the file name in the second parameter. |
| GetNavigationUrl | | Returns a resolved (absolute) URL of the page that's currently being processed. The resulting URL is not encoded. The method reflects page navigation settings, such as _URL redirection_, and _Redirect to first child_. |
| GetUrl | object aliasPath
object urlPath
_object siteName_ | Returns the URL of the page specified by the [alias path](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/setting-page-aliases.md) in the first parameter or the URL path in the second parameter. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Text manipulation
| Method | Parameters | Description and examples |
| ----------------------- | -------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| EnsureMaximumLineLength | object textObj
int maxLength | Allows you to insert line breaks into long sequences of characters without whitespace (such as URLs). The method places the line break after the number of characters specified by the second parameter. |
| HTMLEncode | string text | Encodes HTML tags in the specified text.
") %> |
| LimitLength | object textObj
int maxLength
_string padString_
_bool wholeWords_ | Limits text to the length specified in the second parameter. The third parameter is the trimming suffix, i.e. the string appended to the end of shortened strings. The suffix is included in the maximum length. For example, if you use the "..." suffix and a maximum length of 100 characters, the returned string contains the first 97 characters of the original string, followed by an ellipsis.
Set the last parameter to true to avoid trimming in the middle of words. |
| Localize | object text | Resolves all [localization expressions](https://docs.kentico.com/k11/multilingual-websites/setting-up-a-multilingual-user-interface/localizing-text-fields.md) inside the specified text. |
| RemoveDiscussionMacros | object inputText | Removes all BBCode tags from the provided text. |
| RemoveDynamicControls | object inputText | Removes all controls from the specified text (such as inline [widgets](https://docs.kentico.com/k11/developing-websites/preparing-widgets-for-users.md)). |
| StripTags | object inputText | Completely removes HTML tags from the specified text.
") %> |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Images
| Method | Parameters | Description and examples |
| ------------------- | -------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetEditableImage | string controlId
object maxSideSize
object width
object height
object alt | Returns an image tag that displays the content of an editable image control or web part on the page. Specify the editable image using the control ID (web part control ID). |
| GetEditableImageUrl | string controlId | Returns the URL of the image selected inside the specified editable image control or web part. Specify the editable image using the control ID (web part control ID). |
| GetImage | object attachmentGuidColumn
_object (int) maxSideSize_
_object (int) width_
_object (int) height_
_object alt_ | Returns an image tag that displays the image file whose GUID is stored in the specified column of the transformed object's data. |
| GetImageByUrl | object imageUrl
_object (int) maxSideSize_
_object (int) width_
_object (int) height_
_object alt_ | Returns an image tag that displays the image stored under the specified URL. |
| IfImage | object attachmentGuidColumn
object isImage
object notImage | Checks whether the page attachment specified by the GUID in the first parameter is an image file. If the file is an image, the method returns the value of the second parameter, otherwise the value of the third parameter. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## E-commerce
### SKU price
| Method | Parameters | Description and examples |
| ---------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| GetSKUPrice | - | Returns an SKU price based on the SKU data and the data of the current shopping cart.
The price includes any [catalog discounts](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-catalog-discounts.md) that apply.**Tip:** To display the list price of a product, use the _GetSKUListPrice_ method. |
| GetSKUFormattedPrice | - | Returns a [formatted](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) SKU price based on the SKU data and the data of the current shopping cart.
The price includes any [catalog discounts](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-catalog-discounts.md) that apply.**Tip:** To display the formatted list price of a product, use the _GetSKUFormattedListPrice_ method. |
| GetSKUListPrice | - | Returns an SKU list price based on the SKU data and the data of the current shopping cart. The list price is loaded from the _SKURetailPrice_ column. |
| GetSKUFormattedListPrice | - | Returns a [formatted](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) SKU list price based on the SKU data and the data of the current shopping cart. The list price is loaded from the _SKURetailPrice_ column. |
| GetSKUOriginalPrice | - | Returns the _greater_ of the following SKU price options:
The product's list price (from the _SKURetailPrice_ column)
– OR –
The product's price (from the _SKUPrice_ column) without any discounts applied
If both prices are equal to the standard product price with discounts (i.e. the product's list price is equal to the price and no discounts apply), the method returns _0_. |
| GetSKUFormattedOriginalPrice | - | Returns the _greater_ of the following SKU price options and [formats the result](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) according to the currency used in the current shopping cart:
The product's list price (from the _SKURetailPrice_ column)
– OR –
The product's price (from the _SKUPrice_ column) without any discounts applied
If both prices are equal to the standard product price with discounts (i.e. the product's list price is equal to the price and no discounts apply), the method returns _0_. |
| GetSKUPriceSaving | _bool percentage_ | Returns the amount of money saved on the price of the processed SKU, as a percentage or in the [currency](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) of the current shopping cart.
The savings are calculated based on the difference between the product's price (from the _SKUPrice_ column, including any [catalog discounts](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-catalog-discounts.md) that apply) and the _greater_ of the following options:
The product's list price (from the _SKURetailPrice_ column)
– OR –
The product's price (from the _SKUPrice_ column) without any discounts applied
If the product's price is greater than the list price and no discounts apply, the method returns _0_.
The optional _bool percentage_ parameter determines whether the result is returned as a percentage. By default the value is _false,_ which means the result is returned in the currency of the current shopping cart. |
| GetSKUFormattedPriceSaving | - | Returns the amount of money saved on the price of the processed SKU and [formats the result](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) according to the currency used in the current shopping cart.
The savings are calculated based on the difference between the product's price (from the _SKUPrice_ column, including any [catalog discounts](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-catalog-discounts.md) that apply) and the _greater_ of the following options:
The product's list price (from the _SKURetailPrice_ column)
– OR –
The product's price (from the _SKUPrice_ column) without any discounts applied
If the product's price is greater than the list price and no discounts apply, the method returns _0_. |
| GetSKUTax | - | Depending on the site's **Prices include tax** [setting](https://docs.kentico.com/k11/configuring-kentico/managing-sites/configuring-settings-for-sites/settings-e-commerce.md), returns either:
The tax value that will be added to the processed SKU's price during checkout (if prices do not include tax)
– OR –
The tax portion of the processed SKU's price (if prices already include tax)
For example:
Prices do not include tax, the SKU price is 50 and the applied tax rate is 5% – returns **2.5**
Prices include tax, the SKU price is 55 and the applied tax rate is 10% – returns **5** |
| GetFormattedSKUTax | - | Displays a tax value for the processed SKU and [formats the result](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) according to the currency used in the current shopping cart. Depending on the site's **Prices include tax** [setting](https://docs.kentico.com/k11/configuring-kentico/managing-sites/configuring-settings-for-sites/settings-e-commerce.md), returns either:
The tax value that will be added to the processed SKU's price during checkout (if prices do not include tax)
– OR –
The tax portion of the processed SKU's price (if prices already include tax) |
### SKU price formatting
| Method | Parameters | Description and examples |
| ----------------- | ----------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ApplyExchangeRate | decimal price | Returns the specified price (_decimal price_) in the [currency](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) of the current user's shopping cart and then converts the value into the current site's main currency (according to the configured [exchange rates](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies/configuring-exchange-rates.md)). |
| FormatPrice | decimal price
_bool round_ | Returns the specified price (_decimal price_) formatted according to the [currency](https://docs.kentico.com/k11/e-commerce-features/configuring-your-store/configuring-currencies.md) of the current user's shopping cart. The method does not work in contexts where the current shopping cart is not available.
Set whether the price should be rounded (_bool round_) to the number of decimal fields specified in the current site's currency settings. Price rounding is enabled by default if the _round_ parameter is not specified. |
### SKU properties
| Method | Parameters | Description and examples |
| ----------------------- | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetSKUIndicatorProperty | string column | Returns a value from the specified column (_string column_) of the [public status](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/products/product-statuses.md) assigned to the transformed product. Commonly used public status columns are _PublicStatusDisplayName_ and _PublicStatusName_.
If the product is evaluated as a new product, the public status is determined by [thePublic status for 'new products'setting](https://docs.kentico.com/k11/configuring-kentico/managing-sites/configuring-settings-for-sites/settings-e-commerce.md). |
| IsSKUAvailableForSale | - | Returns whether the given SKU can be bought by [customers](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/customers.md) on the live site based on the properties of the SKU. |
| IsSKUInStock | - | Returns whether the given SKU is available or not based on the [stock amountproperty](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/products.md) of the SKU. |
| GetSKUNodeAlias | - | Returns the node alias of the given SKU. If there are multiple nodes for the SKU, the first occurrence is returned. If there is not any node for the SKU, an empty string is returned. |
### URLs
| Method | Parameters | Description and examples |
| -------------------- | ------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetSKUUrl | - | Returns the user-friendly permanent URL of the SKU. |
| GetProductUrl | object (Guid) skuGuid
object (string) skuName
_object (string) siteName_ | Returns the user-friendly URL of the [product](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/products.md) specified by the [GUID](https://docs.kentico.com/k11/configuring-kentico/configuring-page-urls/linking-pages-and-files.md) (_object skuGuid_) and name (_object skuName_) of the product on the specified [site](https://docs.kentico.com/k11/configuring-kentico/managing-sites.md) (_object siteName_). If you do not specify the site name, the system uses the current site. |
| GetProductUrlById | object (int) skuID
object (string) skuName
_object (string) siteNameObj_ | Returns the user-friendly URL of the product specified by the ID (_object skuID_) and name (object skuName) of the product on the specified site (_object siteName_). If you do not specify the site name, the system uses the current site. |
| GetProductUrlForFeed | 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_). If you do not specify the site name, the system uses the current site. |
| GetSKUImageUrl | int width
int height
OR
int maxSideSize | Returns the URL of the product image. Specify the required width (_object width_) and height (_object height_) of the image, or the maximum side width of the image (_object maxsidesize_).
If the product image is not specified, the URL of the [default product image](https://docs.kentico.com/k11/configuring-kentico/managing-sites/configuring-settings-for-sites/settings-e-commerce.md) is returned. |
### Discounts
| Method | Parameters | Description and examples |
| --------------------------------- | ------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetDiscountCouponCodeRemoveButton | string couponCode
_string cssClass_
_string buttonText_ | Available for transformations displaying [coupon code](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-coupon-codes.md) items using the **Coupon codes** web part.
Generates an __ element (of the _submit_ type) that removes the specified coupon code from the shopping cart when clicked.
("Code"), "btn") %> |
| GetMultiBuyDiscountNames | - | Available for transformations displaying shopping cart items (for example using the **Shopping cart content** web part).
Returns the names and price values of [Buy X Get Y discounts](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-buy-x-get-y-discounts.md) and [Product coupons](https://docs.kentico.com/k11/e-commerce-features/managing-your-store/discounts/working-with-product-coupons.md) applied to the current shopping cart item, enclosed within **li** HTML tags. |
### Google tag manager product data
| Method | Parameters | Description and examples |
| ----------------- | ------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetGtmProductJson | _object additionalData_
_string purpose_ | Returns a JSON string containing the data of the transformed product (SKU), in a format suitable for use with the Google Tag Manager and Universal Analytics Enhanced Ecommerce features.
For more information, see [Integrating Google Analytics Enhanced Ecommerce](https://docs.kentico.com/k11/e-commerce-features/customizing-and-developing-your-store/integrating-google-analytics-enhanced-ecommerce.md).
The optional _additionalData_ parameter allows you to extend the returned JSON string (custom fields and values).
The optional _purpose_ parameter can be processed in [code customizations of the product data creation process](https://docs.kentico.com/k11/e-commerce-features/customizing-and-developing-your-store/integrating-google-analytics-enhanced-ecommerce/customizing-e-commerce-data-for-google-analytics.md), if you need to return different JSON data for various scenarios. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Membership and community
| Method | Parameters | Description and examples |
| --------------------- | ---------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| GetAge | object dateOfBirth
string unknownAge | Returns age calculated according to the date of birth given in the first parameter. If the date of birth is not available, the method returns the string specified in the second parameter. |
| GetBadgeImage | int badgeId | Returns an image tag that displays the specified user [badge](https://docs.kentico.com/k11/community-features/badges.md).
("UserBadgeID")) %> |
| GetBadgeName | int badgeId | Returns the display name of the specified [badge](https://docs.kentico.com/k11/community-features/badges.md).
("UserBadgeID")) %> |
| GetGender | object genderObj | Returns the gender of users according to the value specified in the parameter. Load the value from the user's gender field.
1 = Male
2 = Female
unspecified (0) = N/A |
| GetGroupAvatarImage | _object avatarId_
int maxSideSize
_int width_
_int heigth_
object alt | Returns an image tag that displays the [avatar](https://docs.kentico.com/k11/community-features/avatars.md) of a [group](https://docs.kentico.com/k11/community-features/groups.md). The group is either identified automatically using the _AvatarGuid_ field of the transformed group, or you can optionally specify an identifier value using the first parameter. |
| GetGroupProfileUrl | object groupNameOjb
_string siteName_ | Returns the URL of the specified [group's](https://docs.kentico.com/k11/community-features/groups.md) profile page. |
| GetMemberProfileUrl | object memberNameObj
_string siteName_ | Returns the URL of the user profile page for the specified group member. |
| GetUserAvatarImage | _object avatarId_
_object userId_
int maxSideSize
_int width_
_int heigth_
object alt | Returns an image tag that displays the [avatar](https://docs.kentico.com/k11/community-features/avatars.md) of a user. The user is either identified automatically using the _AvatarGuid_ field of the transformed user, or you can specify either an avatar identifier or user identifier. |
| GetUserAvatarImageUrl | object avatarId
object userId
_string userEmail_
int maxSideSize
int width
int heigth | Returns the URL of the specified user's [avatar](https://docs.kentico.com/k11/community-features/avatars.md) image. If the user does not have an avatar, the method returns the URL of the default avatar image. |
| GetUserFullName | int userId | Returns the full name of the specified user.
("UserID")) %> |
| GetUserProfileUrl | object userNameObj
_string siteName_ | Returns the URL of the user profile page for the specified user. |
| TrimSitePrefix | object userName | Removes the site prefix from user names (if site prefixes are enabled in **Settings -> Security & Membership -> Use site prefix for user names**). |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Date & time
| Method | Parameters | Description and examples |
| ----------------- | ------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| FormatDate | object dateTime | Displays the specified date without the time component. The method automatically formats the date according to the current culture. |
| FormatDateTime | object dateTime
string format | Displays the date and time value according to a [format string](https://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.110%29.aspx). The method formats the date and time according to the current culture. |
| GetDate | string dateTimeField | Loads a date value from the specified field of the transformed object's data. |
| GetDateTime | string dateTimeField
OR
object dateTime
OR
DateTime dateTime
_string format_ | Loads a date and time value from the specified field of the transformed object's data. The value uses the [time zone](https://docs.kentico.com/k11/configuring-kentico/configuring-time-zones.md) set for the server.
Optionally, you can format the date and time value according to a [format string](https://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.110%29.aspx). |
| GetCustomDateTime | object dateTime
string timeZoneName | Converts a date and time value to the specified [time zone](https://docs.kentico.com/k11/configuring-kentico/configuring-time-zones.md). |
| GetDateTimeString | object dateTime
bool showTooltip | Converts the specified date and time value to the [time zone](https://docs.kentico.com/k11/configuring-kentico/configuring-time-zones.md) set for the server. The second parameter determines whether the displayed date and time has a tooltip. |
| GetSiteDateTime | object dateTime | Converts the specified date and time value to the current site's [time zone](https://docs.kentico.com/k11/configuring-kentico/configuring-time-zones.md). |
| GetUserDateTime | object dateTime | Converts the specified date and time value to the [time zone](https://docs.kentico.com/k11/configuring-kentico/configuring-time-zones.md) set for the user viewing the page. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Smart search
> **Info:** See [Setting up search on your website](https://docs.kentico.com/k11/configuring-kentico/setting-up-search-on-your-website.md) for more information.
| Method | Parameters | Description and examples |
| ------------------ | ----------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| SearchResultUrl | _bool absolute_
_bool addLangParameter_ | Returns the URL of the page containing the details of the search result.
The optional 'absolute' parameter indicates if the returned URL is absolute.
False by default.
The optional 'addLangParameter' indicates if a culture specific query should be added to the URL.
True by default. Note that clicking a link leading to a different culture changes the visitor's site culture.
**Note**: The **SearchResultUrl** method does not return valid URLs for search results produced by [general indexes](https://docs.kentico.com/k11/configuring-kentico/setting-up-search-on-your-website/using-locally-stored-search-indexes/creating-local-search-indexes/defining-local-general-indexes.md), since the indexed objects are not pages and there is no default page to display the object details. You need to write and use a [custom transformation method](https://docs.kentico.com/k11/custom-development/miscellaneous-custom-development-tasks/adding-custom-methods-to-transformations.md) to generate the correct URL of a custom page displaying the appropriate information.
**Combine with default culture**
When the [Combine with default culture](https://docs.kentico.com/k11/multilingual-websites/editing-the-content-of-multilingual-websites.md#using-the-default-language-version-for-untranslated-pages) setting is enabled, visitors will see pages in the default culture if they aren't translated to their current culture.
If the _addLangParameter_ is set to false, the site culture will NOT change once visitors click the link leading to the page in the default culture. That is, they keep on browsing the site in the culture they made the search in.
If the _addLangParameter_ is set to true, the site culture will change once visitors click the link leading to the page in the default culture. That is, they keep on browsing the site in the default culture afterwards. |
| SearchHighlight | string text
string startTag
string endTag | Wraps the text of the first parameter into the tags specified by the other two parameters.
","")%> |
| GetSearchImageUrl | string noImageUrl
int maxSideSize | Returns the URL of the current search result's image.
The first parameter specifies the URL used if no image is found – enter either the full relative path starting from the application root (~~/), or a partial path starting from the \*~~/App\_Themes//Images/\* directory. The second parameter specifies the maximum side size to which the method resizes the image. |
| GetSearchValue | string columnName | Returns the value of the specified field for the current search result. Allows you to access both the general fields of the given objects type (page, custom table etc.) and any other fields included in the search index. |
| GetSearchedContent | string content | Parses the searched content as XML if required, and removes dynamic controls and macro expressions. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Syndication (RSS, Atom, XML)
> **Info:** See also: [Setting up syndication feeds](https://docs.kentico.com/k11/developing-websites/loading-and-displaying-data-on-websites/displaying-data-advanced-scenarios/setting-up-syndication-feeds.md)
| Method | Parameters | Description and examples |
| ------------------------- | ----------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| GetAtomDateTime | object dateTime | Returns the specified date and time value in a format suitable for Atom feeds (according to [RFC 3339](http://www.ietf.org/rfc/rfc3339.txt)). |
| GetRSSDateTime | object dateTime | Returns the specified date and time value in a format suitable for RSS feeds (according to [RFC 882](http://www.w3.org/Protocols/rfc822/)). |
| GetBlogCommentUrlForFeed | object documentIdObj | Returns the URL of the comments added to the [blog post](https://docs.kentico.com/k11/managing-website-content/blogs.md) specified by a page identifier. Includes the feed query string parameter in the URL. |
| GetDocumentUrlForFeed | - | Returns the URL of the transformed document with the feed query string parameter in the URL. The method takes the feed name from the **Feed name** property of the syndication web part used to generate the feed.
**Note**: Since the method adds the **feed** query string parameter, please use a different parameter name in the **Feed querystring key** property of the syndication web part. |
| GetForumPostUrlForFeed | object postIDPath
object forumId | Returns the URL of the forum post specified by the path in the first parameter and the forum identifier in the second parameter. Includes the feed query string parameter in the URL. |
| GetMediaFileUrlForFeed | object fileGUID
object fileName | Returns the URL of the media file specified by the GUID in the first parameter and the file name in the second parameter. Includes the feed query string parameter in the URL. |
| GetMessageBoardUrlForFeed | object documentIdObj | Returns the URL of the message board specified by the identifier of the page containing the message board. Includes the feed query string parameter in the URL. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Microsoft SharePoint
> **Info:** See also: [Displaying SharePoint data in Kentico](https://docs.kentico.com/k11/integrating-3rd-party-systems/integrating-sharepoint/displaying-sharepoint-data-in-kentico.md)
| Method | Parameters | Description and examples |
| --------------------- | --------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| GetSharePointFileUrl | _string fileRefColumnName_
_int cacheMinutes_
_int cacheFileSize_
_int width_
_int height_
_int maxSideSize_ | Returns the URL of a file from a SharePoint server. The first parameter sets the name of the data column containing the name of the file _(FileRef_ by default). Has optional parameters for specifying file caching and image dimensions. |
| GetSharePointImageUrl | _string fileRefColumnName_
_int width_
_int height_
_int maxSideSize_ | Returns the URL of an image file from a SharePoint server. The first parameter sets the name of the data column containing the name of the file _(FileRef_ by default). Has optional parameters for specifying image dimensions. |
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Placeholders for sublevels in hierarchical data
If you are writing transformations for items from a hierarchical data source (for example page data from the _Universal viewer_ web part), you can add a placeholder that sets the position of sublevels:
For **ASCX** transformations:
```text
```
For **Text** transformations:
```text
{^SubLevelPlaceHolder^}
```
When displaying items that have descendants in the hierarchy, the placeholder is replaced by the child level under the given item. If you do not add the sublevel placeholder, the system automatically renders child levels after the code of parent items.
You can use the sublevel placeholder in [hierarchical transformations](https://docs.kentico.com/k11/developing-websites/loading-and-displaying-data-on-websites/writing-transformations/using-hierarchical-transformations.md), as well as standard transformations applied to hierarchical data.
> **Note:** **Note**: The sublevel placeholder only works if the **Hierarchical display mode** property of the viewer web part is set to **Inner**.
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)
## Editing buttons for pages displayed by listing web parts
You can configure listing web parts (such as the _Repeater_) to display special buttons in editing mode (on the **Page** tab of the **Pages** application). The buttons allow users to edit or delete individual items displayed in the list.
To set the exact position of the editing buttons, add the following expression into the code of **ASCX** item transformations:
```text
##editbuttons##
```
[> Back to the list of transformation method categories](#referencetransformationmethods-transformationmethodstop)