I've ran into a strange issue I haven't seen before when using a Javascript remote function to return the results of a query..
I have a method that returns the results of a query on the Opportunity object:
@RemoteAction
Public static AggregateResult[] myOppsQuery {
List<AggregateResult> ar = [Select Calendar_Quarter(CloseDate)Quarter, Sum(Commissionable_Margin__c)Margin from Opportunity where CloseDate = THIS_YEAR AND isWon = TRUE Group By Calendar_quarter(CloseDate) Order by Calendar_quarter(CloseDate)];
return ar;
}
When this method is invoked by the javascript remote function the results I am getting differ from the results of the query by itself. Copy/pasting the query from the method into SoqlXplorer returns the correct value, but the javascript remote function results are not the same.
Is there some sort of caching of a previous value going on here? I've cleared browser cache + tried different browsers but the issue persists.
Thanks in advance for taking a look at this - any assistance is greatly appreciated.
I have a custom VF page that I want all user profiles to view with the exception of two profiles. I have tried using || and an Else If statement to accomplish this but I receive errors for both.
I'm creating a page that is bound to a Case Standard Controller and I've created an extension to modify the "New Case" creation process. I want the users to be able to upload an attachment while filling out the New Case details but I've come across an issue. Here is the extension:
public class CaseExt{
public ApexPages.StandardController controller {get;set;}
public Case c {get;set;}
public String userEmail;
Public Attachment a {get;set;}
public CaseExt(ApexPages.StandardController con){
controller = con;
c = (Case) controller.getRecord();
a = new Attachment();
userEmail = userInfo.getUserName();
}
public PageReference save(){
List<Contact> cnt = [SELECT Id, Email, Name FROM Contact WHERE Email =: userEmail];
if (cnt.size() < 1) {
ApexPages.Message msg = new ApexPages.Message(ApexPages.Severity.WARNING, 'Your email address does not match our records. Please update your contact information.');
ApexPages.addMessage(msg);
return null;
} else {
try {
c.ContactId = cnt.get(0).Id;
INSERT c;
a.ParentId = c.Id;
INSERT a;
return page.CaseThankYou;
}catch (Exception e){
ApexPages.addMessages(e);
return null;
}
}
}
}
The issue I'm seeing is that when I save the record the attachment doesn't appear to be added to the case.. I can't seem to figure out why. Any help or recommendations are greatly appreciated.
I've ran into a strange issue I haven't seen before when using a Javascript remote function to return the results of a query..
I have a method that returns the results of a query on the Opportunity object:
@RemoteAction
Public static AggregateResult[] myOppsQuery {
List<AggregateResult> ar = [Select Calendar_Quarter(CloseDate)Quarter, Sum(Commissionable_Margin__c)Margin from Opportunity where CloseDate = THIS_YEAR AND isWon = TRUE Group By Calendar_quarter(CloseDate) Order by Calendar_quarter(CloseDate)];
return ar;
}
When this method is invoked by the javascript remote function the results I am getting differ from the results of the query by itself. Copy/pasting the query from the method into SoqlXplorer returns the correct value, but the javascript remote function results are not the same.
Is there some sort of caching of a previous value going on here? I've cleared browser cache + tried different browsers but the issue persists.
Thanks in advance for taking a look at this - any assistance is greatly appreciated.
I'm creating a page that is bound to a Case Standard Controller and I've created an extension to modify the "New Case" creation process. I want the users to be able to upload an attachment while filling out the New Case details but I've come across an issue. Here is the extension:
public class CaseExt{
public ApexPages.StandardController controller {get;set;}
public Case c {get;set;}
public String userEmail;
Public Attachment a {get;set;}
public CaseExt(ApexPages.StandardController con){
controller = con;
c = (Case) controller.getRecord();
a = new Attachment();
userEmail = userInfo.getUserName();
}
public PageReference save(){
List<Contact> cnt = [SELECT Id, Email, Name FROM Contact WHERE Email =: userEmail];
if (cnt.size() < 1) {
ApexPages.Message msg = new ApexPages.Message(ApexPages.Severity.WARNING, 'Your email address does not match our records. Please update your contact information.');
ApexPages.addMessage(msg);
return null;
} else {
try {
c.ContactId = cnt.get(0).Id;
INSERT c;
a.ParentId = c.Id;
INSERT a;
return page.CaseThankYou;
}catch (Exception e){
ApexPages.addMessages(e);
return null;
}
}
}
}
The issue I'm seeing is that when I save the record the attachment doesn't appear to be added to the case.. I can't seem to figure out why. Any help or recommendations are greatly appreciated.
