I am getting 'core.apexpages.exceptions.ApexPagesHandledException: Object type not accessible. Please check permissions and make sure the object is not in development mode: Opportunity WHERE ( ((Fiscal = Q3)) ) ORDER BY Name ASC LIMIT ^ ERROR at Row:1:Column:306 Bind variables only allowed in Apex code ' exception when I used StandardSetController. I have not used any SOQL query still getting this error, getting this error only for one list view (Q3 opps where Fiscal period is Q3), but for the other list views its working great.Please suggest how to resolve this error. Below is my class:
public with sharing class OppRecordSetVarController {
private final Integer pageSize = 10;
public integer pageNumber = 1;
public boolean lastPage = false;
private final String Could_Not_Save_Modified_Records = 'You have changed some values of the below records but did not save, please review the changes and "Save" the records then proceed.Otherwise “Cancel” to discard all pending changes.';
public transient Map<String, Decimal> probabilityStageNameMap;
ApexPages.StandardSetController controller;
public List<Opportunity> oppList{get;set;}
PageReference pg;
public OppRecordSetVarController(ApexPages.StandardSetController controller) {
try{
this.controller = controller;
controller.setPageSize(pageSize);
oppList = new List<Opportunity>();
Id id = controller.getFilterId();
controller.setFilterId(Id);
}catch(Exception e){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'Sorry this list view is not Accessible from this page, Please select All Opportunities from Standard Opportunity view and the try reloading this page'));
}
}
public void doNext(){
try{
controller.Next();
pageNumber++;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doPrevious(){
try{
controller.Previous();
pageNumber--;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doFirst(){
try{
controller.First();
pageNumber = 1;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doLast(){
try{
controller.Last();
lastPage = true;
pageNumber++;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public Boolean getHasPrevious(){
return this.controller.getHasPrevious();
}
public Boolean getHasNext(){
return this.controller.getHasNext();
}
public List<Opportunity> getOpportunities() {
oppList = (List<Opportunity>) controller.getRecords();
System.debug('==oppList.size=='+oppList.size());
return (List<Opportunity>) controller.getRecords();
}
public PageReference changeStageName(){
if (probabilityStageNameMap == null) {
probabilityStageNameMap = new Map<String, Decimal>();
for (OpportunityStage oppStage : [Select MasterLabel, DefaultProbability
From OpportunityStage]) {
probabilityStageNameMap.put(oppStage.MasterLabel, oppStage.DefaultProbability);
}
}
for(Opportunity op : oppList){
if (probabilityStageNameMap.containsKey(op.StageName)) {
op.Probability = probabilityStageNameMap.get(op.StageName);
}
}
return null;
}
public void changeListView(){
//controller.save();
}
public PageReference doSave(){
PageReference p;
try{
p = this.controller.save();
if(p != null){
//if(pageNumber != 1){
//pg = ApexPages.currentPage();
//pg.setRedirect(false);
pg = new PageReference('/apex/OppListViewVF');
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.CONFIRM, 'Records saved successfully!!'));
//}
}
}catch(Exception exx){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'An error occured on the page.Please try again reloading the page.'));
}
return pg;
}
public PageReference doCancel(){
PageReference pgc;
PageReference p = this.controller.cancel();
if(p != null){
pgc = new PageReference('/apex/OppListViewVF');
}
return pgc;
}
}
I would like to implement sorting in VF column header for list views of Opportunity.I have used StandardSetController for this, the getRecords() method working very fine while changing the list views.But list returned from getRecords() is immmutable and i am not able to change or sort while clicking on any column header.Thought of using SOQL queries for each List view and sort using order by clause, but there the problem is for every users' list views may differ.So generating dynamic SOQL according to logged in users list view on Opportunity : if you have any idea in this please help.
Please also share any idea/thought related to sort a vf page by column header for list view controller.
I am using StandardSetController in a custom Opportunity List view vf page.The page works fine...also the navigation buttons like next,previous etc.Now I have set the pageSize to 5, when user clicks on next button it shows the next set of 5 record, if user clicks save now then the page is being redirected to the first 5 set of records page.I would like to redirect the page to next set of 5 records. How would I achieve that? I have overridden the standard save method the code snippet is below:
public PageReference doSave(){
PageReference p;
try{
p = this.controller.save();
if(p != null){
if(controller.getPageNumber() == 1){
pg = new PageReference('/apex/OppListViewSorted');
}
else if(controller.getPageNumber() == 2){
}
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.CONFIRM, 'Records saved successfully!!'));
//}
}
}catch(Exception exx){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'An error occured on the page.Please try again reloading the page.'));
}
return pg;
}
We would like to deactivate one user and want to assign another active user in all the email alerts,assignment rules associated with him.
1.We want to achieve it in a custom way.Because if there are 100 email alerts associated with the user we want to deactivate, manually it will take a lot of time. 2.Do we have any object from which we can get the data of email alerts,assignment rules related to a user?
Overall any idea related to deactivating a user succesfully and assign all its assignment rules and email alerts to other active users are welcome.
In case of Opportunity team, if I dont have any Default Opportunity Team , I click 'Add Default Team' , a pop up will come 'The record owner does not have a default opportunity team.You can define default Opportunity team in User setup.'
If I do not have any default account team, then also I click 'Add Default Team' its refreshing the current Account Detail page.No pop up message is coming up.Is this an expected behaviour? Why the same type of pop up its coming in this case?
I am getting 'System.LimitException: Apex CPU time limit exceeded' error while reading and parsing XML as web service response.Debug log jhas reached its maximum size.
Below is my class:
public class readXMLResponseAndMapXMLDom{
public List<SiteSolutionProperty> getMap(){
Http http = new Http(); HttpRequest req = new HttpRequest(); req.setEndpoint('URL'); // did not include the actual URL; conncetion is successful. req.setMethod('GET'); HttpResponse res = http.send(req); List<XmlDom.Element> result1 = new List<XmlDom.Element>(); List<SiteSolutionProperty> result2 = new List<SiteSolutionProperty>(); SiteSolutionProperty ssp; List<SiteSolutionPropertyDetails> finalResult = new List<SiteSolutionPropertyDetails>(); Integer counter = 0; // create the xml doc that will contain the results of the REST operation
/********* USING XMLDOM ******/ XmlDom doc = new XmlDom(res.getBody()); // process the results //System.debug('Total Collection size ---'+doc.getElementsByTagName('ClassBrokerAvailabilities').size()); system.debug('Limits.getHeapSize()'+Limits.getHeapSize()); for (XmlDom.Element element: doc.getElementsByTagName('ClassBrokerAvailabilities')){ ssp = new SiteSolutionProperty(); //element.textContent() if(element.getElementsByTagName('BuildingKey') !=null){ //System.out.println("IF child name "+element.getElementsByTagName("BuildingKey").item(0).getTextContent()); ssp.setBuildingKey(element.getElementsByTagName('BuildingKey').get(0).textContent()); } if(element.getElementsByTagName('AddressLine2') !=null){ ssp.setAddressLine2(element.getElementsByTagName('AddressLine2').get(0).textContent()); } if(element.getElementsByTagName('BuildingName') !=null){ ssp.setBuildingName(element.getElementsByTagName('BuildingName').get(0).textContent()); } /*if(element.getElementsByTagName('BuildingOwner') !=null){ ssp.setBuildingOwner(element.getElementsByTagName('BuildingOwner').get(0).textContent()); }*/
We would like to deactivate one user and want to assign another active user in all the email alerts,assignment rules associated with him.
1.We want to achieve it in a custom way.Because if there are 100 email alerts associated with the user we want to deactivate, manually it will take a lot of time. 2.Do we have any object from which we can get the data of email alerts,assignment rules related to a user?
Overall any idea related to deactivating a user succesfully and assign all its assignment rules and email alerts to other active users are welcome.
I am getting 'core.apexpages.exceptions.ApexPagesHandledException: Object type not accessible. Please check permissions and make sure the object is not in development mode: Opportunity WHERE ( ((Fiscal = Q3)) ) ORDER BY Name ASC LIMIT ^ ERROR at Row:1:Column:306 Bind variables only allowed in Apex code ' exception when I used StandardSetController. I have not used any SOQL query still getting this error, getting this error only for one list view (Q3 opps where Fiscal period is Q3), but for the other list views its working great.Please suggest how to resolve this error. Below is my class:
public with sharing class OppRecordSetVarController {
private final Integer pageSize = 10;
public integer pageNumber = 1;
public boolean lastPage = false;
private final String Could_Not_Save_Modified_Records = 'You have changed some values of the below records but did not save, please review the changes and "Save" the records then proceed.Otherwise “Cancel” to discard all pending changes.';
public transient Map<String, Decimal> probabilityStageNameMap;
ApexPages.StandardSetController controller;
public List<Opportunity> oppList{get;set;}
PageReference pg;
public OppRecordSetVarController(ApexPages.StandardSetController controller) {
try{
this.controller = controller;
controller.setPageSize(pageSize);
oppList = new List<Opportunity>();
Id id = controller.getFilterId();
controller.setFilterId(Id);
}catch(Exception e){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'Sorry this list view is not Accessible from this page, Please select All Opportunities from Standard Opportunity view and the try reloading this page'));
}
}
public void doNext(){
try{
controller.Next();
pageNumber++;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doPrevious(){
try{
controller.Previous();
pageNumber--;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doFirst(){
try{
controller.First();
pageNumber = 1;
lastPage = false;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public void doLast(){
try{
controller.Last();
lastPage = true;
pageNumber++;
}catch(Exception e){
ApexPages.addMessage(new ApexPages.Message(ApexPages.SEVERITY.WARNING,Could_Not_Save_Modified_Records));
}
}
public Boolean getHasPrevious(){
return this.controller.getHasPrevious();
}
public Boolean getHasNext(){
return this.controller.getHasNext();
}
public List<Opportunity> getOpportunities() {
oppList = (List<Opportunity>) controller.getRecords();
System.debug('==oppList.size=='+oppList.size());
return (List<Opportunity>) controller.getRecords();
}
public PageReference changeStageName(){
if (probabilityStageNameMap == null) {
probabilityStageNameMap = new Map<String, Decimal>();
for (OpportunityStage oppStage : [Select MasterLabel, DefaultProbability
From OpportunityStage]) {
probabilityStageNameMap.put(oppStage.MasterLabel, oppStage.DefaultProbability);
}
}
for(Opportunity op : oppList){
if (probabilityStageNameMap.containsKey(op.StageName)) {
op.Probability = probabilityStageNameMap.get(op.StageName);
}
}
return null;
}
public void changeListView(){
//controller.save();
}
public PageReference doSave(){
PageReference p;
try{
p = this.controller.save();
if(p != null){
//if(pageNumber != 1){
//pg = ApexPages.currentPage();
//pg.setRedirect(false);
pg = new PageReference('/apex/OppListViewVF');
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.CONFIRM, 'Records saved successfully!!'));
//}
}
}catch(Exception exx){
ApexPages.addmessage(new ApexPages.message(ApexPages.severity.ERROR, 'An error occured on the page.Please try again reloading the page.'));
}
return pg;
}
public PageReference doCancel(){
PageReference pgc;
PageReference p = this.controller.cancel();
if(p != null){
pgc = new PageReference('/apex/OppListViewVF');
}
return pgc;
}
}
I would like to implement sorting in VF column header for list views of Opportunity.I have used StandardSetController for this, the getRecords() method working very fine while changing the list views.But list returned from getRecords() is immmutable and i am not able to change or sort while clicking on any column header.Thought of using SOQL queries for each List view and sort using order by clause, but there the problem is for every users' list views may differ.So generating dynamic SOQL according to logged in users list view on Opportunity : if you have any idea in this please help.
Please also share any idea/thought related to sort a vf page by column header for list view controller.
We would like to deactivate one user and want to assign another active user in all the email alerts,assignment rules associated with him.
1.We want to achieve it in a custom way.Because if there are 100 email alerts associated with the user we want to deactivate, manually it will take a lot of time. 2.Do we have any object from which we can get the data of email alerts,assignment rules related to a user?
Overall any idea related to deactivating a user succesfully and assign all its assignment rules and email alerts to other active users are welcome.
In case of Opportunity team, if I dont have any Default Opportunity Team , I click 'Add Default Team' , a pop up will come 'The record owner does not have a default opportunity team.You can define default Opportunity team in User setup.'
If I do not have any default account team, then also I click 'Add Default Team' its refreshing the current Account Detail page.No pop up message is coming up.Is this an expected behaviour? Why the same type of pop up its coming in this case?
I am sometimes amazed how a seemingly simple thing is some times made unneccessary difficult. Say you want to start a Live Agent session and have an input field to type an email address in right away without bothering the user with a pre-chat form. Should be as simple as the following code, right?:
<html>
<head>
<!-- THIS NEEDS TO BE INCLUDED FOR EVERYTHING TO WORK -->
<script type='text/javascript' src='https://c.la1c1.salesforceliveagent.com/content/g/deployment.js'></script>
<script type='text/javascript'>
liveagent.init('https://d.la1c1.salesforceliveagent.com/chat', '572D0000000011K', '00DD0000000oGsq');
</script>
<!-- END INCLUDE -->
</head>
<body>
<!-- THIS IS JUST THE HEADER OF THE PAGE -->
<h1>Chat med en kundebehandler!</h1>
<!-- HERES THE BUTTON CODE FROM SF. ADD CONTENT WHERE THE COMMENT IS -->
<div id="liveagent_button_online_573D0000000016a" style="display: none;" >
<input type="text" name="email" id="chatter_email" onBlur="emailUpdate()"/><br/>
<a href="javascript://Chat" onclick="liveagent.startChat('573D0000000016a')">Fyll inn din e-post og trykk her for å chatte</a>
</div>
<div id="liveagent_button_offline_573D0000000016a" style="display: none;">Kundebehandler offline</div>
<script type="text/javascript">
if (!window._laq) { window._laq = []; }
window._laq.push(function()
{liveagent.showWhenOnline('573D0000000016a', document.getElementById('liveagent_button_online_573D0000000016a'));
liveagent.showWhenOffline('573D0000000016a', document.getElementById('liveagent_button_offline_573D0000000016a'));
});
function emailUpdate() {
liveagent.addCustomDetail('Contact E-Mail', document.getElementById('chatter_email').value).map('Contact', 'Email', true, true, false);
}
</script>
<!-- END OF BUTTON CODE -->
</body>
</html>
But no - you get a javascript exception: "you cannot add a detail after page initialization".
In practice this means that you can add whatever you like before you load the page, but if you want the user to input something - you're ... toast (that was not the word I wanted to use, so I leave that up to your imagination).
Stuff like that irritates me like a red hot poker up the butt.
