Sign Up ›
  • Mike_M
  • NEWBIE
  • 0 Points
  • Member since 2012
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 7
    Replies
6 replies

how to produce report of all metadata

We are in the process of merging 2 salesforce orgs. It would be really helpful if there was a printable report that showed all standard objects as well as all customizations to SalesForce. (I'm not interested in the user-data, just the meta-data) Do any such reporting tools exist?

 

Thanks for any links or suggestions. 

 

Mike

  • March 15, 2012
  • Like
  • 0
5 replies

Too many query rows on COUNT(*) function

My main question is, how can I get the following counts:

  1) all accounts with no parent account

  2) all accounts with a parent account

  3) all accounts

 

Here is what I have tried:

Using the Developer Console in SalesForce gave the following commands ...

   integer c1 = [select count() FROM Account where parent.id = null ];

   integer c2 = [select count() FROM Account where parent.id <> null ];

   integer c3 = [select count() FROM Account ];

 

The first two commands were successful but on "integer c3 = [select count() FROM Account ];" I hit a limit.

11:02:17:378 EXCEPTION_THROWN [1]|System.LimitException: Too many query rows: 50001

 

So, how can I get the total count of all accounts? (using or not using Developer Console) 

 

TIA,

Mike

 



  • March 01, 2012
  • Like
  • 0
SOLVED
8 replies

Why does this not work. (Simple code question)

Hi, I am working through the totorial and came to the part for triggers. Below is the code straight from the tutorial PLUS one extra line that I added shown in red. 

 

trigger HandleProductPriceChange on Merchandise__c (after update) {
    List<Line_Item__c> openLineItems =
        [SELECT j.Unite_Price__c, j.Merchandise__r.Price__c
         FROM Line_Item__c j
         WHERE j.Invoice_Statement__r.Status__c = 'Negotiating'
         AND j.Unite_Price__c < j.Merchandise__r.Price__c
         AND j.Merchandise__r.id IN :Trigger.new
         FOR UPDATE];
    for (Line_Item__c li: openLineItems) {
        if ( li.Merchandise__r.Price__c < li.Unite_Price__c ){
        li.Unite_Price__c = li.Merchandise__r.Price__c;
        }
    }
    update openLineItems;
}
When I try to SAVE I get a compile error on the line I added.  [unexpected token: j.Merchandize__r.Price__c]
Why does my new line of code not work?
(Note: Unite_Price really IS the field name. It's a typo that I never went back to fix.)
Thanks,
Mike

 

  • January 31, 2012
  • Like
  • 0
5 replies

Too many query rows on COUNT(*) function

My main question is, how can I get the following counts:

  1) all accounts with no parent account

  2) all accounts with a parent account

  3) all accounts

 

Here is what I have tried:

Using the Developer Console in SalesForce gave the following commands ...

   integer c1 = [select count() FROM Account where parent.id = null ];

   integer c2 = [select count() FROM Account where parent.id <> null ];

   integer c3 = [select count() FROM Account ];

 

The first two commands were successful but on "integer c3 = [select count() FROM Account ];" I hit a limit.

11:02:17:378 EXCEPTION_THROWN [1]|System.LimitException: Too many query rows: 50001

 

So, how can I get the total count of all accounts? (using or not using Developer Console) 

 

TIA,

Mike

 



  • March 01, 2012
  • Like
  • 0
SOLVED
8 replies

Why does this not work. (Simple code question)

Hi, I am working through the totorial and came to the part for triggers. Below is the code straight from the tutorial PLUS one extra line that I added shown in red. 

 

trigger HandleProductPriceChange on Merchandise__c (after update) {
    List<Line_Item__c> openLineItems =
        [SELECT j.Unite_Price__c, j.Merchandise__r.Price__c
         FROM Line_Item__c j
         WHERE j.Invoice_Statement__r.Status__c = 'Negotiating'
         AND j.Unite_Price__c < j.Merchandise__r.Price__c
         AND j.Merchandise__r.id IN :Trigger.new
         FOR UPDATE];
    for (Line_Item__c li: openLineItems) {
        if ( li.Merchandise__r.Price__c < li.Unite_Price__c ){
        li.Unite_Price__c = li.Merchandise__r.Price__c;
        }
    }
    update openLineItems;
}
When I try to SAVE I get a compile error on the line I added.  [unexpected token: j.Merchandize__r.Price__c]
Why does my new line of code not work?
(Note: Unite_Price really IS the field name. It's a typo that I never went back to fix.)
Thanks,
Mike

 

  • January 31, 2012
  • Like
  • 0