MARC Editor User Manual

The 999 field in bib records can be used to retrieve records of get statistics by user and type of update, for example 999:vvc20230223. You also can use this query to search for type of update regardless of the user: 999__a:/^[a-z]{2}cyyyymmdd/ => replace "c" with the type of update (q, p, u, t, s, etc.) and modify the date as necessary (make sure that the number of results per page is set to 10 or 25 while you run the search, otherwise it can time out).

To get system-generated record creation/update and user statistics, the following queries can be used:

Record creation

created:yyyy-mm-dd => created on a specific date

created<yyyy-mm-dd => created before a specific date

created>yyyy-mm-dd => created after a specific date

created>2022-11-01 AND created<2022-11-30 => created during a range (for a range, use the starting date and the day after the end date, for example for the month of March, it would be created>2023-03-01 AND created<2023-04-01, since the day starts at midnight, so this will catch everything created on the 31st of March until 11:59pm)

Record update

updated:yyyy-mm-dd => updated on a specific date

updated<yyyy-mm-dd => updated before a specific date

updated>yyyy-mm-dd => updated after a specific date

updated>2022-11-01 AND updated<2022-11-30 => updated during a range

User (use the login/version of name in email)

created_user:vossv => this will retrieve all records created by the user

user:vossv => this will retrieve records where the user was the last one to update the records

The queries can be combined with AND, OR and AND NOT, for example: updated:2023-03-02 AND user:vossv

The following DL and MARC Editor queries are used for the DHL KPIs as of 1 March 2023: KPI sources.docx