Job

Difficulty

Spec (updated on Wed Jun 4 11:46:15 2025)

describe("reports/dictlist", function () {
    const languages = ['en', 'es-ES', 'fr-FR'];
    languages.forEach((lang) => {
        describe(`in ${lang}`, () => {
            beforeEach(function(){
                // If previous test failed, skip this one
                if (Cypress.env("TEST_FAILED")) {
                    this.skip();
                }
                cy.query("INSERT INTO reports_dictionary (name, description, report_area, saved_SQL) VALUES (\"zip\", \"\", \"PAT\", \"AND borrowers.zipcode='44236'\"), (\"last name\", \"\", \"PAT\", \"AND borrowers.surname='en%'\"), (\"testing2\", \"\", \"CIRC\", \"AND borrowers.dateofbirth >= '2011-07-17' AND borrowers.dateofbirth <= '2011-07-27'\"), (\"Call Number\", \"my call number rule\", \"CAT\", \"AND items.itemcallnumber='PS3566.I372 N56 2007'\"), (\"Info Today Publications\", \"\", \"CAT\", \"AND biblioitems.publishercode='Information Today'\")")
                cy.login();
                cy.set_cookie_lang(lang);
            });

            it("dictlist", function () {
                cy.visit("/cgi-bin/koha/reports/dictionary.pl?phase=View Dictionary");
                cy.get("main").should('be.visible').screenshot("dictlist");
            });
        });
    });
    afterEach(function () {
        cy.query("DELETE FROM reports_dictionary WHERE name IN (\"zip\", \"last name\", \"testing2\", \"Call Number\", \"Info Today Publications\")")
        if (this.currentTest.state === 'failed') {
            Cypress.env("TEST_FAILED", true);
        }
    });
});

Spec data

sql INSERT INTO reports_dictionary (name, description, report_area, saved_SQL) VALUES ("zip", "", "PAT", "AND borrowers.zipcode='44236'"), ("last name", "", "PAT", "AND borrowers.surname='en%'"), ("testing2", "", "CIRC", "AND borrowers.dateofbirth >= '2011-07-17' AND borrowers.dateofbirth <= '2011-07-27'"), ("Call Number", "my call number rule", "CAT", "AND items.itemcallnumber='PS3566.I372 N56 2007'"), ("Info Today Publications", "", "CAT", "AND biblioitems.publishercode='Information Today'")

sql DELETE FROM reports_dictionary WHERE name IN ("zip", "last name", "testing2", "Call Number", "Info Today Publications")

Notes

no samples in the sandbox

Additional KTD data

Old

New (updated on Wed Jun 4 22:17:24 2025)

New (es)

New (fr)