Skip to main content
Topics#Data ManagementJeff McKinnis's Question
Jeff McKinnis (HEALTHCAREfirst) asked in #Data Management
Jun 10, 2011, 4:07 PM

I have a validation rule for Cases that checks to see if a box is checked on the

I have a validation rule for Cases that checks to see if a box is checked on the account called "Not Eligible for Support" and I am getting some mixed results. If a system adminstrator account is used, the rule successfully keeps a case from being saved at it's creation. If any other profile is used, the case is not prevented from being created; however if they try to do anything to the case (change status, etc.) the rule kicks in and works as it should. I ran the Debug tool and it showed the following:

 

Example of Rule Success:

 

12:27:27.155|CODE_UNIT_FINISHED|CalculateBusinessHoursAges on Case trigger event BeforeInsert for [new]

 

12:27:27.160|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Case:new

 

12:27:27.160|VALIDATION_RULE|03d40000000GrEy|Not_Eligible_for_Support

 

12:27:27.160|VALIDATION_FORMULA|Account.Not_Eligible_for_Support__c = TRUE|Account.Not_Eligible_for_Support__c=1

 

12:27:27.160|VALIDATION_FAIL

 

12:27:27.160|CODE_UNIT_FINISHED|Validation:Case:new

 

12:27:27.218|CODE_UNIT_FINISHED|TRIGGERS

 

12:27:27.218|EXECUTION_FINISHED

 

Example of Rule Failing:

 

14:12:20.174|CODE_UNIT_FINISHED|CalculateBusinessHoursAges on Case trigger event BeforeInsert for [new]

 

14:12:20.180|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Case:new

 

14:12:20.180|VALIDATION_RULE|03d40000000GrEy|Not_Eligible_for_Support

 

14:12:20.180|VALIDATION_FORMULA|Account.Not_Eligible_for_Support__c = TRUE|Account.Not_Eligible_for_Support__c=null

 

14:12:20.180|VALIDATION_PASS

 

14:12:20.180|CODE_UNIT_FINISHED|Validation:Case:new

 

14:12:20.343|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:Case

 

14:12:20.374|WF_RULE_EVAL_BEGIN|Assignment

 

The differnence for the one failing is the field is being evaluated as "null" instead of "1" or "true", but the same profile gets this when trying to save the case with a different status:

 

2:30:24.176|CODE_UNIT_FINISHED|CalculateBusinessHoursAges on Case trigger event BeforeUpdate for [5004000000FRa3c]

 

12:30:24.179|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Case:5004000000FRa3c

 

12:30:24.179|VALIDATION_RULE|03d40000000GrEy|Not_Eligible_for_Support

 

12:30:24.180|VALIDATION_FORMULA|Account.Not_Eligible_for_Support__c = TRUE|Account.Not_Eligible_for_Support__c=1

 

12:30:24.180|VALIDATION_FAIL

 

12:30:24.180|CODE_UNIT_FINISHED|Validation:Case:5004000000FRa3c

 

12:30:24.208|CODE_UNIT_FINISHED|TRIGGERS

 

Everyone has rights to view this field and this particular profile in the example above even has read/write rights to the Account.Not_Eligible_for_Support field.

 

Where else should I check?
5 answers
Write an answer...
0/9000