In the Explorer Tree, locate the object to which you wish to add a block.
Expand the Template Information object and select the template screen to which you wish to add a block.
Expand the Group Information object and any sub-groups until you can select the screen to which you wish to add a block.
When modifying a block, find the desired screen, and then see Modifying Blocks on Screens.
There are options in adding a block to the screen at this point.
Right-click on the screen or template screen, 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 screen, 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 screen.
In the Block Type pop-list, select the desired type. Choices are Standard Block, Tab Block, Chart Block, Bread Crumb, iFrame, Basic Drag Drop, and Cascading Menu
The choices displayed are dependent upon the block type selected.
In the Query Type property, select the type of query for the 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 screen'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.
Select the mode(s)
in which this block will be displayed for this screen. There
are four flags here, one for each mode - QBE, List, Edit, New.
For each mode in which you wish the block to be displayed, set the
flag to on. For
each mode in which you do not wish the block to be displayed, set the
flag to off.
Select the scheme for the new block.
Choices are Form and List.
Form scheme indicates that label fields and database column fields
will be created within the same block and listed from the top to the bottom
of the screen.
List scheme indicates that label fields and database column fields
will be created in different blocks and listed from the left to the right
of the screen.
In general, if only one record will be displayed in the block on the
screen, select the Form radio button. If multiple
records will be displayed in the block on the screen, select the List
radio button.
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.
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.
For each column, in the Display As pop-list, select the desired setting to display the data for this column. Choices are:
Button
Checkbox
Default Button
Reset Button
Option List
Image
Label
Object
Password
Text
Text Area
Client Date
Client DateTime
Upload File
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
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 screen. 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.
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.
For each column, in the Display As pop-list, select the desired setting to display the data for this column. Choices are:
Button
Checkbox
Default Button
Reset Button
Option List
Image
Label
Object
Password
Text
Text Area
Client Date
Client DateTime
Upload File
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
Press the Next button at 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 screen. 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.
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 screen. 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 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.
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.
For each column, in the Display As pop-list, select the desired setting to display the data for this column. Choices are:
Button
Checkbox
Default Button
Reset Button
Option List
Image
Label
Object
Password
Text
Text Area
Client Date
Client DateTime
Upload File
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
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 screen. 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.
Tab blocks are used to contain other blocks and display them in tabular format.
In the Selected Style property, select the style to apply to a tab when it is the active tab.
In the Un-Selected Style property, select the style to apply to a tab when they are inactive.
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 Query Type property, select the type of query for the 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 screen'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.
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.
In the Chart Type pop-list, select the type of chart that will be displayed in this block. See the Chart Block section for more information on each of these charts. Choices are as follows:
Area Chart: Needs one or more datapoint values and one datapoint label.
Area Chart 3D: Needs one or more datapoint values and one datapoint label.
Bar Chart: Needs one or more datapoint values and one datapoint label.
Bar Chart 3D: Needs one or more datapoint values and one datapoint label.
Bubble Chart: Needs one or more datapoint values and one datapoint label.
Candle Chart: Needs 5 datapoint values and one datapoint label. One of the datapoint values needs to be a date.
Column Chart: Needs one or more datapoint values and one datapoint label.
Column Chart 3D: Needs one or more datapoint values and one datapoint label.
Heat Map: Needs one or more datapoint values and one datapoint label.
Heat Map 3D: Needs one or more datapoint values and one datapoint label.
Line Chart: Needs one or more datapoint values and one datapoint label.
Line Chart 3D: Needs one or more datapoint values and one datapoint label.
Pie Chart: Needs one datapoint value and one datapoint label.
Pie Chart 3D: Needs one datapoint value and one datapoint label.
Scatter Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart: Needs one or more datapoint values and one datapoint label.
Stacked Bar Chart 3D: Needs one or more datapoint value and one datapoint label.
Stacked Column Chart: Needs one or more datapoint values and one datapoint label.
Stacked Column Chart 3D: Needs one or more datapoint values and one datapoint label.
If you do not know which chart you want to create, choose one, and continue. You will be able to change it later, if desired.
In the Chart Title property, enter the title for this chart block.
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.
Select the mode(s)
in which this block will be displayed for this screen. There
are four flags here, one for each mode - QBE, List, Edit, New.
For each mode in which you wish the block to be displayed, set the
flag to on. For
each mode in which you do not wish the block to be displayed, set the
flag to off.
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.
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, in the Used As pop-list, select one of the following:
For Querying: the values in this column will be used queried from the database, but not be used in the generation of the chart values or labels.
Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.
Database Label: only one of these is required per chart. This is the column that is the key to the chart, for which the values are measured. The values in this column are used to label each bar, each slice, each point on the line, etc.
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 on 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.
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, in the Used As pop-list, select one of the following:
For Querying: the values in this column will be used queried from the database, but not be used in the generation of the chart values or labels.
Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.
Database Label: only one of these is required per chart. This is the column that is the key to the chart, for which the values are measured. The values in this column are used to label each bar, each slice, each point on the line, etc.
Click on the Next button on the lower 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, in the Used As pop-list, select one of the following:
For Querying: the values in this column will be used queried from the database, but not be used in the generation of the chart values or labels.
Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.
Database Label: only one of these is required per chart. This is the column that is the key to the chart, for which the values are measured. The values in this column are used to label each bar, each slice, each point on the line, etc.
Click on the Next button on the lower 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, in the Used As pop-list, select one of the following:
For Querying: the values in this column will be used queried from the database, but not be used in the generation of the chart values or labels.
Database Value: used with the database label, these are the measured values that determine the height of the bars, the point on the line, the size of the pie slice, etc.
Database Label: only one of these is required per chart. This is the column that is the key to the chart, for which the values are measured. The values in this column are used to label each bar, each slice, each point on the line, etc.
Click on the Next button on 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 Query Type property, select the type of query for the 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 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 screen's or template's datasource.
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 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.
In the Separator Type property, select Text or Image. The separator type determines what character or image will be used to separate the values in the bread crumb block.
In the Separator property, if you selected Text, enter the separator character. If you selected Image, enter the file path to the desired image from the Xephr server.
In the Body Style property, select the style to be applied to the block. The default is (from parent) allowing the style to be determined from the screen properties.
In the Non-Editable Field Style property, select the style to be applied to labels and display only field on this block. The default is (from parent) allowing the style to be determined from the Non-Editable Field Style applied to the screen.
In the Link Style property, select the link style that defines the styles that will be used for hyperlinks on this block. The default is (from parent) allowing the style to be determined from the screen properties.
Select the mode(s)
in which this block will be displayed for this screen. There
are four flags here, one for each mode - QBE, List, Edit, New.
For each mode in which you wish the block to be displayed, set the
flag to on. For
each mode in which you do not wish the block to be displayed, set the
flag to off.
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 Link flag to on for the column that will be displayed as the link on the bread crumb block. Only one column can have this flag set to on.
Set the Support flag to on for any columns that need to be included on the block to support the link column. The column selected as the Link column cannot have the Support flag set to on.
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.
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 Link flag to on for the column that will be displayed as the link on the bread crumb block. Only one column can have this flag set to on.
Set the Support flag to on for any columns that need to be included on the block to support the link column. The column selected as the Link column cannot have the Support flag set to on.
Press the Next button at 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.
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.
Set the Link flag to on for the column that will be displayed as the link on the bread crumb block. Only one column can have this flag set to on.
Set the Support flag to on for any columns that need to be included on the block to support the link column. The column selected as the Link column cannot have the Support flag set to on.
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.
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.
iFrame blocks are used to display external documents within the block.
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.
Basic Drag Drop blocks are used to display the data in multiple columns, and allow the user to drag and drop the record from one column to another. See the Basic Drag Drop Blocks section for more information about this type of block and its requirements.
In the Query Type property, select the type of query for the block. Choices are:
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 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 screen's or template's datasource.
If Xephr Interconnect was selected, this pop-list will only list the
Xephr Interconnect datasources.
The Table pop-list will be displayed
if Simple Query or Xephr Service was selected as the query type.
If Simple Query was selected, select the database table/view on which
to base the block.
The Interconnect Entity, Target
Login, and Target Password properties are displayed if Xephr Interconnect
was selected as the query type.
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.
In the Target Login property, enter the user ID that will be used to
access the published entity.
In the Target Password property, enter the password that will be used
to access the published entity.
In the Number of Containers property, enter the total number of containers that will be displayed in the block, between which the records can be moved.
In the Container Id Column property, enter the column from the complex query, or select the column from the table that is used to store the container ID for the record. The container ID determines in which container the record will be placed when the block is loaded, and is updated when records are moved between containers.
In the X Column property, enter the column from the complex query, or select the column from the table that is used to store the location in pixels of the top left corner of the record on the X axis (horizontal) of the container to which the record has been assigned.
In the Y Column property, enter the column from the complex query, or select the column from the table that is used to store the location in pixels of the top left corner of the record on the Y axis (vertical) of the container to which the record has been assigned.
Set the Collapsible flag to the desired setting. When this flag is set to on, at runtime the detail block can be collapsed so that the entire detail block is hidden or can be expanded and displayed. When this flag is set to off, the detail block cannot be hidden and expanded, and will always be displayed.
If the Collapsible flag is set to on, set the Initial State property to the desired setting. When set to Collapsed, the records will be loaded on the block with the detail block collapsed and hidden. When set to Expanded, the records will be loaded on the block with the detail block expanded and displayed.
Select the mode(s)
in which this block will be displayed for this screen. There
are four flags here, one for each mode - QBE, List, Edit, New.
For each mode in which you wish the block to be displayed, set the
flag to on. For
each mode in which you do not wish the block to be displayed, set the
flag to off.
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.
A list of the columns in the selected table 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 the header block by setting
the Header flag to on or off. Fields selected
for the header block cannot be included on the detail block.
To set the Header flag for all displayed columns, left-click once on
the gray Header column header.
For each column, indicate whether
the column will be included as a field on the detail block by setting
the Detail flag to on or off. Fields selected
for the detail block cannot be included on the header block.
To set the Detail flag for all displayed columns, left-click once on
the gray Detail 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.
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
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 blocks.
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 screen. 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.
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 the header block by setting
the Header flag to on or off. Fields selected
for the header block cannot be included on the detail block.
To set the Header flag for all displayed columns, left-click once on
the gray Header column header.
For each column, indicate whether
the column will be included as a field on the detail block by setting
the Detail flag to on or off. Fields selected
for the detail block cannot be included on the header block.
To set the Detail flag for all displayed columns, left-click once on
the gray Detail 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.
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
Press the Next button at 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 screen. 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 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 the header block by setting
the Header flag to on or off. Fields selected
for the header block cannot be included on the detail block.
To set the Header flag for all displayed columns, left-click once on
the gray Header column header.
For each column, indicate whether
the column will be included as a field on the detail block by setting
the Detail flag to on or off. Fields selected
for the detail block cannot be included on the header block.
To set the Detail flag for all displayed columns, left-click once on
the gray Detail 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.
For each column, in the Style pop-list, select the field style to be applied, or leave the setting at (from parent) to have the field style defined at the block level.
For each column, in the Format
pop-list, select the format mask for this field
from the list of pre-defined format masks.
Date fields must have a format mask entered. Format
masks can only be applied to date, currency, and numeric fields.
For more information, see the Format
Masks section.
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 screen. 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