Apex Code Development You need to sign in to do that
Don't have an account?
Sarbashish error message when running this SOQL query
I am trying to display the account name when fetching the data from the Event table. The code works on the development environment but does not work on the live URL. The problem is with Please find the code snippet below:
<SCRIPT language=JavaScript1.2 src="/js/session.js"></SCRIPT> <SCRIPT src="/soap/ajax/8.0/connection.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/functions.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/setup.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/roletreenode.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/sfdcPage.js" type=text/javascript></SCRIPT> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<script language="JavaScript1.2" src="/js/session.js"></script>
<script src="/soap/ajax/8.0/connection.js" type="text/javascript"></script>
<script type="text/javascript" src="/js/functions.js"></script>
<script type="text/javascript" src="/js/setup.js"></script>
<script type="text/javascript" src="/js/roletreenode.js"></script>
<script type="text/javascript" src="/js/sfdcPage.js"></script>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<SCRIPT LANGUAGE="JavaScript">
<SCRIPT language=JavaScript1.2 src="/js/session.js"></SCRIPT> <SCRIPT src="/soap/ajax/8.0/connection.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/functions.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/setup.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/roletreenode.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/sfdcPage.js" type=text/javascript></SCRIPT> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<script language="JavaScript1.2" src="/js/session.js"></script>
<script src="/soap/ajax/8.0/connection.js" type="text/javascript"></script>
<script type="text/javascript" src="/js/functions.js"></script>
<script type="text/javascript" src="/js/setup.js"></script>
<script type="text/javascript" src="/js/roletreenode.js"></script>
<script type="text/javascript" src="/js/sfdcPage.js"></script>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<SCRIPT LANGUAGE="JavaScript">
var qResult = sforce.connection.query("Select Subject, What.Name, ActivityDate, Owner.FirstName FROM Event");
if (qResult.size > 0) {
var records = qResult.getArray('records');
for (var i = 0; i < records.length; i++) {
var objRS = records[i];
//document.write(objRS.Subject+" - "+objRS.ActivityDate);
//document.write(objRS.What.Name+" - "+objRS.ActivityDate);
document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name);
document.write("<br>");
}
}
</script>
var records = qResult.getArray('records');
for (var i = 0; i < records.length; i++) {
var objRS = records[i];
//document.write(objRS.Subject+" - "+objRS.ActivityDate);
//document.write(objRS.What.Name+" - "+objRS.ActivityDate);
document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name);
document.write("<br>");
}
}
</script>
<body>
</body>
</html> <SCRIPT language=JavaScript1.2 src="/js/session.js"></SCRIPT> <SCRIPT src="/soap/ajax/8.0/connection.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/functions.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/setup.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/roletreenode.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/sfdcPage.js" type=text/javascript></SCRIPT> <meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR> <meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema> <SCRIPT language=JavaScript> var qResult = sforce.connection.query("Select Subject, What.Name, ActivityDate, Owner.FirstName FROM Event"); if (qResult.size > 0) { var records = qResult.getArray('records'); for (var i = 0; i < records.length; i++) { var objRS = records[i]; //document.write(objRS.Subject+" - "+objRS.ActivityDate); //document.write(objRS.What.Name+" - "+objRS.ActivityDate); document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name); document.write("
"); } } </SCRIPT> <meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR> <meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema> <SCRIPT language=JavaScript> var qResult = sforce.connection.query("Select Subject, What.Name, ActivityDate, Owner.FirstName FROM Event"); if (qResult.size > 0) { var records = qResult.getArray('records'); for (var i = 0; i < records.length; i++) { var objRS = records[i]; //document.write(objRS.Subject+" - "+objRS.ActivityDate); //document.write(objRS.What.Name+" - "+objRS.ActivityDate); document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name); document.write("
"); } } </SCRIPT>
</html> <SCRIPT language=JavaScript1.2 src="/js/session.js"></SCRIPT> <SCRIPT src="/soap/ajax/8.0/connection.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/functions.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/setup.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/roletreenode.js" type=text/javascript></SCRIPT> <SCRIPT src="/js/sfdcPage.js" type=text/javascript></SCRIPT> <meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR> <meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema> <SCRIPT language=JavaScript> var qResult = sforce.connection.query("Select Subject, What.Name, ActivityDate, Owner.FirstName FROM Event"); if (qResult.size > 0) { var records = qResult.getArray('records'); for (var i = 0; i < records.length; i++) { var objRS = records[i]; //document.write(objRS.Subject+" - "+objRS.ActivityDate); //document.write(objRS.What.Name+" - "+objRS.ActivityDate); document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name); document.write("
"); } } </SCRIPT> <meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR> <meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema> <SCRIPT language=JavaScript> var qResult = sforce.connection.query("Select Subject, What.Name, ActivityDate, Owner.FirstName FROM Event"); if (qResult.size > 0) { var records = qResult.getArray('records'); for (var i = 0; i < records.length; i++) { var objRS = records[i]; //document.write(objRS.Subject+" - "+objRS.ActivityDate); //document.write(objRS.What.Name+" - "+objRS.ActivityDate); document.write(objRS.Subject+" - "+objRS.ActivityDate+" - "+objRS.Owner.FirstName+" - "+objRS.What.Name); document.write("
"); } } </SCRIPT>
Sarbashish
i read what you wrote but how did you pull all the data from the table.
Lets say i would like to pull all the data out from "Cases" table how can i do that with javascript and what .js file i need to include in my <head> meta tag?
can you please answer the question, that would help me out a lot.
Thank you.