Oracle BIEE Custom Text Format

Oracle BIEE uses a custom text format for the columns in the report, where you can fill in the HTML code. Assuming that the report is shown on the right, the following are examples of country IDs:

1. Pass the value of the country ID column to the Countryid parameter in the link URL, and the result is that the AD is linked to Http://localhost/map/asia.asp?country=AD with the following code:

1 @[html]"<a href=" Http://localhost/map/[email protected] "target=" _blank " > "@" </a> "

where [email protected] represents this column value.

2. Pass the value of the country ID column to the email address, where the difference between @ and "@" is noted, in the result the @ is the parameter value, "@" is displayed as @, and the result is AD, the code is as follows:

1 @[html]

　　Note: The front of the @ can be removed.

3. The above method can be extended to some other effects, some of which are BIEE code rules, summarized in the following 2 articles:

(1). A semicolon between multiple styles in a style that needs to be wrapped in double quotation marks or ";", with no spaces between the styles, and if there are multiple functions in the onclick function, the semicolon is enclosed in double quotation marks.

(2). js function in order to call the column value as a parameter, you need to enclose the single quotation mark, that is, ' @ '; if the @ symbol is displayed, then ' @ ' or ' @ ' is available.

1 [html]

　　Note: This is the only method that can be used to pass parameters to the JS function.

Oracle BIEE Custom Text Format