Creating a View Definition for the Index

You create a view definition for the index in the Table Editor. The view definition lets data that you have indexed display in a window in Horizon. The view definition defines how, when, and where the indexed data displays in the Horizon window. A view definition defines the table where the data comes from, and where in the Horizon processes the data displays (for example, the Table Editor or staff searching). In addition, the view definition determines if staff can modify or add data in the view. It also specifies how Horizon sorts data in list window columns when users or staff click the Sort button.

In the view definition for a multi-source index, you set up these four columns in the List View group: original, n_bibs, see_flag, and see_also_flag

To create a view definition for the index

View: mq_view
Process: Administration\System Setup\View Control

1 In these fields, do the following:

Field

Action

Mq view

Enter a name for the new view.

Important: If the view you are creating displays data from the auth table, this is the format you must use for the view code in this field:

openauth_index code

This is the code you gave the index definition. (For more information, see Creating Two Index Definitions in the Table Editor .)

Description

Enter a description of the view. (For example, you may enter “Uniform Title Collation List”.)

View Type

Choose “Authority List” to specify where in Horizon this window displays.

Table Name

Enter the name of the index table where data that you want to display is stored in the database.

This is the table that will store the data. This is the index table you created by running the SQL script. (For more information, see Creating Database Objects for the Index .)

Window Title

Enter a title for the window.

You should give the window a title that represents the type of information displayed. (For example, you could enter “Collation Uniform Titles”.)

Help panel id

Leave this field blank.

Properties

Mark both the Slice and Xrefs boxes.

Note: Make sure none of the other Properties boxes are marked.

Secured

Leave this field blank.

2 In these fields, do the following:

Note: You complete the fields in this table for each of the four columns you add to the view definition. Save your changes after you add each column and click New create a new column.

Field

Action

Column Name

Enter the name of the column depending on the column that you are adding:

original
n_bibs
see_flag
see_also_flag

These are the names of the columns from the index table where the indexed data is stored.

Ord

Enter the order in which you want the data in this column to display in the window in Horizon.

Column Label

Enter the name that you want to display as this column label in the list window.

No. of Display Characters

Enter the number of characters of the column data that you want to display.

Pad Character

Leave this box unmarked.

Properties

Mark the Displayed box to display data from this column in the window by default.

MARC Map

Leave this field blank.

Sort Processor

Enter “none”.

3 In these fields, do the following:

File

Action

Table

Enter the name of the index table.

This is the index table that you created by running the SQL script. (For more information, see Creating Database Objects for the Index .)

Column

Enter “original”.

This is the name of the column in the index table where the database stores the original MARC mapped data.

Data Type

Mark the Sort-Wt option.

Reconst/Sw

Enter “sort_weight”.

This is the name of the column that sorts the data.

ALA Translate

Mark this box.

 


© 1998-2017 Sirsi Corporation