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 |
||||||
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”. |
||||||
Choose one of these options to specify where in Horizon this window displays.
|
|||||||
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 .) |
|||||||
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. |
||||||
Do one of these options:
This option specifies that the window displays only a slice or portion of the entire list that you can browse.
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 |
||||||
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. |
||||||
Enter the name you want to display as this column label in the list window. |
|||||||
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. |
||||||
Do one of these options:
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. |
|||||||
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 |
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. |
Mark the Sort-Wt option. |
|
Enter “sort_weight”. This is the name of the column that sorts the data. |
|
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