The way I see it, you have two options to avoid hitting or know when you are about to hit the org governor salesforce limit class. Display your message whenever you end up with 0 remaining query rows available. Write a batch that will store the number of records that object contains in a Hierarchy Custom…
Salesforce
Answered May 9, 2023
·
973 Views
Read answer →
To resolve the error: field is not writeable: user.profileid You need to check your objects settings + field settings of that object in the profile(s) of the user. You need to see if it is writeable and that the field is also editable. If not, you need to enable it. If there are more users with that profile and you…
Salesforce
Answered May 9, 2023
·
6.5K Views
Read answer →
The big thing about fieldsets Salesforce is that they're declarative. If you define a fieldset, and use that in visualforce/apex, you can change the fields that are displayed in visualforce, or processed in apex, without modifying code. This also means that, in my org, I can (safely) change behaviour in production…
Salesforce
Answered May 4, 2023
·
1.5K Views
Read answer →
I've been in your situation and there are no alternatives to VF or Blob.toPdf when generating a PDF file from HTML code. The jsPDF library has some compatibility issues with SF's LWC framework when trying to convert HTML to PDF. We ended up using the app SDocs. The free version lets you set up 1 document template with…
Salesforce
Answered May 4, 2023
·
1.1K Views
Read answer →
To resolve the [noerrorobjectavailable] script error.- This error occurred when we were using "cmp or any different value" than what is being passed in the parameter which is "component". In the second line of code, when we changed "cmp" to "component" - the error got resolved. handleSave : function(component, event,…
Salesforce
Answered Apr 19, 2023
·
4.3K Views
Read answer →
For date format salesforce data loader, remember two things about loading date types: Data loader ignores the HH:MM:SS portion of Date types, so you can just write it as YYYY-MM-DD. Reserve the HH:MM:SS for Datetime types. Data loader interprets all dates as GMT. When you look at it in the UI, you are looking at the…
Salesforce
Answered Apr 18, 2023
·
1.3K Views
Read answer →
To resolve this error - too many queueable jobs added to the queue 2, check out this use case- Given: Batch job execute() method that updates two records A and B Given a Process Builder with two decision blocks / action group pairs that execute upon changes to records A and B, respectively. That is decision block 1…
Salesforce
Answered Apr 17, 2023
·
8.7K Views
Read answer →
To update with case statement in oracle, you must understand that - A CASE expression can only return a value, not a fragment of a query.In order to parametrise which column should receive the value passed as an argument, you could try this approach: UPDATE PERSON SET FIRST_NAME = CASE WHEN TARGET_COL = 2 THEN…
SQL Server
Answered Mar 16, 2023
·
4.0K Views
Read answer →
left join vs inner join It's not the same for me, MySql 5.7 8 vCPU, 52 GB RAM The following query takes ~30 seconds, not sure why The transactions table has 24,257,151 records The activity table has 18,603,665 records The purchases table has 13,911,705 records All required indexes are in place SELECT…
SQL Server
Answered Mar 13, 2023
·
1.0K Views
Read answer →
Randy Bias chronicles the history of the term stating that it probably originated in 2011 or 2012 when Bill Baker used the analogy when describing "scale-up" vs. "scale-out" architectural strategies. Bias adopted this into his presentations about cloud architectural patterns: In the old way of doing things, we treat…
Salesforce
Answered Mar 7, 2023
·
1.1K Views
Read answer →
Assuming you want no whitespace in your result of apex string... String s = 'ABCDEF J4'; s = s.deleteWhitespace(); List subStringList = new List(); for(Integer i=0; i{'AB', 'CD', 'EF', 'J4'}, subStringList);
Salesforce
Answered Mar 2, 2023
·
1.0K Views
Read answer →
I get this a lot as I switch between customers' environments who are in different languages. I believe the test Salesforce login in the wrong language is due to your locale on your Language & Time Zone settings on your profile. So, I signed into a Dutch customer's environment and my Locale is Dutch (Netherlands).…
Salesforce
Answered Mar 2, 2023
·
950 Views
Read answer →