Auto-Generate Dataviewjs Table with Field Modifier Enabled

[LynetteCullens]

Now Automated: Only needs a folder location and/or fileClass and table will automatically generate

Example

Requirements

MetaBind

Reference

Reddit Post

Dataviewjs Code

await dv.view("/dvviews/Glossary Database", {});

Javascript Code

Change const pages to reflect the location and filters of your query

const pages = dv.pages('"Glossary"'); // Moved to the very top for easy modification

const { namedFileFields, fieldModifier: f } = MetadataMenu.api;

// Memoize fieldModifier calls
const memoizeFieldModifier = (() => {
    const cache = new Map();
    return (dv, page, field) => {
        const key = `${page.file.path}-${field}`;
        if (!cache.has(key)) {
            const value = f(dv, page, field, {
                options: {
                    alwaysOn: true,
                    showAddField: true,
                    inFrontmatter: true,
                },
            });
            cache.set(key, value);
        }
        return cache.get(key);
    };
})();

const getActiveFilePageNum = async () => {
    const tFile = app.workspace.getActiveFile();
    if (!tFile) {
        throw new Error('Active file not found');
    }
    const fileCache = await app.metadataCache.getFileCache(tFile);
    return fileCache?.frontmatter?.page || 1; // Default to 1 if page number is not available
};

const fetchNamedFileFieldsData = async (pages) => {
    const namedFileFieldsData = await Promise.all(pages.map(async (page) => {
        const filePath = page.file.path;
        const fieldsData = await namedFileFields(filePath);
        return { page, fieldsData };
    }));
    return namedFileFieldsData;
};

const extractUniqueFields = (namedFileFieldsData) => {
    const uniqueFields = new Set();
    namedFileFieldsData.forEach(({ fieldsData }) => {
        Object.keys(fieldsData).forEach(indexedPath => {
            const modifiedIndexedPath = indexedPath.replace(/____/g, ".");
            uniqueFields.add(modifiedIndexedPath);
        });
    });
    return uniqueFields;
};

const generateRows = (namedFileFieldsData, uniqueFields) => {
    const rows = namedFileFieldsData.map(({ page, fieldsData }) => {
        const rowData = [page.file.link];
        uniqueFields.forEach(field => {
            const modifiedField = memoizeFieldModifier(dv, page, field);
            rowData.push(modifiedField || '-');
        });
        return rowData;
    });
    return rows;
};

const displayNamedFileFields = async (dv) => {
    try {
        const pageNum = await getActiveFilePageNum();
        const resultsPerPage = 10;

        const totalResults = pages.length;
        const totalPages = Math.ceil(totalResults / resultsPerPage);

        const start = resultsPerPage * (pageNum - 1);
        const end = resultsPerPage * pageNum;
        const currentPageResults = pages.array().slice(start, end);

        const namedFileFieldsData = await fetchNamedFileFieldsData(currentPageResults);
        const uniqueFieldsSet = extractUniqueFields(namedFileFieldsData);
        const uniqueFields = Array.from(uniqueFieldsSet); // Convert Set to array

        // Prepare column names with adjusted titles
        const cols = ["File Path", ...uniqueFields.map(field => field.split('.').pop())]; // Split only when creating cols
        const rows = generateRows(namedFileFieldsData, uniqueFieldsSet); // Use uniqueFieldsSet to generate rows

        const options = Array.from({ length: totalPages }, (_, i) => `option(${i + 1})`).join(',');
        const selector = `\`INPUT[inlineSelect(${options}):page]\``;

        dv.span(`Page ${selector} out of *${totalPages}*`);
        dv.table(cols, rows);

    } catch (error) {
        console.error('Error fetching or displaying named file fields:', error);
        new Notice('Error fetching or displaying named file fields: ' + error.message, 5000);
    }
};


// Execute the display function
(() => {
    if (typeof app === 'undefined' || typeof MetadataMenu === 'undefined' || !MetadataMenu.api) {
        const message = 'Required plugins or APIs are not available';
        console.log(message);
        new Notice(message, 5000);
        return;
    }
    displayNamedFileFields(dv); // Assuming dv (Dataview) is defined elsewhere in your script
})();