Need help on SOQL to query all related child case records
I can query the child cases for current case by something like below,
case
How to create the case with an attachment and topics using Test class?
I want to create a case which has an attachment, Billing Account, and topics. Given below is the code from my Test Class:
How can we retrieve “Case Status” picklist values marked as “Closed” in setup?
I’ve marked multiple Case Status picklist values as “Closed”, and now I want to access only those picklist values which are marked as Closed in Apex class. I tried looking for this in documentation but could not find any thing.
How can I change a group_concat column that’s left joined with another table to empty string instead of null when there are no matching records?
I’ve been trying to get a MySQL query that uses a left join combined with a group_concat to get the Amazon S3 paths of all of the profile photos for a given user. What I want is for the photo_keys aggregate column that’s the result of the group_concat() function to become an empty string instead of null when the user has no profile pics.
MySQL Case Statement with LIKE for string
I have a table with an existing user_agent column that I want to make a new column based on if user agent contains the substrings 'windows' or 'os x' in MySQL and I can’t figure out what is wrong or find examples of case statements with LIKE for strings on this site. My version of MySQL is 8.0.26.
Date split in columns in mysql
I have an events executed table wherein I want to separate columns based on the dates
How to get count and sum with multiple parameter in case when
I have the following table in MySQL (Version – 5.7.18-log).
CASE statement after WHERE then one of several values can be NULL?
I have such select:
Stored Procedure with mutliple conditions in CASE -> not working as intended [MYSQL]
I have a stored procedure I’m trying to create in MySQL that takes 5 parameters and returns the result of a query. I’m using CASE/WHEN to differentiate between each query, however, when I run the Stored Procedure: nothing returns.
Trying to do two MySQL Calculation based on value of one column
I have a select statement but want to evaluate one column, if it contains value of 584. I am trying to create a new calculation column called total by multiplying 3 other columns, if not 584 then calculate based on different columns select CASE `d2c_3_csg_batch_in`.`transactioncode` AS `transactioncode`, `d2c_3_csg_batch_in`.`site` AS `site`, `d2c_3_csg_employees`.`lastname` AS `lastname`, `d2c_3_csg_employees`.`firstname` AS … Read more