And if so, how to ?

the idea we have is to develop all the campaign management to be able to add account as members ... I'm affraid !! :( 

 

Thank you all for your ideas.

M.C.

Hi all,

 

First of all, thanks for your help

 

The scenario :

 

- I've got an object with Public Read Only access.

- The Edit button for this object is overriden by a VisualForce Page

 

Everything works fine but when a user tries to edit someone else record, he can enter into the Edit Record VF page and when he tries to save it works .. but it shouldn't because it's Public Read Only.

 

 Are theApex classes above the company Wide default setting ? How can I solve this problem ?

 

For info : It's an upsert... 

 

Thanks in advance. 

In this org:  

Affiliations__c is a non master relationship to Contact. 

If a Contact is deleted, a trigger is fired and will delete the related affiliations! 

 

What I want to do is : if a contact is undeleted, undelete the deleted related affiliations as well

 

My code :   

 

trigger ContactAfterUndelete on Contact (after undelete) {

Affiliation__c[] affiliationsFired ;

Affiliation__c[] affiliationsToUpdate = new Affiliation__c[]{};

affiliationsFired = [Select id from Affiliation__c where isDeleted = true and (Affiliation_From_Contact__c in :Trigger.old or Affiliation_To_Contact__c in: Trigger.old) ALL ROWS] ;

for (Integer i=0 ; i< affiliationsFired.size() ; i++){

affiliationsFired[i].isDeleted = false ;

AffiliationsToUpdate.add(affiliationsFired[i]);

}

update AffiliationsToUpdate ;}

 

I've got an error because isDeleted is non Writeable! 

 

Please, Can you give me some advices on how to solve this issue ? 

 

Tkx,

Mig 

 

I know that's it's not possible to trigger a worklow by a field update done by another workflow. 

My question is : If My fiest workflow updates a record that will fire my apex trigger and this apex trigger fires a worlfow. Do you think this will work ?

 

If not, do you know if it's possible to enable this functionnality ?

http://ideas.salesforce.com/article/show/10093883/Allow_workflow_or_approval_process_to_trigger_workflow

 ( a guy here says that he thinks it's possible, how can I do it ? )

 

Thanks a lot for all your answers.

 

Cheers,

Mig 

 

Hi all,I'm having some difficulties to get succees with my Test coverage: 

 

The Controler :

 

public PageReference autoRun() {
String oppID = ApexPages.currentPage().getParameters().get('id');
if (oppID == null) {
// Display the Visualforce page's content if no Id is passed over
return null;
}
// Get the sObject describe result for the Opportunity object
Schema.DescribeSObjectResult r = Opportunity.sObjectType.getDescribe();
Map<String, Schema.SObjectField> M = r.fields.getMap(); //Generate a Map of the fields

//Now loop through the list of Field Names and concatenate the SOQL query string
String SOQL = 'Select ';
for (String fieldName : M.keySet()){
System.debug('fieldName: ' + fieldName);
SOQL += fieldName + ',';
}
SOQL = SOQL.substring(0,SOQL.length()-1); //Remove the last , unnecessary comma
SOQL += ' From Opportunity o where id=\''+getOpportunityId()+'\' LIMIT 1' ;

//Execute SOQL & Cast the sObject type into an Opportunity
sObject S = Database.query(SOQL);
Opportunity opp = (Opportunity)S;

//Clone the Opportunity - 2 parameters (PreserveId or not, IsDeepClone or not )
Opportunity newOpp = opp.clone(false,true);
newOpp.Name=opp.Name + ' v2';
insert newOpp;

/*.... All the other related objects like OpportunityLineItems : */

// Go to the new Opportunity
PageReference pageRef = new PageReference('/' + newOpp.Id);
pageRef.setRedirect(true);
return pageRef;


}

  

With my test coverage, the class autorun() is not covered at all !! I've got 28 % but is only the rest of the controler  ... 

 

public class TestOpportunityClones {

static testMethod void validateOpportunityClones(){
Account acc1 = new Account();
acc1.Name = 'Test' ;
insert acc1 ;

/*** To create a Opportunity Line Item, other fields are required : **/
Opportunity opp1 = new Opportunity();
opp1.Name ='Oppty test converage ' ;
opp1.AccountId = acc1.Id ;
opp1.StageName = 'Prospecting' ;
Date d1 = Date.newInstance(2009,1,1);
opp1.CloseDate = d1;
insert opp1 ;

Product2 prod = new Product2();
prod.Name = 'Product Name test' ;
prod.IsActive = true ;
insert prod ;


// Each Product has a standard unit price in the standard PriceBook. This value is required !!!!
Pricebook2 [] pbookstd = [ Select p.id from Pricebook2 p where p.isstandard =: true limit 1] ;

PricebookEntry PriceEntry = new PricebookEntry();
priceEntry.isActive = true ;
PriceEntry.UnitPrice = 250 ;
PriceEntry.PriceBook2Id = pbookstd[0].Id ;
PriceEntry.Product2Id = prod.Id ;
insert PriceEntry ;


OpportunityLineItem oppLineItem1 = new OpportunityLineItem();
oppLineItem1.OpportunityId = opp1.Id ;
oppLineItem1.PricebookEntryId = PriceEntry.Id ;
oppLineItem1.UnitPrice = 500 ;
oppLineItem1.Quantity = 1 ;
insert oppLineItem1 ;


ApexPages.StandardController ac = new ApexPages.StandardController(opp1); //set up the standardcontroller
Opportunityclone1 controler = new Opportunityclone1(ac); //and set up the extensions to the standardcontroller

controler.getOpportunityId() ;
controler.setOpportunityId(opp1.Id);
controler.autoRun();

SObject s = Database.query('select id from Opportunity limit 1');
System.assertEquals(s.getSObjectType(), Opportunity.sObjectType); //

// Create a list of generic sObjects
List<sObject> oppType = new Opportunity[]{};
System.assertEquals(oppType.getSObjectType(), Opportunity.sObjectType);

Do you know how to cover Describe Sobject functions ... 

I continue trying to discover the solution ...

Thanks for all your help.

 

 

 

______________________________________ 

This conversation has began here : (tkx aalbert)

http://community.salesforce.com/sforce/board/message?board.id=apex&message.id=11568#M11568

 

The sortOrder of the Opportunity Products is a RO field  :( And I need to reorder the products as I want ... it's impossible since we can not set the order of the lines ! :( 

 

 

Is there any way to order the Opportunity Lines as we'd like ? Or at least ask salesforce per exemple to set Writable the field sortOrder ? 

 

 

 

 

Sorry to open again a new thread about the same thing :

http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=8339&query.id=210565 

 

Vote :

http://ideas.salesforce.com/article/show/10092062/OpportunityLineItem_SortOrder_to_be_CreatableUpdatable 

I'm developing new buttons at the Opportunity Level that will clone the Opportunity with or without some related objects !

The clone works fine (at least I think this is the best way to do it )


Opportunity opp=[Select o.qtyProductGroups__c, o.Won_Lost_Comment__c, o.State__c, o.StageName, o.Selected_Contact_Id__c, o.Remarks__c, o.RecordTypeId, o.Reason_Won__c, o.Reason_Lost__c, o.Probability, o.Primary_Opportunity__c, o.Pricebook2Id, o.Personal_Chance_of_Success__c, o.OwnerId, o.Opportunity_Type__c, o.Opportunity_Description__c, o.One_Shot_Order__c, o.IsWon, o.IsDeleted, o.IsClosed,
o.I_Internal_Status__c, o.I_Account_manager__c, o.HasOpportunityLineItem, o.ForecastCategoryName, o.ForecastCategory, o.FiscalYear,
o.FiscalQuarter, o.Fiscal, o.FAS__c, o.Expire_Date__c, o.Do_not_Show_Total__c, o.Description, o.Delivery_specifications__c, o.Customer_Reference__c, o.CurrencyIsoCode, o.Contractual_Agreement__c, o.Competitor__c, o.Competitor_Products_involved__c, o.Competitor_Pricing__c, o.Competition__c, o.CloseDate, o.Categorisation__c, o.Budget__c, o.Amount, o.AccountId From Opportunity o where id=:getOpportunityId()];
if (opp.Id != null){
Opportunity newOpp = opp.clone(false,true);
newOpp.Name=opp.Name + ' CLONE';
insert newOpp;
}



As you see I need to put in there all the fields to be cloned.
The problem is : if in the future I create a new field, this one will not be transmitted with the clone ! (unless I edit the query here and add this new field) !!!!!! Is there any solution for this ?


Tkx a lot to you all for your answers and support !

Message Edited by Mig on 01-19-2009 06:49 PM

I would like to know what is the maximum number of records ( of the same object) an Apex class or trigger can make in one shot ?
And how to do it ( Bulk trigger I suppose , and what more ? )

After some research :

1. Trigger 2.Visualforce Controler 3. Run Test

Total number of DML statements issued (insert, update, upsert, merge, or delete)	20	100^	100
Total number of records processed as a result of DML statements	100****	10,000^	500

I don't understand the difference between the total number of DML statement and the total number of records processed as a result of DML statement.

If I need to create 300 records. I do need to make 300 update calls ! Right ?


Thankx a lot for this informaion. I actually need this confirmation for tomorow so I'm keeping try to find out ...

Tkx to all of you.

MC



Message Edited by Mig on 09-18-2008 01:27 PM

Do someone know how to edit the Customer Portal roles ?

I've created a trigger in the Case Object but it does not fires when my salesforce receive a case from a email to case ...
Is there a way to enable/disable the apex code triggers from outside rssources ?

does the Apex triggers works  with email to cases and webtocases and all this kind of external sources  ??

Thankx 

Miguel


Message Edited by Mig on 06-27-2008 04:57 PM

I've got this code :






Message Edited by Mig on 06-13-2008 10:54 AM

Hi,

I saw this : http://blogs.salesforce.com/features/2008/05/visualforce-pag.html

In Summer 08 Will we be available to create Visualforce pages into Production ? Or it's already available ?

Thank you

Hello,

I've got a problem.
I'm doing an S-Control with some queries. And I'm getting this error : Index or size is negative or greater than the allowed amount" code: "1 ( With Firebug)

I think it's a query in the Account table.
Is there a maximum queries per day we can use ? My API calls does not attempt the maximum.

Someone an idea on this please ?

Error when I save a record The trigger is triggered but with an error :  "execution of AfterInsert caused by: System.Exception: Record is read-only: "

I'm trying to make an update after insert. And I'm ADMIN and the record is not read-only. Did anybody had an error like this one ?

The trigger will bring to each contact the website of the related account ;

This code works when I update a Contact. But it did not work when I create it. Can someone please help me:




Message Edited by Mig on 04-04-2008 05:41 PM

Message Edited by Mig on 04-04-2008 05:42 PM

Message Edited by Mig on 04-04-2008 05:56 PM

My trigger works fine when it returns data. But sometimes The query return anything and I've got this problem.
BonusTrigger: execution of BeforeUpdate caused by: System.QueryException: List has no rows for assignment to SObject:


When this query returns anything I've got a problem. How to solve it ?
Thank you in advance for your help

           



Message Edited by Mig on 03-18-2008 05:32 PM

Hi,

I created a List Button :

List Button code :


Message Edited by Mig on 02-12-2008 01:13 PM

My company has the ENTERPRISE SFDC edition .
I created a APEX sandbox but it's not the Spring 08 one :( Server url : http://cs1.salesforce.com ) It seems that it's the Winter 07 ...

Is there anyway to update it ?
Why don't I have the right to be at the http://tapp0.salesforce.com one ? This one has already the Spring 08 :'(

I'm in Europe and I have to wait to February 16 to have  ? I would like to create some packages ( not Appexchange packages ... the other ones ) But Don't have the SPRING 08 in my sandbox and I can not create it !

Anyone know someting about something about sandbox or spring 08 updates and how to do update it ?

Thank you very much



Message Edited by Mig on 02-06-2008 07:19 AM

Message Edited by Mig on 02-05-2008 08:37 AM

I made a trigger that updates somes values after update. But some fields are not the same type.

Is there any functionnality ( like toString)  to covnert My picklist values (String) to a double ( Like parseFloat in Javascript).


Thank you

This component works but does not validate and gives the following error message:
Step not yet complete... here's what's wrong: 
The CSS does not contain a reference to the background image 
Note: you may run into errors if you've skipped previous steps.

Hi,

I'm tying to launch a custom SOQL query:

SELECT Phone, PersonAssistantName, Owner.FirstName, Owner.LastName, Owner.Username, Owner.CommunityNickname, (SELECT Contact.FirstName, Contact.LastName, Contact.MobilePhone, Contact.Email FROM Account.Contacts LIMIT 1) FROM Account

 

But can't access to the CommunityNickname field of User table.

Looking at the documentation for User, it must exist. What am I doing wrong?

Hello

 

I'm a very new in all the salesforce business

i'm trying to make a new button in the account that will open me a new task with some data in the fields

 

 

Someone can help me ?

 

Thanks

Elad

 

 

In this org:  

Affiliations__c is a non master relationship to Contact. 

If a Contact is deleted, a trigger is fired and will delete the related affiliations! 

 

What I want to do is : if a contact is undeleted, undelete the deleted related affiliations as well

 

My code :   

 

trigger ContactAfterUndelete on Contact (after undelete) {

Affiliation__c[] affiliationsFired ;

Affiliation__c[] affiliationsToUpdate = new Affiliation__c[]{};

affiliationsFired = [Select id from Affiliation__c where isDeleted = true and (Affiliation_From_Contact__c in :Trigger.old or Affiliation_To_Contact__c in: Trigger.old) ALL ROWS] ;

for (Integer i=0 ; i< affiliationsFired.size() ; i++){

affiliationsFired[i].isDeleted = false ;

AffiliationsToUpdate.add(affiliationsFired[i]);

}

update AffiliationsToUpdate ;}

 

I've got an error because isDeleted is non Writeable! 

 

Please, Can you give me some advices on how to solve this issue ? 

 

Tkx,

Mig 

 

Hi,

 

I am stuck in a issue that looks simple. I have a object which has related record in a child object. If the parent object record is deleted, then the child object record should be deleted. I have implemented this using triggers.

 

But the issue is how to delete already orphaned records. The requirement is to delete orphaned records that does not have any matching parent records.

 

Thanks

 

 

I know that's it's not possible to trigger a worklow by a field update done by another workflow. 

My question is : If My fiest workflow updates a record that will fire my apex trigger and this apex trigger fires a worlfow. Do you think this will work ?

 

If not, do you know if it's possible to enable this functionnality ?

http://ideas.salesforce.com/article/show/10093883/Allow_workflow_or_approval_process_to_trigger_workflow

 ( a guy here says that he thinks it's possible, how can I do it ? )

 

Thanks a lot for all your answers.

 

Cheers,

Mig 

 

I'm developing new buttons at the Opportunity Level that will clone the Opportunity with or without some related objects !

The clone works fine (at least I think this is the best way to do it )


Opportunity opp=[Select o.qtyProductGroups__c, o.Won_Lost_Comment__c, o.State__c, o.StageName, o.Selected_Contact_Id__c, o.Remarks__c, o.RecordTypeId, o.Reason_Won__c, o.Reason_Lost__c, o.Probability, o.Primary_Opportunity__c, o.Pricebook2Id, o.Personal_Chance_of_Success__c, o.OwnerId, o.Opportunity_Type__c, o.Opportunity_Description__c, o.One_Shot_Order__c, o.IsWon, o.IsDeleted, o.IsClosed,
o.I_Internal_Status__c, o.I_Account_manager__c, o.HasOpportunityLineItem, o.ForecastCategoryName, o.ForecastCategory, o.FiscalYear,
o.FiscalQuarter, o.Fiscal, o.FAS__c, o.Expire_Date__c, o.Do_not_Show_Total__c, o.Description, o.Delivery_specifications__c, o.Customer_Reference__c, o.CurrencyIsoCode, o.Contractual_Agreement__c, o.Competitor__c, o.Competitor_Products_involved__c, o.Competitor_Pricing__c, o.Competition__c, o.CloseDate, o.Categorisation__c, o.Budget__c, o.Amount, o.AccountId From Opportunity o where id=:getOpportunityId()];
if (opp.Id != null){
Opportunity newOpp = opp.clone(false,true);
newOpp.Name=opp.Name + ' CLONE';
insert newOpp;
}



As you see I need to put in there all the fields to be cloned.
The problem is : if in the future I create a new field, this one will not be transmitted with the clone ! (unless I edit the query here and add this new field) !!!!!! Is there any solution for this ?


Tkx a lot to you all for your answers and support !

Message Edited by Mig on 01-19-2009 06:49 PM

I'd like to re-open the discussion of SortOrder on the OpportunityLineItem object. A thread from 3.5 years ago can be located here:
http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=3154

Looks like people from SF were going to look into it but obviously nothing has come to fruition. The reason I have put this in the Visualforce board is that we have have a few VF applications that could really take advantage of access to this field. Visualforce has also opened up new possibilities to UI design where the ability to manage SortOrder could be useful.

Also, no offense to salesforce.com, but the tool for sorting OpportunityLineItems is not that useful when there are multiple products with the same name. I have actually built a pretty slick sorting application but this is currently useless.

A lot of the concerns were about error handling. What happens if you have 3 line items but sort order is defined as, 1, 2, 2. Or 1, 2, 4. How about just throwing a sortOrder exception and force the developers to write good code?

Ideas? Thoughts?
http://ideas.salesforce.com/article/show/10092062/OpportunityLineItem_SortOrder_to_be_CreatableUpdatable

-Jason


Message Edited by TehNrd on 09-05-2008 01:22 PM

I've got this code :






Message Edited by Mig on 06-13-2008 10:54 AM

Hi,

I saw this : http://blogs.salesforce.com/features/2008/05/visualforce-pag.html

In Summer 08 Will we be available to create Visualforce pages into Production ? Or it's already available ?

Thank you

Hi,
<apex:commandLink  value="attach" action="{!attach}">
 <apex :param assignto="{!test}" value="{!location.id}"/>
</apex:commandLink>

And I have getter and setter methods in my controller. This works fine. But when I replace it with commandButton it is not working.

Thanks,
Nimdhar

Hello,

I've got a problem.
I'm doing an S-Control with some queries. And I'm getting this error : Index or size is negative or greater than the allowed amount" code: "1 ( With Firebug)

I think it's a query in the Account table.
Is there a maximum queries per day we can use ? My API calls does not attempt the maximum.

Someone an idea on this please ?

Hi,

I created a List Button :

List Button code :


Message Edited by Mig on 02-12-2008 01:13 PM

I know that a delete trigger is not fired for a merge.  What are the other cases where delete triggers are not fired?

My question relates to having our application sit beside other APEX applications.  I want to ensure that a clean database is maintained regardless of other applications.

GlennW