I cant seem to reference Contact.AccountId as a merge field in a s-control. When I do I get the errror: "Field Contact.AccountId does not exist. Check spelling."
I also noticed that it isnt available from the merge field insert dropdown although I can definately see this field in Apex Explorer.
I am basically trying to use it in a query like so:
Have written a s-control that returns a formatted list of assets for the account associated with a case. I have hit a problem where no results are displayed if there is only one result returned. >1 results render fine.
Code:
<html>
<head>
<script src="/soap/ajax/10.0/connection.js"></script>
<script>
function initPage() {
var result = sforce.connection.query("Select Id, Name, Quantity, Support_Level__c, UsageEndDate from Asset Where AccountId = '{!Case.AccountId}' and UsageEndDate > today ");
var sb = new sforce.StringBuffer();
sb.append("<b>Current Assets for {!Account.Name}</b><br>");
sb.append("<hr>");
sb.append("<center><table width=90%><tr><td>Name</td><td>Qty</td><td>Support Level</td><td>End Date</td></tr>");
while (true) {
if (result.size > 0) {
for (i = 0; i < result.records.length; i++) {
var account = result.records[i];
sb.append("<tr>"); //<td>").append(i).append("</td>");
sb.append("</td><td> ").append(account.Name);
sb.append("</td><td> ").append(account.Quantity);
sb.append("</td><td><center> ").append(account.Support_Level__c);
sb.append("</td><td> ").append(account.UsageEndDate);
sb.append("</td></tr>");
}
}
if (result.done == "true") {
break;
} else {
result = sforce.connection.queryMore(result.queryLocator);
}
}
sb.append("</table>");
document.body.innerHTML = sb.toString();
}
</script>
</head>
<body onload="initPage();">
</body>
</html>
I am able to update standard fileds in cases wihtout issue. I cannot, however get custom fields to update.
When I do a getLastRequest I cannot even see my custom fields referenced in the SOAP call. Someone please point me in the right direction on updating custom fields through the Enterprise 1.1 api.
I am quite sure I am doing something stupid but i cant seem to get past this error. I am using the Enterprise SOAP client of the new 1.1 toolkit for PHP and am trying to update this object:
I cant seem to reference Contact.AccountId as a merge field in a s-control. When I do I get the errror: "Field Contact.AccountId does not exist. Check spelling."
I also noticed that it isnt available from the merge field insert dropdown although I can definately see this field in Apex Explorer.
I am basically trying to use it in a query like so:
Have written a s-control that returns a formatted list of assets for the account associated with a case. I have hit a problem where no results are displayed if there is only one result returned. >1 results render fine.
Code:
<html>
<head>
<script src="/soap/ajax/10.0/connection.js"></script>
<script>
function initPage() {
var result = sforce.connection.query("Select Id, Name, Quantity, Support_Level__c, UsageEndDate from Asset Where AccountId = '{!Case.AccountId}' and UsageEndDate > today ");
var sb = new sforce.StringBuffer();
sb.append("<b>Current Assets for {!Account.Name}</b><br>");
sb.append("<hr>");
sb.append("<center><table width=90%><tr><td>Name</td><td>Qty</td><td>Support Level</td><td>End Date</td></tr>");
while (true) {
if (result.size > 0) {
for (i = 0; i < result.records.length; i++) {
var account = result.records[i];
sb.append("<tr>"); //<td>").append(i).append("</td>");
sb.append("</td><td> ").append(account.Name);
sb.append("</td><td> ").append(account.Quantity);
sb.append("</td><td><center> ").append(account.Support_Level__c);
sb.append("</td><td> ").append(account.UsageEndDate);
sb.append("</td></tr>");
}
}
if (result.done == "true") {
break;
} else {
result = sforce.connection.queryMore(result.queryLocator);
}
}
sb.append("</table>");
document.body.innerHTML = sb.toString();
}
</script>
</head>
<body onload="initPage();">
</body>
</html>
I am able to update standard fileds in cases wihtout issue. I cannot, however get custom fields to update.
When I do a getLastRequest I cannot even see my custom fields referenced in the SOAP call. Someone please point me in the right direction on updating custom fields through the Enterprise 1.1 api.
I am quite sure I am doing something stupid but i cant seem to get past this error. I am using the Enterprise SOAP client of the new 1.1 toolkit for PHP and am trying to update this object:
Just wondering about support for the new v8 API in PHP... Is there a pre-release of the new PHP toolkit, or indeed, is Salesforce even writing one? Any timeline on it's release?
Currently we're using Person Accounts to co-ordinate our B2I records. All of our support scripts are written in PHP and I'm not overly keen on having to create a sub-set of these in JSP (or whatever).
