How to delete a set of authority records

Question

How to delete a set of authority records using Global Data Change (GDC)

Answer

1. Identify authority records by record ID, or use Scan Job if records all contain a characteristic that can be scanned for.
2. Create Data Change Rule Set with following parameters:
   1. Condition: <set condition specific to your data; condition should be true for all records in set>
   2. Consequence: Record Disposition / Delete (see Chapter 3, Table 2 of the GDC User's Guide)
3. Add Data Change Rule Set to a Data Change Rule Set Group.
4. Preview data change. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
5. Schedule the Data Change Job.

Additional Information

Example scenario: Vendor has completed authority work & all existing authority records are to be deleted before new authorities from vendor are imported.

1. Add full range of records
   1. Find highest auth_id  (See this Article for the MS Access Prepackaged Reports SQL code to find highest record ID)

      1. select max(auth_id) from auth_master;

      2. Note output - this will be top of record range in next step.
   2. GDC > Record Sets > Specific Records > Range of Records
      1. In first box, start with 1
      2. In second box, add auth_id output from step 1.1.2 above.
2. Use Data Change Job to execute deletion:
   1. Create Data Change Rule Set with following parameters:
      1. Condition: MARC Control Field Exists / LDR
      2. Consequence: Record Disposition = Delete
   2. Add Data Change Rule Set to Data Change Rule Set Group.
   3. Preview data change in Preview slider. Success should be indicated by "Rule execution causes record to be deleted" at top of preview window
   4. Job Management > Submit Data Change Job > Use Record Set & Data Change Rule Set Group and submit job.

Result: all authority records in database are deleted.

Alternate method for creating record set: Use Scan Job to put all authority records into record set:

1. GDC > Rule Sets > Scan Rule Set
   1. Condition: MARC Control Field Exists / LDR
   2. Consequence: Include
2. Add Scan Rule Set to Scan Rule Set Group
3. Job Management > Submit Scan Job > Use Scan Rule Set Group to scan Entire Database and put records in New Record Set

Sample Scan Rule Set for this scenario attached. This can be imported into GDC in Scan Rule Sets > Import.

Additional Information

See Chapter 3 of the Global Data Change User's Guide.

Attachment

ScanRule_IncludeAllAuthRecords.dslr

• Article last edited:22-Nov-2019