harrisitservices/sn_search_field_for_duplicate_values.md

Last active February 6, 2018 18:57

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/harrisitservices/0f019a5d9fa0695554b3a36946c602b7.js"></script>
Save harrisitservices/0f019a5d9fa0695554b3a36946c602b7 to your computer and use it in GitHub Desktop.

Download ZIP

ServiceNow - Search Field for Duplicate Values

Raw

sn_search_field_for_duplicate_values.md

Search Field for Duplicate Values

This script uses GlideAggregate to search a field on a table for duplicate values. It then returns the value with duplicates in an array.

var xx = new GlideAggregate('table');  
xx.addAggregate('COUNT', 'field');  
xx.addHaving('COUNT', 'field', '>', '1');  
xx.query();  
var answer = [];  
while (xx.next()) {  
    answer.push(xx.getValue('field'));  
}  
return answer;