How to set field value unique using scripts

[malaisamy1]

Hi Guys,

Here i have one problem,

i want a ui action script for finding duplicate records.

My scenario is , if the field invoice_no has same value for two different record over the list,

when i click my ui action button it has to give me an error y saying already one record is there for this field invoice_no.

Is it possible. Can someone help me?

please find my below code

1. getDuplicates();
2. function getDuplicates() {
3.     var dupRecords = [];
4.     var gaDupCheck1 = new GlideAggregate('sys_user');
5.     gaDupCheck1.addQuery('active','true');
6.     gaDupCheck1.addAggregate('COUNT', 'user_name');
7.     gaDupCheck1.groupBy('user_name');
8.     gaDupCheck1.addHaving('COUNT', '>', 1);
9.     gaDupCheck1.query();
10.     while (gaDupCheck1.next()) {
11.           dupRecords.push(gaDupCheck1.user_name.toString());
12.     }
13.     gs.print(dupRecords);
14. }

its giving me an error 'addHaving is not allowed in scoped applications'

Is there any alternate solution for this scenario?

Thanks in Advance

Malai

[malaisamy1]

Hi Tolga,

I have already marked as correct answer and helpful.

Please find my another issue here. I have raised one more discussion.

Please help me on this.

Malaisamy

[malaisamy1]

Tolga,

This is my new topic Need script to add days (taking from dropdown field)

Help me on this