WHERE-Bedingungen

WHERE Bedinungen können sehr einfach über die where , andWhere und orWhere Funktion erstellt werden.

context.enableModules();
const { SelectBuilder } = require("ou.sp.SelectBuilder");

const dbUser = util.getEnvironment("OUSP_DATABASE_USER");
const dbPassword = util.getEnvironment("OUSP_DATABASE_PASSWORD");
const db = new DBConnection("odbc", "ousp", dbUser, dbPassword);

try {
    const rows = SelectBuilder.from("costcenter", db)
        .select("costcenterName", "string")
        .select("id", "number")
        .where("recipient = 'R0100'")
        .orWhere("recipient = 'R0200'")
        .execute();

    context.returnValue = JSON.stringify(rows);
} catch (error) {
    context.errorMessage = error.message;
    context.returnValue = -1;
} finally {
    db?.close();
}

Nested WHERE Bedingungen

Aktuell können verschachtelte WHERE Bedingungen nur als string übergeben werden.

context.enableModules();
const { SelectBuilder } = require("ou.sp.SelectBuilder");

const dbUser = util.getEnvironment("OUSP_DATABASE_USER");
const dbPassword = util.getEnvironment("OUSP_DATABASE_PASSWORD");
const db = new DBConnection("odbc", "ousp", dbUser, dbPassword);

try {
    const rows = SelectBuilder.from("costcenter", db)
        .select("costcenterName", "string")
        .select("id", "number")
        .where("recipient = 'R0100'")
        .andWhere("(costcenterName like '%Einkauf%' OR costcenterName like '%Entwicklung%')")
        .execute();

    context.returnValue = JSON.stringify(rows);
} catch (error) {
    context.errorMessage = error.message;
    context.returnValue = -1;
} finally {
    db?.close();
}