In the Explorer Tree, locate the object to which you wish to add a block.
Expand the Template Information object and select the template XML document to which you wish to add a block.
Expand the Group Information object and any sub-groups until you can select the XML document to which you wish to add a block.
When modifying a block, find the desired XML document, and then see Modifying Blocks on XML Documents.
There are options in adding a block to the XML document at this point.
Right-click on the XML document or template XML document, hold your cursor over the Create option, and when the sub-menu is displayed, left-click on the Block option.
Left-click on the [New Block] button in the Main Toolbar.
Left-click on the File Menu. Left-click on the New option. Left-click on the Block option.
Press Alt+B on the keyboard.
The Adding New Block screen will be displayed.
In the Create block similar to pop-list, if you wish to create the block based on an existing block on the XML document, select the desired block here. Otherwise, select (none). This option is only available if you are adding the block to an entity and not another block.
In the Block Name property, enter the name of the new block that you are adding to the XML document.
In the Block Type property, select the type of block that you are creating. Choices are Standard Block, Executable XML, and Parameter Form.
The choices displayed are dependent on the Block Type selected.
In the Query Type property, select the type of query for the XML document block. Choices are:
Not From Query: none of the fields in the block will be taken from a database query.
Simple Query: some or all of the fields in the block will be taken from a database query against a single database table or view.
Complex Query: some or all of the fields in the block will be taken from a database query against one or more database tables or views. Complex query blocks are display only or read only, and cannot be used to update the database.
Xephr Service: some or all of the fields in the block will be provided by a xephr service. This selection is only available if there are Xephr Service datasources.
Xephr Interconnect: some or all of the fields in the block will be provided by a published entity on a Xephr host. This selection is only available if there are Xephr Interconnect datasources.
In the Datasource property, select
the desired datasource or (use default).
Selecting (use default) will allow the block to be used with any datasource,
and data brought in will be determined by the report's or template's datasource.
If Xephr Service was selected, this pop-list will only list the datasources
that provide Xephr services.
If Xephr Interconnect was selected, this pop-list will only list the
Xephr Interconnect datasources.
If Simple Query was selected, in the Table pop-list, select the database table/view on which to base the block.
If Xephr Service was selected, in the Table pop-list, select the Xephr Service method on which to base the block. Choices are determined by the datasource selected.
If Xephr Interconnect was selected, in the Interconnect Entity pop-list, select the published entity on which to base the block. Choices are determined by the published entities on the datasource selected.
Set the Create Heading flag to determine if a heading will be created for this block. When this checkbox is set to on, an additional non-database label field is created in which the heading can be entered for the block.
If Xephr Interconnect was selected, in the Target Login property, enter the user ID that will be used to access the published entity.
If Xephr Interconnect was selected, in the Target Password property, enter the password that will be used to access the published entity.
Click on the Next button in the bottom right of the screen to continue.
The information displayed next is dependent on the setting of the Query Type property.
Since none of the fields will be created from the database, the Adding New Labels screen will be displayed.
To add a new label, click on the Add button.
In the field that appears under the Fields section, enter the name of the Label and press the Enter key on your keyboard.
Repeat until you have entered all desired labels.
To delete a label that you have created, click on the desired label and press the Delete button.
When all desired labels have been entered, click on the Next button on the bottom right of the screen.
The labels will be added to the block.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button to add labels to the block as described above.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on the gray Field column header.
In the Filters property, enter
the filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Click on the Next button in the bottom right of the screen to continue.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be displayed on the block.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the entity. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button to add labels to the block as described for the Not From Query query type.
Otherwise, press the Finish button in the bottom right of the screen.
In the Select Statement property,
enter the select statement for your database query, beginning with the
word SELECT. The select statement lists the columns
in the table or view from which the data will be returned.
All columns selected from the database need to be explicitly named.
Format: SELECT column, column, column,
column FROM view
For example: SELECT item_no, description, stock_um, qty_on_hand FROM
item_master_uvw
In the Filters property, enter
the filters used to restrict the information returned by the select statement
for the block, if appropriate. This is also referred
to as the where clause. The statement begins with
the word WHERE.
Format: WHERE column (comparison)
value AND column (comparison)
value
For example: WHERE qty_on_hand > 0 AND stock_um in ('FT','IN')
In the Ordering and Grouping property,
enter any code to be executed after the filters, such as the order by
or group by.
Format: ORDER BY column, column,
column
Format: GROUP BY column, column,
column
For example: ORDER BY description, stock_um, qty_on_hand desc
Click on the Next button in the bottom right of the screen to continue.
A list of the columns in the selected table will be displayed.
Set the Key Required flag to the desired setting. This flag defaults to on, which indicates that at least one column that is selected must have the Key flag set to on. The Next button cannot be pressed until the key column is selected or this flag is set to off.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
Click on the Next button in the bottom right of the screen to continue.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be displayed on the block.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the entity. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button to add labels to the block as described for the Not From Query query type.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns for the selected Xephr method will be displayed.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on
the gray Field column header.
For each column, indicate whether
a label should be created for the field on this block by setting the Label
flag to on or off.
To set the Label flag for all displayed columns, left click once on
the gray Label column header.
You cannot set the Label flag to on
unless the Field flag is also set to on
for that column.
Press the Next button at the bottom of the screen.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be displayed on the block.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the entity. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button to add labels to the block as described for the Not From Query query type.
Otherwise, press the Finish button in the bottom right of the screen.
A list of the columns in the selected published entity will be displayed.
For each column, indicate whether
the column is a primary key for the view by setting the Key flag to on or off.
To set the Key flag for all displayed columns, left-click once on the
gray Key column header.
For each column, indicate whether
the column will be included as a field on this block by setting the Field
flag to on or off.
To set the Field flag for all displayed columns, left-click once on the gray Field column header.
Click on the Next button in the bottom right of the screen to continue.
The next step is to set up the order of the columns for the block. Using the Move Up and Move Down buttons, arrange the columns to be in the order that you wish them to be displayed on the block.
Press the Next button at the bottom right of the screen to continue.
The next step is to create additional
joins if there are multiple blocks on the entity. If
you wish to create joins, set the Create Join flag to on.
Additional properties will be displayed to allow you to define the
joining column.
In the From Column property, select the column on the child block that
will be joined to the parent block.
In the To Block property, select the block that contains the column
to which the from column will be joined.
In the To Column property, select the column to which you are joining
the from column.
The join will be added to the block when the block is created. Joins
are created as equal joins automatically.
For more information on joins, see the Joining
Data on Blocks section.
Click on the Next button at the bottom right of the screen to continue.
At this point a new screen is displayed. If you wish to add another block, set the Add Block or Labels flag to on and press the Next button.
A new screen will be displayed to allow you to select whether you want to add another block to an existing block or the entity. Click on the desired object and press the Add Block button to continue to add blocks as described above.
The screen also allows you to add labels to a block. Click on the desired block and press the Add Labels button to add labels to the block as described for the Not From Query query type.
Otherwise, press the Finish button in the bottom right of the screen.
Xephr is a registered trademark of NDS Systems, LC.
Copyright