Normalized data services

[Sagar Rd]

Hi All,

We have company records on the core_company table and we have identified there are true duplicates and also for a few company records we dont even have the Hash Value generated.

1. How to generate the Hash Values for the records without running the business rule (the BR runs basically on insert or update but need suggesting without using the BR)?

2. What are the consiquences of company records left out with out the hash value?

3. Without the hash value can we still map the records to the normalized mappings?

4. For Ex. we have AMAZON - Hash value is available and has the record used in multiple places, then we have Amazon record has the hash value provided by the OOB, if we delete the Amazon record while it still be pulled back into the system because of the data services job that runs?

Thank you

Mourya

[Paul Kunze]

Hi, regarding question 1 you should check out the method setWorkflow(false). It can update your records without running any Business Rule. Example:

var grCompany = new GlideRecord('core_company');
grCompany.get('<company sys_id>');
grCompany.setWorkflow(false);
grCompany.setValue('<field>', '<value>');
grCompany.update();

I don't understand what kind of hash value you mean so I cannot answer the other questions.