Don't want duplicate values in table - Need to know best practice

[geet]

Hi All,

I have a table as follows:

I don't want duplicate values as follows:

I want to put a validation that user should not be able to submit the record if there is already a record with 2500 limit.

I want to know whether it will be a best practice to put validation as if there are 10,000 records with 2500 limit value, will it be going to impact my system performance.

Regards,

Shikha Khanna

[geet]

Hi Ankur,

I have implemented your solution as follows, but i need to understand 1 thing.

(function executeRule(current, previous /*null when async*/) {

var gr = new GlideRecord('x_mkgaa_credit_car_credit_card_limit_calculation');

  gr.addQuery('u_subsiary_id', current.u_subsiary_id);

  gr.addQuery('u_currency', current.u_currency);

  gr.addQuery('u_limit', current.u_limit);

  gr.query();

  if(gr.next())

  {

  gs.addErrorMessage(current.u_limit+' Limit already exist for this subsidiary and currency. Please put a different limit value');

  current.setAbortAction(true);

  current.u_limit ='';

  }

})(current, previous);

Que: Right now i have only 12 records and gliding only 12 records will not affect my instance performance. What if i have 100000 records and i am gliding limit for all these records. Would   it affect my instance performance?

Regards,

Shikha Khanna

[shruti_tyagi]

Hi Shikha,

See if Unique index on fields will help you. From the comments above it seems like you want combination of two fields unique (subsidiary ID and currency). This can be guaranteed by unique index on subsidiary ID and currency. Means combination of values will be unique.

http://wiki.servicenow.com/index.php?title=Unique_Index#gsc.tab=0

[Ankur Bawiskar]

Hi Shikha,

Any update on this? Can you mark my answer as correct, helpful and hit like if you were able to achieve your requirement. This helps in removing this question from unanswered list and helps others to search similar question quicker. Thanks in advance.

Regards

Ankur

[geet]

Done: Thanx for always helping 🙂

[kemmy1]

I tried this and even though I don't have a duplicate and it does not create the record, I still get an error.

    findDupeCircuitID();
    function findDupeCircuitID() {
        var gr = new GlideRecord("u_network_circuit");
        gr.addQuery("u_ciruit_id", current.u_ciruit_id);
        gr.query();
        if (gr.hasNext()) {
            gs.addErrorMessage("Circuit ID already exists");
            current.setAbortAction(true);
        }
    }
   

It's on a Before Business rule.

Any thoughts?

Lisa