You need to sign in to do that
Don't have an account?
Ravindar Admin
Updating of many records using Formula field meets any governor limits?
I am Trying to create a report on Object__c. So I am trying to use user custom field(projectName__c) value in custom object field(projectName__c) in filter in Reports.
For that, I got a suggestion to do like below, and filter with Boolean.
Create a formula field in the custom object which is checkbox type and formula will be IF(projectName__c=user.projectName__c,true,false)
And create a report where apply filter forumulaField__c = true.
So, This is working fine. But When I change projectName__c, The all same projectName__c record's will be updated. If I change it to another project again records will be updated. I will have 10 Lakhs records in my application, presently I am using developer account.
Does This updating on 10 lakhs records meets any governor limits?
This help will be very Glad.
Thank you.
For that, I got a suggestion to do like below, and filter with Boolean.
Create a formula field in the custom object which is checkbox type and formula will be IF(projectName__c=user.projectName__c,true,false)
And create a report where apply filter forumulaField__c = true.
So, This is working fine. But When I change projectName__c, The all same projectName__c record's will be updated. If I change it to another project again records will be updated. I will have 10 Lakhs records in my application, presently I am using developer account.
Does This updating on 10 lakhs records meets any governor limits?
This help will be very Glad.
Thank you.
Technically, formula fields are calculated at runtime. Updating an underlying field value does not run an update operation on a formula field.
So, you don't really have to worry about the SOQL governor limits on this activity.
Hope this helps.
All Answers
Technically, formula fields are calculated at runtime. Updating an underlying field value does not run an update operation on a formula field.
So, you don't really have to worry about the SOQL governor limits on this activity.
Hope this helps.
Based on the projectName__c of user and object__c. I am updating another formula check box field.
IF(projectName__c=user.projectName__c,true,false).
Then creating the report where apply filter forumulaField__c = true.