Salesforce Trace Log Query Using Apex

By

To activate debug logging for users, Apex classes, and Apex triggers, configure trace flags and debug levels in the Developer Console or in Setup. Each trace flag includes a debug level, start time, end time, and log type. The trace flag’s log type specifies the entity you’re tracing.

You can navigate to Setup->Debug then you will see the below screen for trace logs configured in your instance.








If you want to query Trace Log for your instance using Apex then you can use following SOQL query for the same. But please check API Tooling checkbox in developer console while querying.

1. To Query all trace log

 SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling,
Callout, Database, System, Validation, Visualforce, Workflow FROM TraceFlag

2. To Query trace log only for class

 SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling,
Callout, Database, System, Validation, Visualforce, Workflow FROM TraceFlag where LogType='CLASS_TRACING'

3. To Query trace log only for Developer console

 SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling,
Callout, Database, System, Validation, Visualforce, Workflow FROM TraceFlag where LogType='DEVELOPER_LOG'

4. To Query trace log only for USER

 SELECT Id, CreatedDate, CreatedById, ExpirationDate, LogType,TracedEntityId,TracedEntity.Name, ApexCode, ApexProfiling,
Callout, Database, System, Validation, Visualforce, Workflow FROM TraceFlag where LogType='USER_DEBUG'

For other Fields, you can refer below salesforce URL.
https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_traceflag.htm

Have almost 7 years of experience and expertise in Core Java, JDBC, Servlet, JSP, Java Web Services and Struts, Oracle Database, MS SQL Server,Apex,Visual Force,Force.com platform. Good Experience on Oracle CRM ON DEMAND, Sales force CRM with ability to work independently and in a team environment. Good Analytical & Reasoning skills. Strongly creative in learning new technologies and systems, extremely passionate to work in a challenging place. Apart from that, I have very vast experience in integration and data migration from one system to other system. Certifications: 1. Salesforce Certified Platform Developer I 2. Salesforce Certified Administrator 3. Salesforce Certified Sales Cloud Consultant 4. Salesforce Certified Service Cloud Consultant 5. Oracle Certified Java Developer 6.Oracle Certified Web Component Developer 7. Oracle Certified SQL Associate

Comments

Post a Comment

Popular posts from this blog

System.AsyncException: The Apex job named is already scheduled for execution.

By
System.AsyncException: The Apex job named is already scheduled for execution. Hi All, When i was trying to schedule my class for every 15 miuntes to run. I was getting below error. System.AsyncException: The Apex job named "Global App Logs Purge" is already scheduled for execution. e.g. Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 15 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 30 * * * ? *', globalPurgeBatchSchedular); System.schedule(' Global App Logs Purge ', '0 45 * * * ? *', globalPurgeBatchSchedular); When i change the all the 4 job name from " Global App Logs Purge " to "Global App Logs Purge 1 ","Global App Logs Purge 2 ","Global
Read more

Custom Setting Creation in Apex Test Class

By
Please refer following approach to insert/update custom setting record in test class. @isTest(SeeAllData=FALSE) private class YouTestClass {     //Initialize custom settings to prevent test failures     // replace Dreamhouse_Settings__c  = your custom setting name     private static Dreamhouse_Settings__c customSettingInstance;       static {         customSettingInstance = new Dreamhouse_Settings__c ();         customSettingInstance. LIFX_Token__c = '';         upsert customSettingInstance;     }       static testMethod void yourTestMethod() {               Test.startTest();         //Your unit test here         Test.startTest();     } } I hope this will help you.
Read more

Error : "Trigger must be associated with a job detail"

By
Error : "Trigger must be associated with a job detail" Hi All, I was just trying to schedule my schedulable class ' Schedular_GlobalAppLogPurgeBatch ' in Apex. That time I was facing this error. Error : "Trigger must be associated with a job detail" e.g. Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); you can notice there is a space after " Global App Logs Purge ", when I removed this extra space from the name (" Global App Logs Purge ") my class was scheduled as expected. Corrected Space from code: Schedular_GlobalAppLogPurgeBatch globalPurgeBatchSchedular = new Schedular_GlobalAppLogPurgeBatch(); System.schedule(' Global App Logs Purge ', '0 0 * * * ? *', globalPurgeBatchSchedular); I hope this will help you.
Read more

AJAX Toolkit Debug Shell

By
You want to browse through the fields, attributes, and relationships of every object in your Salesforce.com organization. There are lots of ways to do this. But I feel productive when I use Ajax Toolkit Debug Shell. To navigate to the Ajax Toolkit Debug shell you please follow the below steps. Step 1: You need to navigate to below URL depending on your environments. Sandbox:  https://test.salesforce.com/soap/ajax/15.0/debugshell.html Production:  https:/login.salesforce.com/soap/ajax/15.0/debugshell.html Developer:  https:/login.salesforce.com/soap/ajax/15.0/debugshell.html Step 2: if it asks you to login then please execute below the line with your credentials. sforce.connection.login("MyName@myISP.com", "myPassword") Step3: To query field of Account, please fire below query. sforce.connection.describeSObject("Account")
Read more

how to get object name from id / prefix value in salesforce

By
Standard and Custom Objects in Salesforce have three character prefixes which form the first part of the record ID.  For example, a User record with ID 00561000000Mjya has the prefix 005, which is the prefix for the User object.  To get an Id from RecordId / Record Prefix, you can use below class. ---------------------------------------------------------------------------------------------------- public class SchemaGlobalDescribe{     public static String findObjectNameFromRecordIdPrefix (String recordIdOrPrefix){         String objectName = '';         try{             //Get prefix from record ID             //This assumes that you have passed at least 3 characters             String myIdPrefix = String.valueOf(recordIdOrPrefix).substring(0,3);                           //Get schema information             Map<String, Schema.SObjectType> gd =  Schema.getGlobalDescribe();                            //Loop through all the sObject types returned by Schema
Read more

How to Query All the batch classes in your Salesforce Instance using APEX

By
You can use the following scripts to know the batch classes in your Salesforce instance. List asyncApexJobList = [select ApexClassId, Id, JobItemsProcessed, JobType, Status, NumberOfErrors, MethodName from AsyncApexJob where JobType in ('BatchApexWorker','BatchApex')]; List idList = new List (); for(AsyncApexJob eachRecord:asyncApexJobList){ idList.add(eachRecord.ApexClassId); } List apexClassList = [Select Name from ApexClass where Id IN:idList]; for(ApexClass eachApexClass : apexClassList){ System.debug(eachApexClass.Name); } Additionally, You can use above to get all schedulable and other classes by adding the JobType filter. The possible values for JobType are: Future SharingRecalculation ScheduledApex BatchApex BatchApexWorker TestRequest TestWorker ApexToken Queueable Also, you can use the above script to find the status of the job as well by adding a filter on AsyncApexJob. Type. The possible values are: Holding Queued P
Read more

Creating Salesforce Developer Account

By
Image
To start with any technology/language, we need to setup environment first. As far as salesforce development environment is concerned, we no need to install anything locally to start with. You just need to provide basic information about you and you will get salesforce environment with username and password. In addition, you can access this environment any where if you have any browser like google chrome , IE or any other browser with internet.  Step 1 : Please click below link to get the salesforce environment. After clicking below url, you see the following page. Once you are able to register successfully then you will get an activation link to your provided email in order to reset the password.  https://developer.salesforce.com/signup Step 2 : Once you reset your password, it will redirect you to salesforce login page. In case, it is not redirecting due to any reason then you can click below link to login to salesforce. The login page will look like as below. 
Read more

Creating MAP from SOQL Query

By
Please use below syntax to get Map from SOQL. Map<ID, Contact> contactIdMap= new Map<ID, Contact>([SELECT Id, LastName FROM Contact]); Returns a set that contains all the keys in the map. Set <Id> listOfIds = contactIdMap.ketSet(); Returns a list that contains all the values in the map. List<Contact> contactList = contactIdMap.Values(); I hope this will help you. Reference URL https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_map_sobject.htm
Read more

Custom Pagination Without Controller (Apex)

By
You can see the use below VF code without any controller to get paginated records of any Standard object /Custom object.. -----------------------VF Code Without Controller-------------------- <apex:page standardController="Account" recordSetVar="accounts" sidebar="false"> <apex:form > <apex:pageBlock > <apex:pageMessages /> <apex:pageBlockButtons > <apex:commandButton value="Save" action="{!save}"/> <apex:commandButton value="Return" action="{!cancel}"/> </apex:pageBlockButtons> <apex:pageBlockTable value="{!accounts}" var="s" id="table" rows="20"> <apex:column headerValue="Account Name"> <apex:outputField value="{!s.Name}"/> </apex:column> </apex:pageBlockTable> <!-- To See the below link(Next,Previous,First,Last), Y
Read more