Apex Code Development You need to sign in to do that
Don't have an account?
jmck Validation Rule - Mixed Results
Validation Rule:
Account.Not_Eligible_for_Support__c =TRUE
The purpose of the rule is to keep a new support case from being opened if an account has this box checked. It successfully evaluates as "True" with an administrator profile, but "Null" with other profiles. However, once the case is created, a non-admin profile successfully evaluates the rule as "True" and will not let them save anything to the case.
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?
Can you please explain your use case?
Seems to be a big issue, even can not read what you wrote :)
Please provide some information about the issue :)
Sorry, my posts are not showing up for some reason.
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?
Sorry, for some reason, the body of my original question did not show up.
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?
First verify that you have used treat blank as 0 , see in bottom of your validation rule. If it does not work then Could you please share your validation rule as well that will be more helpful for finding the real issue.
Validation Rule:
Account.Not_Eligible_for_Support__c =TRUE
The purpose of the rule is to keep a new support case from being opened if an account has this box checked. It successfully evaluates as "True" with an administrator profile, but "Null" with other profiles. However, once the case is created, a non-admin profile successfully evaluates the rule as "True" and will not let them save anything to the case.
I apologize for the blank posts, but this seems to happen with IE9.
It should not happen , there must be something wrong, please answer these questions?
1) Are you using VFP or Native page layout?
2) What is the default value for this field/
Native page layout.
Default is unchecked (false)
Some more questions
1) Do you have this on layout from Admins , If yes then if admin will check this then he will not be allowed, is it right?
2) Do you have any before insert trigger on the object which has this field?
Everyone is using the same Account page layout - both admins and non-admins. All profiles have the right to read/view this field and certain profiles have the right to edit it. If the field is checked, it should keep anyone from creating a case. The account object does not have any insert trigger. Here is the actual debug log:
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