Category: Salesforce

[Salesforce] Value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes

September 7th, 2023
Reading Time: 2 minutes
To filter records by date in SOQL (Salesforce Object Query Language), you can use the comparison operators such as “=”, “<“, “<=”, “>”, “>=”, and “!=”. However a common mistake we made is to enclose the date with quotes like the following query:
```
SELECT Id, Name FROM Account WHERE CreatedDate < '2023-09-03' LIMIT 10
```
As soon as you execute it, you get this error:
```
INVALID_FIELD: 
SELECT Id, Name FROM Account WHERE CreatedDate < '2023-09-03' LIMIT
                                   ^
ERROR at Row:1:Column:36
value of filter criterion for field 'CreatedDate' must be of type dateTime and should not be enclosed in quotes
```
However if we remove the quotes we will get the same error
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03 LIMIT 10
```
To resolve the error “value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes” in Salesforce, you need to make the following adjustments to your SOQL query:
1. Remove the single quotes around the date value.
2. Use the correct format for the date value by appending the time ‘T23:59:59Z’ , ‘T00:00:00Z ‘ or the hour you need at the end.
By following these steps, your query will correctly compare the ‘CreatedDate’ field to the specified date and time, without encountering the type mismatch error so the right query will be:
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03T23:59:59Z LIMIT 10
```
Another example:
```
SELECT Id, Name FROM Account WHERE CreatedDate < 2023-09-03T00:00:00Z
```
In the above example, we are querying the Account object and filtering records where the CreatedDate is less than September 3, 2023, at 00:00:00 (midnight) UTC. You can modify the date and time values according to your specific requirements. Ensure that the date and time format follows the YYYY-MM-DDThh:mm:ssZ pattern, where T separates date and time, and Z indicates the timezone as UTC. Remember, using the correct date and time format is essential in SOQL to accurately filter out records based on dates.
Share this:
Twitter
LinkedIn
Reddit
Email
Telegram
WhatsApp
Like this:
Like Loading…
What does a Salesforce Software Engineer do?

September 3rd, 2023
Reading Time: 3 minutes
Salesforce is a customer relationship management (CRM) platform that allows businesses to manage their interactions with customers and prospects. It provides various tools and features to help organizations streamline their sales, marketing, and customer service processes. With Salesforce, businesses can track customer data, manage sales opportunities, create and automate marketing campaigns, and provide efficient customer support. The platform offers customization options, allowing businesses to tailor it according to their specific needs. Salesforce is widely used in various industries and is known for its flexibility, scalability, and extensive range of integrations with other systems and applications.

As a Salesforce Engineer, you would be responsible for building custom solutions on the Salesforce platform using its proprietary programming language, Apex, and its declarative customization tools Validation Rules, Quick Actions, Page Layouts, Approval Processes, Formula Fields, Flows, among other.

Salesforce development is a highly in-demand skill in the current job market, as more and more businesses are adopting the Salesforce platform to manage their customer relationships.

To be a successful Salesforce Engineer, you should have a strong background in programming, as well as experience with object-oriented programming concepts. You should also have a good understanding of the Salesforce platform, including its architecture, data model, and security model. Additionally, it can be helpful to have experience with other programming languages, such as Java or .NET, as well as experience with web development technologies like HTML, CSS, and JavaScript.

Here are some key responsibilities of a Salesforce Software Engineer:
1. Customization and Development: Salesforce Software Engineers build custom applications and functionalities on the Salesforce platform using Apex, Visualforce pages, or Lightning Components. They work closely with stakeholders to understand requirements and create solutions that align with business objectives.
2. Integration: Salesforce Software Engineers integrate Salesforce with other systems and technologies, such as ERP systems, marketing automation platforms, or custom APIs. They ensure seamless data flow between systems and create automated processes to improve efficiency.
3. Testing and Debugging: Salesforce Software Engineers write test cases and debug issues in existing Salesforce solutions. They ensure the quality and reliability of applications by conducting thorough testing and resolving any bugs or errors.
4. Collaboration: Salesforce Software Engineers collaborate with cross-functional teams, including business analysts, project managers, and quality assurance testers. They actively participate in discussions and meetings to gather requirements, provide technical expertise, and deliver solutions that meet the needs of the business.
5. Continuous Improvement: Salesforce Software Engineers stay updated with the latest Salesforce features, releases, and best practices. They continuously enhance their skills and knowledge to leverage new functionalities and improve the overall development process.
In summary, a Salesforce Software Engineer combines their programming expertise with Salesforce knowledge to build, customize, integrate, and maintain software solutions on the Salesforce platform. They play a crucial role in helping businesses optimize their customer relationship management processes and achieve their goals.

Speaking of continuous improvement… Salesforce Trailhead is a highly recommended platform for anyone looking to learn or expand their knowledge of Salesforce. Whether you are a beginner or an experienced professional, Trailhead provides a gamified and interactive learning experience that can help you gain practical skills and advance your career.

Here are a few reasons why you should consider using Salesforce Trailhead:
1. Free and Accessible: Trailhead is completely free to use and accessible to anyone with an internet connection. You can access a wide range of tutorials, modules, projects, and challenges at no cost, making it an excellent resource for learning Salesforce.
2. Hands-on Learning: Trailhead focuses on providing a hands-on learning experience, allowing you to apply what you learn in a practical way. With interactive exercises, quizzes, and challenges, you can gain real-world skills and experience while progressing through the learning modules.
3. Structured Learning Paths: Trailhead offers guided learning paths, known as “trails,” that are designed to help you learn specific topics or achieve certain certifications. These trails provide a structured learning experience, making it easier to navigate through the vast amount of content available and ensure you cover all the necessary topics.
4. Gamified Experience: Trailhead gamifies the learning process, making it engaging and fun. You earn badges and points for completing modules and challenges, allowing you to track your progress and showcase your accomplishments to potential employers or colleagues.
5. Community Support: Trailhead has a vibrant community of learners and experts who are ready to assist you. You can participate in discussion forums, connect with peers, and seek help from experienced professionals to enhance your learning experience.
6. Career Advancement: Salesforce skills are highly in-demand in the job market. By completing Trailhead modules and earning certifications, you can demonstrate your knowledge and expertise to potential employers. Trailhead offers learning paths specifically tailored to different roles, such as developers, administrators, or consultants, helping you advance in your Salesforce career.
In summary, Salesforce Trailhead is an excellent learning platform that provides a free, hands-on, and fun learning experience. Whether you are new to Salesforce or looking to expand your skills, Trailhead can be a valuable resource to enhance your knowledge and advance your career in the world of Salesforce.
Share this:
Twitter
LinkedIn
Reddit
Email
Telegram
WhatsApp
Like this:
Like Loading…
How to unit test Flows in Salesforce with Apex

September 3rd, 2023
Reading Time: 3 minutes
By performing unit tests you can ensure that your rules are error-free, functioning properly, and enforcing the intended business logic. This ultimately leads to a more robust and reliable code.

In Salesforce, a Flow is a powerful tool that allows you to automate business processes by visually designing and executing a series of actions, known as a Flow. It serves as a declarative way to build and automate complex business logic without writing custom code.

A Flow consists of multiple elements, such as screens, variables, decisions, loops, assignments, and more, which are used to define the behavior and functionality of the process. You can think of it as a sequence of steps that guide users or make automated decisions based on specified criteria.

Overall, Flows provide a flexible and intuitive way to automate business processes in Salesforce without writing code. They allow you to streamline workflows, guide users, make decisions, update records, and perform various other actions to achieve your desired automation goals.

Unit testing Flows in Salesforce with Apex is crucial for several reasons:
1. Error prevention: Unit tests help identify errors or issues in Flows before they are deployed to a production environment. By catching and fixing errors early on, you can prevent potential data integrity issues and ensure the accuracy of your Flows.
2. Increased confidence: Unit tests give you confidence that your Flows are working as intended. By systematically testing different scenarios, you can validate that the Flows are correctly processing data and executing the desired functionality.
3. Regression testing: Unit tests act as a safety net when making changes to existing Flows. Whenever a change is made, these tests can be re-run to ensure that the modifications haven’t inadvertently broken any existing functionality.
4. Documentation: Unit tests serve as living documentation that demonstrates and validates how your Flows should behave. They allow developers and administrators to understand the expected behavior of the Flows and ensure consistent behavior across different deployments or instances.
5. Facilitates collaboration: Unit tests promote collaboration between developers and administrators by providing a clear understanding of the purpose and behavior of the Flows. This enables better communication and collaboration when discussing requirements or troubleshooting issues related to the Flows.
To unit test Flows in Salesforce using Apex, you can follow these steps:
1. Identify the Flow you want to test: Determine the specific Flow you need to create unit tests for.
2. Prepare test data: Create or gather test data that represents different scenarios within the Flow. This includes the input variables that the Flow relies on.
3. Create an Apex test class: In Salesforce, create an Apex test class to test your Flow. The test class should be annotated with @isTest.
4. Trigger the Flow by, for example, saving a record with some particular data. Make sure you wrap this section of the test with Test.startTest(); and Test.stopTest();
5. Assert the outcome: Access the Flow’s output variables and assert that their values match the expected results. You can use Apex assertions such as System.assertEquals to compare expected and actual values.
6. Run the test class: Execute the test class to run the unit tests for your Flow. You can run the tests using the Developer Console or Salesforce CLI.
It’s not recommended you test different scenarios in the same test. As a good practice, create one method for every scenario you want to test.

Unfortunately, until now you don’t have a way to know how well the Flow is covered so you won’t be able to know if you tested every scenario in the Flow.

By following these steps, you can effectively unit test Flows in Salesforce using Apex. This helps ensure that your Flows function as expected and handle different scenarios correctly.
Share this:
Twitter
LinkedIn
Reddit
Email
Telegram
WhatsApp
Like this:
Like Loading…
How to parse json in Salesforce Apex

February 23rd, 2023
Reading Time: < 1 minutes

Parsing JSON in Salesforce Apex is an important part of salesforce development and is used to integrate data into Salesforce. In this post, we will learn how to parse JSON in Apex to consume external API data in Salesforce.

JSON (JavaScript Object Notation) is a text-based data interchange format that is used to transmit, transport and store data. It is commonly used to exchange data between web applications, client and server endpoints, database systems and more.

The best way to parse JSON data

Let’s see an example:
```
public class MyClass {
        public String field1;
        public String field1;

        public static MyClass parse(String json) {
            return (MyClass) System.JSON.deserialize(json, MyClass.class);
        }
}
```
More examples here
Share this:
Twitter
LinkedIn
Reddit
Email
Telegram
WhatsApp
Like this:
Like Loading…

Category: Salesforce

[Salesforce] Value of filter criterion for field ‘CreatedDate’ must be of type dateTime and should not be enclosed in quotes

Share this:

Like this:

What does a Salesforce Software Engineer do?

Share this:

Like this:

How to unit test Flows in Salesforce with Apex

Share this:

Like this:

How to parse json in Salesforce Apex

Share this:

Like this: