The tag names can be overridden using the setRowsetTag and setRowsTag methods. The following annotated code sample shows how to use the setSQL method to pass a SQL statement to the data engine and set the element names for the generated data:. The data engine has several very useful functions that can be used to generate objects or files that can be used with the other BI Publisher APIs:. This method can generate either a String or Stream output.
This will cause it to use the disk rather than use memory to generate the output. This is especially useful when you want to generate some sample data to build a layout template against.
The sample files are annotated to provide a better description of the components of the data template. From here you can copy and paste the samples to get you started on your own data templates.
This template extracts employee data and department details. It has a single parameter, Department Number, that has to be populated at runtime. The data is extracted using two joined queries that use the bind variable method to join the parent Q1 query with the child Q2 query. It is based on an existing Oracle Report that has been converted to a data template format.
It follows the same format as the Employee data template but has some added functionality. This data template combines data that exists in a table called "dept" with data from an xml file called "employee. It follows the same format as the Employee data template but the employee data comes from an xml file instead of from the emp table. All rights reserved. Contents Previous Top of Page Next.
Book List. Contact Us. Attributes: name Required - the property name. Attributes: name Required - the parameter name that will be referenced in the template. Supported for queries against the Oracle E-Business Suite only.
Consists of one or more lexical elements to support flexfields. There are four types of key flexfield-related lexicals as follows: oracle. Attributes: name Required - the unique query identifier.
Attributes: parentQuery - specify the parent query name. Required for multiple queries Defines the structure of the output XML. This section is optional for single queries; if not specified, the data engine will generate flat XML.
Attributes: name Required - the XML tag name to be assigned to the group. Attributes: name - the tag name to assign to the element in the XML data output. Indicates whether to include parameters in the output.
Valid values are: True default False. Indicates whether to remove or keep the null elements in the output. Allows you to set the case for the output XML element names. Sets the number of rows fetched at a time through the jdbc connection. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? In this article. Required element. Specifies the name of the template as it appears in either the New Project or the Add New Item dialog box.
Specifies the description of the template as it appears in either the New Project or the Add New Item dialog box. Note that directly using the value of the content could lead to unexpected behavior, see Avoiding DocumentFragment pitfall section below. First, we have a table into which we will later insert content using JavaScript code.
Then comes the template, which describes the structure of an HTML fragment representing a single table row. In the Option 1 field enter the text of the first selectable option. Enter Selectable Options. For single Select and multi-select elements only: Enter the selectable values in this field. Maximum number of characters. For text data elements, enter the character limit. Only displayed for text data types.
Common Element Name. For Common Elements, select the element from the drop-down menu. The value of the FOA attribute you link it to, along with a label that you create.
Based on. Select a the key attribute the content rule is based on. For values. Enter the values of the key attributes for which the rule is applicable. Multiple values are allowed separated by semicolon. Blank and can't be edited for the Default content rule. Check if the data element must be filled in before publication.
0コメント