Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Once a review file is created in Create Lists, it can be sorted.  Create Lists enables you to sort the list of records within a review file by any of the indexed data elements the records contain. The first field you choose is the primary sort criterion, the next is the secondary criterion, and so on. You can specify a maximum of 32 different sort criteria. The system sorts the list in alphanumeric or chronological order, depending on the data type of the sort criteria. Records that do not include the specified sort field appear at the beginning of the resulting sorted list.

...

Anchor
topofpage
topofpage
Table of Contents

Table of Contents

Sorting a Review File

  • Choose Create Lists from the Function list.

    Image Added

  • In the Review Files section, click on the review file you want to sort by selecting its row. This will highlight the review file.

    Image Added

  • Click on the Sort Records button.

    Image Added

  • The Sorting Fields dialog box will open.

    Image Added

  • In the Sorting Fields dialog box, double-click the box under Type to open the Select Me box.

    Image Added

  • Choose a record type from the Select Me pop-up window.  In this example, we are going to Sort by title using the b Bibliographic button.  Click OK.

    Image Added

  • In the Sorting Fields dialog box, double-click the box under Field to open the Select Me box.

    Image Added

  • Choose Fixed or Variable Fields from the Data Fields tab shown in the Select Me pop-up window.  In this example, we are going to choose the MARC tag instead of the title to make sure we do not get duplicate entries from a sorting criterion that may have multiple fields.  Click OK.  

    Image Added
Info

Note: When the MARC Field box appears, type the number 245. Click OK.  

...

  • Click the Sort button to start the sorting process. Create Lists closes the dialog box and sorts the list of records in the review file.

    Image Added
Info

To add sort criteria, click on the Insert or Append buttons.  To change the sort criteria, double-click on either box under the Type of Field to bring up the Select Me pop-up window.  Click on the new sort criteria and click OK.  

To delete an added sort criteria, click on the line you want to delete, and click the Delete button.

  • While the system sorts the review file, the Status column of the Review Files tab indicates sorting. When the sort is finished, the Status column indicates complete.

...

Top of page

Duplicate Entries
Anchor
duplicateentries
duplicateentries

If the primary sort criterion is a field that occurs more than once in a given record, such as the Title or Subject field, a duplicate listing of the record appears for each occurrence of the field. This allows the record to be sorted in multiple locations within the review file. As a result, a review file's record count can increase after sorting. Resorting the review file by record number removes those duplicate entries. However, if the introduction of duplicate entries causes the number of records listed in the review file to exceed the maximum number for that review file, the system drops the excess records. Resorting by record number will not restore the dropped records. In such a case, you must clear the review file and re-run the original query to restore the contents.  

Top of page

Solving Duplicate Entries Issue

Specifying a MARC tag as the sort field can eliminate the creation of duplicate copies of records in the review file during sorting. If the primary sort field occurs more than once in a record, Create Lists makes duplicate entries for that record in the review file for all fields. For example, if the primary sort field is the title, a record with both a 245 and 222 title field appears in the sort list twice. However, if you specify the primary sort field as MARC tag "245" instead of title, the record appears only once in the list. 

Top of page

...

Saving a Sort
Anchor
save
save

You can save a sort so that you can reapply it to a different list in the future.

Reviewing All Saved Sorts

Choose Create Lists from the Function list.

...

In the Review Files section, click on the review file you want to sort by selecting its row. This will highlight the review file.

...

  • Click on the Saved Sorts tab on the left column menu.  

    Image Added

  • Choose a saved sort to view by selecting a row under the Sort. The search criteria are shown in the top portion of the tab under the words Sorting Fields. Tip: clicking on Sort Name will change the Saved Sorts to an alphabetical list.

    Image Added

Top of page

Using Saved Sorts

  • A Saved Sort is used before adding any sorting criteria.  Highlight the review file you would like to sort by clicking on it.  Click on the Sort Records button.

...

  • Image Added

...

  • When the Sorting Fields

...

Optional: The Apply Saved Sort allows you to use a previously saved sort.  This is from the sidebar menu.  Save This Sort allows you to save the sort.  This sort will be saved to the sidebar menu under Saved Sorts.

...

In the Sorting Fields dialog box, double-click the box under Type to open the Select Me box.

...

Choose a record type from the Select Me pop-up window.  In this example, we are going to Sort by title using the b Bibliographic button.  Click OK.

...

In the Sorting Fields dialog box, double-click the box under Field to open the Select Me box.

...

Choose Fixed or Variable Fields from the Data Fields tab shown in the Select Me pop-up window.  In this example, we are going to choose the MARC tag instead of the title to make sure we do not get duplicate entries from a sorting criterion that may have multiple fields.  Click OK.  

...

Info

Note: When the MARC Field box appears, type the number 245.  Click OK.  

...

Click the Sort button to start the sorting process. Create Lists closes the dialog box and sorts the list of records in the review file.

...

While the system sorts the review file, the Status column of the Review Files tab indicates sorting. When the sort is finished, the Status column indicates complete.

...

To add sort criteria, click on the Insert or Append buttons.  To change the sort criteria, double-click on either box under the Type of Field to bring up the Select Me pop-up window.  Click on the new sort criteria and click OK.  

...

To delete an added sort criteria, click on the line you want to delete, and click the Delete button.

...

  • box appears, click on the Apply Saved Sort button.  

    Image Added

  • The Retrieve Sort box will appear.  Choose a saved sort to use by selecting a row under the Sort. The search criteria are shown in the top portion of the tab under the words Sorting Fields. Click on the Select button. Clicking on Close will exit the Retrieve Sort box.

    Image Added

  • This will add the saved sort to the Sorting Fields.  Click on the Append or Insert buttons to add more sort criteria. Click on the Delete button to remove any sort criteria.  If you have made any changes and want to save the new sort, click the Save This Sort button.  

    Image Added

  • The Enter Sort Name For Saving box will appear.  Adding a new name will save a new sort.  Choosing from the existing names will save any changes to the original sort.  Click the Save button.  

    Image Added

  • Click the Yes button to save the sort.  Click the No button to not save the sort.

    Image Added

  • When using the Choosing from the existing names option, the Confirm Saving box has a message asking if you want to replace the existing sort.  

    Image Added

Top of page

Modifying Saved Sorts

Choose Create Lists from the Function list.

  • Click on the Saved Sorts tab.  

    Image Added

  • Choose a saved sort to view by selecting a row under the Sort. The search criteria are shown in the top portion of the tab under the words Sorting Fields. Tip: clicking on Sort Name will change the Saved Sorts to an alphabetical list.  Click the Edit button.

    Image Added

  • The Editing Sort box will appear. Click on the Append or Insert buttons to add more sort criteria. Click on the Delete button to remove any sort criteria.  If you have made any changes and want to save the new sort, click the Save or Save As button.  

    Image Added

  • When the Save button is used, the Confirm Saving box will appear.  Click the Yes button to save the sort.  Click the No button to not save the sort. 

    Image Added

  • Using the Save As button will bring up the Enter Sort Name For Saving box will appear.  Adding a new name will save a new sort.  Choosing from the existing names will save any changes to the original sort.  

    Image Added

  • When using the Choosing from the existing names option, the Confirm Saving box has a message asking if you want to replace the existing sort.  

    Image Added

Top of page

Related Documentation

Page Properties
Filter by label (Content by label)
showLabelsfalse
cqllabel = "sierra" and label in ( "create_lists" , "guidelines" ) and space != "MD"

...