async function generateWhereClause()

in api/v1/src/datasets/views/sqlBuilder.js [249:269]

• 19 lines of code
• 8 McCabe index (conditional complexity)

async function generateWhereClause(view) {
    let source = view.source;
    let sql = "";
    let whereAdded = false;
    const sqlFilter = source.queryFilter;
    if (sqlFilter !== undefined && sqlFilter.trim().length > 0) {
        sql += `WHERE ${sqlFilter}`;
        whereAdded = true;
    }

    const accessControlEnabled = (view.accessControl && view.accessControl.enabled) || false;
    if (accessControlEnabled === true) {
        console.log("Using dataset entitlements");
        let entityFilter = await generateAccessControlSubquery(view);
        if (entityFilter) {
            sql += (whereAdded ? " AND " : "WHERE ") + entityFilter;
        }
    }

    return sql.trim();
}