Apex error – ‘List has no rows for assignment to SObject’

The error “List has no rows for assignment to SObject” occurs when query doesn’t return any rows. Resolution   While a SELECT normally returns an array/list, these statements are using the shorthand syntax that assumes only one row is returned. What’s not obvious is that it also assumes that exactly one row is returned! Although this is …

Apex error – ‘List has no rows for assignment to SObject’ Read More »

Custom Live Chat Using Salesforce Live Chat REST API

PREFACE We may choose to build a custom live chat app using Salesforce Live Chat REST API. There may be below given reasons or any specific reasons: Custom Experience:- Header, Footer, Navigation, Offline Form, Pre-chat Form Security Reason:- Salesforce generated embedded service snippet code does not require authentication and works publicly. Also, the script may …

Custom Live Chat Using Salesforce Live Chat REST API Read More »

Maximum SOQL offset allowed is 2000 for Pagination

Salesforce Help Article There is a help article suggested by Salesforce: https://help.salesforce.com/articleView?id=000339353&type=1&mode=1. However, there are some good ways to use this. PK Chunking – the one we used to use Bulk API For example, let’s say you enable PK chunking for the following query on an Account table with 10,000,000 records. SELECT Name FROM Account …

Maximum SOQL offset allowed is 2000 for Pagination Read More »

How to get IP Address of Community User – Guest and Logged in Customer User

DESCRIPTION Tracing IP address of community is utmost requirement to achieve different goals like geo based technical support, spam protection and other security things. There are bunch of forum discussions related to this: https://developer.salesforce.com/forums/?id=9062I000000g56rQAA https://salesforce.stackexchange.com/questions/145145/how-to-get-ip-address-of-current-user-in-lightning-component https://salesforce.stackexchange.com/questions/246085/how-to-get-the-public-ip-address-of-current-user-in-lightning-component-hosted-o/246087 APPROACHES In order to solve this, simple approach is to get the IP address and store in any custom …

How to get IP Address of Community User – Guest and Logged in Customer User Read More »