thiscodeWorks - Organizing the best of code online

List view

export const scrollTo = (distance) => {
    window.scrollTo({
        top: distance,
        behavior: 'smooth'
    })
}

export const scrollToTop = () => scrollTo(0)

#sql #postgres #duplicate

Postgres query check duplicate data

select "field1", "field2", count(*)
from "tableName"
group by "field1", "field2"
HAVING count(*) > 1

#servicenow #javascript #duplicate

Find duplicate user email (or anything else) - Blogs - Blog - ServiceNow Community


/*
Client callable script include used for filtering sys_user lists
to identify duplication email users
name: duplicateEmail
active: true
client callabe: true
*/
function duplicateEmail() {
    var xx = new GlideAggregate('sys_user');
    xx.addAggregate('COUNT', 'email');
    xx.addHaving('COUNT', 'email', '>', '1');
    xx.query();
    var answer = new Array();
    while (xx.next()) {
        answer.push(xx.getValue('email'));
    }
    return answer;
}

ScrollTO

Postgres query check duplicate data

Find duplicate user email (or anything else) - Blogs - Blog - ServiceNow Community

Save snippets that work with our extensions