nancystodd/sn_search_field_for_duplicate_values.md

Forked from harrisitservices/sn_search_field_for_duplicate_values.md

Created 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/nancystodd/4b0d71f1971589f1936a5c558941b109.js"></script>
Save nancystodd/4b0d71f1971589f1936a5c558941b109 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;