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, 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.

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.

You should give the view a name that represents the data the Horizon window will display. (For example, if you are creating a window to display vernacular titles in staff searching, you may name the view “vn_title_list”.)

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 the Index Definition in the Table Editor .)

Description

Enter a description of the view.

For example, if you are creating a vernacular titles list, you may enter “Vernacular Titles List”.

View Type

Choose one of these options to specify where in Horizon this window displays.

Title Alphabetical. Choose this type if the view you are creating displays data from the bib table.
Authority List. Choose this type if the view you are creating displays data from the auth table.

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 “Browse Vernacular Titles”.)

Help panel id

Leave this field blank.

Properties

Do one of these options:

If you are creating a browse index, mark the Slice

This option specifies that the window displays only a slice or portion of the entire list that you can browse.

If you are creating an authority-based index, mark the Slice and Xrefs boxes.

The Slice option specifies that the window displays only a slice or portion of the entire list that you can browse. The Xrefs option specifies that “see” and “see also” references display in the list.

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

Secured

Leave this field blank.

2 In these fields, do the following:

 

Field

Action

Column Name

Enter “original.”

This is the name of the column from the index table where the indexed data is stored.

Ord

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

Column Label

Enter the name 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 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

Do one of these options:

For the “original” column entry, leave this field blank.
If you are setting up additional columns that display MARC data, enter or choose a code for a MARC map for each column.)

Important: If you create any browse index from scratch, regardless of whether it is a collation key or any other type of browse index, you must make sure that you add a MARC-mapped column to the view definition for the index.

Sort Processor

Enter “none” as the sort processor.

Important: You must create a column entry for the “original” column from the index table in this view.

3 In these fields, do the following:

 

Field

Action

Table

Enter the name of the index table.

This is the index table 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.

Note: If you are creating an authority-based collation key index, you must add these columns in addition to the “original” column: “n_bibs,” “see_flag,” and “see_also_flag.” Horizon requires these columns as part of the view definition in order to display an open authority list in staff searching.

 


© 1998-2017 Sirsi Corporation