When you get to:

sfdx force:org:open

run that in comand get the following

You can't access Lightning Experience
The page you're trying to access is available from Lightning Experience or the Salesforce1 mobile app only. Need help? Ask your Salesforce admin.

Loops over that cant get any further

For(AggregateResult ARCY:[SELECT SUM(Amount__c) mySum, COUNT(id) myCount, Account__c
      	FROM Finance__c where Account__c =:Ac[0].id AND 
                                 (Group__c = 'TOTAL' 
                                 	OR Group__c = 'Total') AND 
                                 	(Code__c Like '%YTD%'
                                 	 OR Code__c Like :'%'+LastYear+'%'
                                 	 OR Code__c Like :'%'+Year2+'%'
                                 	 OR Code__c Like :'%'+Year3+'%'
                                 	 OR Code__c Like :'%'+Year4+'%')
                                 	GROUP BY Account__c])
               myCount = double.valueOf(ARCY.get('myCount'));
              mySum = double.valueOf(ARCY.get('mySum'));

The secont .get failes no matter what way around they are, feel like I have forgotten a limitation on AggregateResult
 

Hi all,

seem to be hitting a brick wall cant find any reasonable documentation on retrieving this.

I want to migrate the data between 2 sandboxes but its just not retrieveable.

I have already looked at:
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_datacategorygroup.htm

seems to tell me how to structure it for import but not for retrieve.

Any pointers apreciated, I was hoping to be able to use package but I am guessing thats not going to help me here.

R

Hi All,

I am trying to start a batch process from a trigger, but cant get the where cluase to pass in the query string.
 

BuildIBCall reassign = new BuildIBCall();
reassign.email='notmyemail@idontworkhere.com';
String sql = 'select Account__c, from OB__c Where ID IN:';
String idString= '\''+String.join(IBToUpdate,'\',\'')+'\'';
Sql+= idString;        
reassign.query= Sql;
ID batchprocessid = Database.executeBatch(reassign, 30);

Now I know its passing the ID's because if I remove the : I get the error:

Any ideas?
R
First error: expecting a colon, found 'anidishere'

Hi all,

seem to be hitting a brick wall cant find any reasonable documentation on retrieving this.

I want to migrate the data between 2 sandboxes but its just not retrieveable.

I have already looked at:
https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_datacategorygroup.htm

seems to tell me how to structure it for import but not for retrieve.

Any pointers apreciated, I was hoping to be able to use package but I am guessing thats not going to help me here.

R

Hi All,

I am trying to start a batch process from a trigger, but cant get the where cluase to pass in the query string.
 

BuildIBCall reassign = new BuildIBCall();
reassign.email='notmyemail@idontworkhere.com';
String sql = 'select Account__c, from OB__c Where ID IN:';
String idString= '\''+String.join(IBToUpdate,'\',\'')+'\'';
Sql+= idString;        
reassign.query= Sql;
ID batchprocessid = Database.executeBatch(reassign, 30);

Now I know its passing the ID's because if I remove the : I get the error:

Any ideas?
R
First error: expecting a colon, found 'anidishere'

Hi there, The below script works well on case list views. however the problem is with the refresh, after the page refresh list view changes to something else. It not showing the selected list view, instead it's showing the first view or random(not sure). 

Is there way to update records, refresh the list view and select the same list view ? 

{!REQUIRESCRIPT("/soap/ajax/34.0/connection.js")} 

var records = {!GETRECORDIDS($ObjectType.Case)}; 
var newRecords = []; 

if (records[0] == null) 
{ 
alert("Please select at least one row") 
} 
else 
{ 
for (var n=0; n<records.length; n++) { 
var c = new sforce.SObject("Case"); 
c.id = records[n]; 
c.Status = "Canceled"; 
c.ownerid='{!$User.Id}'; 
newRecords.push(c); 
} 

result = sforce.connection.update(newRecords); 
window.location.reload(); 
}
 

Hi - SF Help & training indicates that you can add up to 4 columns to a dashboard table.  I'm still struggling with it, I can only get it to show 2.  Has anyone been successful with this?

 

Thanks