-
Utilizing the Tooling API to Query Deployment Information
User Story Today we are going to cover a worst case scenario. Something was deployed to Production that shouldn’t have been, but we don’t know which deployment holds the answer. The UI for deployments is clunky and doesn’t allow us to see who deployed what without clicking into the individual deployment. This is a hassle,…
-
Regular Expression to Escape SOQL/SOSL Inputs
User Story We want to create a table with search, sort, and pagination functionality. Over the course of the next several posts, we are going to look at two possible ways to achieve this, with either server-side or client-side functionality. We will start with the basics of searching: writing our queries. If you would like…
-
Width-Aware Collapsible Table
User Story We want to create a lightning__RecordPage component that displays a table that looks different whether it is in a main region or a sidebar, which means that, by default, the component is responsive and mobile friendly. For this example, we will be using the relationship between the Account and Contact objects in Salesforce…
-
Querying Distinct Values in SOQL: Approval Process Work Items
User Story We want to get a list of approval processes that have work items that are dependent on a user that is no longer active, and we want to do it without using Apex. Background There is no DISTINCT function in SOQL, so we’re going to have to do some Aggregate Query magic. Solution…
Another Salesforce Blog 