} When I run the Query in SOQL Editor, it says "unexpected token: AND" SELECT Id, Name, Email, ProfileId FROM User WHERE NOT(Email like '%@example.com') AND ProfileId NOT IN …

We already have a soql query to retrieve the User object (which returns the role id and profile id) was wondering if we could retrieve the RoleName and ProfileName from within the same query instea...

2 Finally we have found decision how to "rename" column in SOQL without using standart Aggregate function that requires Group by clause in the end, and unfortunately doesn`t allow to export more that …

Dec 5, 2022 · From the opportunity object, using SOQL, I want to query records which have been created x days (say 30 days) before today. I have written the following code: List<Opportunity> …

Apr 10, 2025 · The 100k character limit on the SOQL documentation page is for SOQL on its own, when written in Apex (Salesforce's proprietary, Java-like language). Since the URI length limit is 16,834 …

Oct 9, 2025 · It doesn't run a SOQL so it doesn't count against governor limits. Indeed the getAll() documentation states (emphasis mine): To iterate over the list of custom metadata type record …

Dec 26, 2016 · Can some one correct my soql? I need to export records in data loader like: WHERE Id IN ('123123123','123123fsdf') But this following query does not work for me: SELECT Id, …

Nov 9, 2018 · The LIKE operator in SOQL and SOSL supports escaping of special characters % or _. Don’t use the backslash character in a search except to escape a special character. For example, …

Nov 12, 2013 · I am looking for a way to query all leads which have the length of city__c > 20 characters in SOQL. I cant seem to find anything like a length() in SOQL. Any workarounds? Or am i missing …

Feb 25, 2015 · A SOQL alternative to selecting distinct rows: SELECT name, COUNT(Id) FROM Lead GROUP BY name Shows you all of the distinct names, with how many of them there are. One …