Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Rosetta

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Rosetta
    3. Knowledge Articles
    4. How to configure the date for the "Delivery Stats Report"?

    How to configure the date for the "Delivery Stats Report"?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Rosetta
    • Product Version: 3.1

    Description:
    Desired outcome / Goal
    To configure the date for the "Delivery Stats Report"?
    For example: most viewed items from a date range.

    Environment
    Rosetta 3

    Resolution:
    Procedure:
    It's not possible to apply parameters to the Data Management > Advanced Tools > Report > Delivery Stats Report
    It is possible to create a new report by querying the events views.
    Below is the sample SQL statement for this report.

    1. Open a ssh session on the Rosetta server
    2. Enter: s+ rep00 to get the SQL prompt
    3. In a notepad file, create a mock-up that can be pasted into the prompt as follows:
    Replace the "V2EA" with the customer's installation prefix and add the suffix "_rpt00".
    For example, If the schema name is V2EA then the user/pass are "V2EA_shr00".

    SELECT rownum AS POSITION ,
    a.number_of_deliveries,
    a.pid ,
    a.LABEL,
    a.OWNER
    FROM
    (SELECT b.number_of_deliveries,
    b.pid ,
    a.LABEL
    a.OWNER
    FROM V2EA_rep00.hdecontrol a ,
    (SELECT COUNT(b.VALUE) AS number_of_deliveries,
    b.VALUE AS pid
    FROM V2EA_shr00.hfrevent a,
    V2EA_shr00.hfreventkeys b
    WHERE a.event_type = 160
    AND a.event_id_number = b.event_id
    GROUP BY b.VALUE
    ) b
    WHERE b.pid = a.pid
    AND a.objecttype = 'INTELLECTUAL_ENTITY'
    ORDER BY b.number_of_deliveries DESC
    ) a
    WHERE rownum < 101;

    Additional Information
    The complete list of reports and views can be found in chapter 2 in the staff users guide

    Additional Information

    sql,Delivery Stats Report.date


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to configure Rosetta access rights to use 2 user groups
      • How to create a PDS handle
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      Rosetta
    2. Tags
      1. 3.1
      2. contype:kba
      3. Prod:Rosetta
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved