[Share] Update Date Added

[thalient-ai]

Description

This script will update the 'Date Added' value of parent items to match the 'Date Added' value of child attachments. If there are multiple attachments, the parent item will be updated to match the earliest value.

Event

None

Operation

Script

Data

/**
 * Updates the date added of items to match the date added of their attachments
 * @author thalient-ai
 * @link https://github.com/windingwind/zotero-actions-tags/discussions/
 * @see https://github.com/windingwind/zotero-actions-tags/discussions/
 */

const Zotero = require("Zotero");

(async function() {
    // Check to prevent multiple instances of the script from running simultaneously
    if (Zotero.updateDateRunning) return;
    Zotero.updateDateRunning = true;

    try {
        // Retrieve selected items from Zotero's active pane
        const selectedItems = Zotero.getActiveZoteroPane().getSelectedItems();

        // Check if any items are selected
        if (!selectedItems || !selectedItems.length) {
            Zotero.alert(null, "Update Date Added", "No items selected.");
            Zotero.updateDateRunning = false;
            return;
        }

        let totalUpdated = 0; // Counter for the number of items updated

        // Iterate over each selected item
        for (const item of selectedItems) {
            // Skip if the item is not a regular item (e.g., attachment or note)
            if (!item.isRegularItem()) continue;

            // Ensure only top-level items are processed (avoiding attachments)
            if (item.isTopLevelItem()) {
                // Fetch all attachments of the current item
                const attachments = await Zotero.Items.getAsync(item.getAttachments());
                // Convert and store the parent item's 'dateAdded' to a Date object
                let parentDateAdded = new Date(item.getField('dateAdded') + 'Z');
                let earliestDateAdded = parentDateAdded; // Initialize earliest date with the parent's date

                // Check each attachment's 'dateAdded' to find the earliest date
                for (const attachment of attachments) {
                    const attachmentDateAdded = new Date(attachment.getField('dateAdded') + 'Z');
                    if (attachmentDateAdded < earliestDateAdded) {
                        earliestDateAdded = attachmentDateAdded; // Update if found an earlier date
                    }
                }

                // Update the parent item's 'dateAdded' if an earlier date was found
                if (earliestDateAdded < parentDateAdded) {
                    item.setField('dateAdded', earliestDateAdded.toISOString());
                    await item.saveTx();
                    totalUpdated++; // Increment the update counter
                }
            }
        }

        // Display a completion alert with the number of items updated
        Zotero.alert(null, "Update Date Added", `${totalUpdated} item(s) date updated.`);
    } catch (error) {
        // Log and alert any errors encountered during execution
        Zotero.logError(`Error updating "Date Added": ${error.message}`);
        Zotero.alert(null, "Error", `An error occurred: ${error.message}`);
    } finally {
        // Ensure the running flag is cleared after execution
        Zotero.updateDateRunning = false;
    }
})();

Anything else

No response