How to Properly Use Static Variables in Apex Dynamic Queries?

Question

Issue with Using Static Variables Directly in Dynamic Queries

When working with dynamic queries in Apex using Database.query(), you may run into an issue when trying to reference a static variable from another class directly in the query. The following code works as expected:

static Id x = LocalUserInfo.currUserId;
System.debug(x);
User u = Database.query('select Id, Name from User where Id = :x');

However, if you try to use the static variable directly in the query like this:

User u = Database.query('select Id, Name from User where Id = :LocalUserInfo.currUserId');

You will get an error: 'System.query.Exception. Variable does not exist: LocalUserInfo.currUserId'.

Launch your Salesforce career with hands-on  Salesforce training in Hyderabad. Gain job-ready skills through real-world projects and join our free demo session..!

Why Does This Error Occur?

The issue arises because Apex does not allow direct references to static variables from other classes in dynamic queries. Apex requires that values used in dynamic queries be properly bound to the query. This means you cannot simply reference the static variable directly in the query string.

Answer

Solution: Using queryWithBinds Method

To fix this issue, you can use the queryWithBinds method, which allows you to bind the static variable to the dynamic query.

Here’s the correct implementation:

String query = 'select Id, Name from User where Id = :currUserId';
Map<String, Object> binds = new Map<String, Object>{'currUserId' => LocalUserInfo.currUserId};
User u = Database.queryWithBinds(query, binds, AccessLevel.USER_MODE);

In this solution, you define the query string separately and then use a Map to bind the static variable LocalUserInfo.currUserId to the query. This approach allows Apex to correctly handle the static variable and execute the query without errors.

Summary

• Directly using static variables from another class in dynamic queries will result in an error.
• Use the queryWithBinds method to bind the static variable properly to the dynamic query.
• This ensures that the query works as expected, using the static variable’s value in the query.

Salesforce Training in Hyderabad – Boost Your Career Today!

With personalized mentorship, interview coaching, and thorough certification exam preparation, our Salesforce training ensures you’re prepared for the competitive job market. Gain hands-on project experience, access detailed study materials, and receive continuous support to build confidence and expertise. Start your Salesforce journey today and unlock exciting career opportunities!

Our  Salesforce training in Hyderabad offers a deep, immersive learning experience, equipping you with essential skills for success in the CRM industry. The program covers Salesforce Admin, Developer, and AI domains, blending theoretical knowledge with hands-on, real-world applications. Through industry-focused projects, you’ll solve complex business challenges using Salesforce solutions. Expert instructors will guide you in enhancing both your technical skills and understanding of the CRM ecosystem.

Take the first step toward a rewarding Salesforce career—sign up for a FREE demo session now..!!