The List View group on views usually includes all columns for the table, but only some columns are flagged to display in the list window for that table. (For example, the borrower table has many columns such as borrower_name, btype, location, second_id, expiration_date, and so forth, but only the name and location may display on the List Borrowers window.)
Search list windows are exceptions. If a column does not appear in the search list window, it is because that column is not listed in the List View group for that window. To include a column, complete the steps in this task.
The Edit View group on views only includes those columns that appear in the corresponding edit window. (For example, if the btype field does not appear on the Edit Borrower window, it is because the btype column is not listed in the Edit View group for the borrower table.)
Consequently, to include a column on an edit window, you need to add that column to the Edit View group for the view for that window.
The column that you want to add must already exist in the table and you must know its SQL name. (For a list of tables and their columns, see the Table Structures Guide.) If you want to add a column that does not exist on a table, call Horizon Customer Support.
To add a column to a search list view or edit window
1 | Open the view for the window to which you want to add a column. |
For instructions on opening the correct view, see Finding and Opening the Correct View.
2 | Click Page Down or resize the window to display the List View group or Edit View group of the window you are reconfiguring. |
3 | Using the List View or Edit View drop-down list, view the current column order numbers and determine what order number you want to assign to the new column based on the order numbers already assigned to other columns. |
4 | Click New. |
5 | Complete the fields for the group as necessary. |
Note: If you add a column to a search list window, the column name you enter will always be “bib#”. Enter the label that you want and specify the MARC map that accesses the bibliographic information displays for that column. The MARC map is what controls the type of information displayed (title, author, and so forth).
6 | Save your changes. |
7 | Exit Horizon and log back in to view your changes. |
© 1998-2017 Sirsi Corporation