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. SolutionContinue reading “Querying Distinct Values in SOQL: Approval Process Work Items”

Creating Dynamic Charts with Chart.JS – Part Two: Creating a Truly Dynamic Dashboard
User Story We have some information on our objects that we want to view in dynamic charts. These charts will update based on the object that is created by inputting a sentence into a Lightning Web Component. Background In the previous post, we started on our Lightning Web Component. We are going to use Chart.jsContinue reading “Creating Dynamic Charts with Chart.JS – Part Two: Creating a Truly Dynamic Dashboard”

Creating Dynamic Charts with Chart.JS – Part One: Palindromic Sentences
User Story This is a pretty basic Intro to JavaScript problem (and common interview and homework problem!) that we will be solving via Salesforce. We want to input a sentence or phrase and determine whether or not what we have entered is a palindrome. For kicks and giggles, we also want to count the numberContinue reading “Creating Dynamic Charts with Chart.JS – Part One: Palindromic Sentences”