Hi,

Is there any trim function in SOQL? Please help.

Thanks and Regards

Hari G S

Hi,

What should be the query to cancatinate two fields in SOQL

The equivalent mysql query is

select id from User where concat(firstname," ",lastname)="Hari G S";

Thanks and Regards

Hari G S

Hi,

I have a doubt in SOQL. Can we write join queries in SOQL? If it is possible please show me a sample query.

Thanks and Regards

Hari G S

Hi,

I ahve written some Apex Classes in Sandbox. But when i go to the Setup->App Setup->Develop->Apex Classes page i cannot be able to see the classes. I think this is happening after refreshing sandbox. Please help me to see the Apex Classes i have written. I want to delete some.

Thanks and Regards

Hari G S

Hi,

Is there any way we can call an API method from an APEX Trigger?

Please help..

Thanks and Regards

Hari G S

Hi,

When a quote is auto-populated from within an Opportunity record, can we limit the available contacts to only those within the connected Account. Currently we can pick any contact inside of SFDC.

Thanks and Regards

Hari G S

Hi, I have a scenario like

I have created a Qoute Template. When i go to Quote Page and Create PDF using this template i can see a button Save and Send Email. My requirement is to change the Quote status to Presented to Customer when this button is being pressed.

I have written a trigger in almost all the objects but none invoked while clicking on this button. Is this possible to do? 

Please help..

Thanks and Regards

Hari G S

Hi

I have written a trigger

trigger oneTimeTrigger on Account (after insert, after update) {
    Account myAcc = trigger.new[0];
    Account[] accs = [SELECT Id, Name FROM Account];
    list<Account> accList = new list<Account>();
    integer count = 0; 
    if(accs.size() > 0) {
        for(Account a : accs){
            count++;
            if(count >= 0 && count <= 500) {
                Opportunity[] opp = [select Id From Opportunity where AccountId = :a.Id];
                if(opp != null) {
                    a.Number_Of_Opportunities__c = opp.size(); // count();
                    accList.add(a);
                }
            }
        }
        update accList;
    }

}

But i am getting a Error

Error: Invalid Data.
Review all error messages below to correct your data.
Apex trigger oneTimeTrigger caused an unexpected exception, contact your administrator: oneTimeTrigger: execution of AfterUpdate caused by: System.DmlException: Update failed. First exception on row 0 with id 001L00000033S7PIAU; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, oneTimeTrigger: maximum trigger depth exceeded Account trigger event AfterUpdate for [001L00000033S0b] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event BeforeUpdate for [001L00000033S0b, 001L00000033S7P]: []: Trigger.oneTimeTrigger: line 17, column 9

Why is this happening? Please help

Thanks and Regards

Hari  G S

Hi,

Is there any simple way to get the number of opportunities added to an account? Is count query available in SOQL?

Thanks and Regards

Hari  G S

Hi,

I have added a new number field in Account object. I want to set a default value 0 to this field. How is it possible? Please help.

Thanks and Regards

Hari G S

Hi,

I am new to Apex API. when i tried the url in the SoapUI or in the Netbeans IDE it shows an error(badly formatted wsdl). I donot know what to do next. I would like to know one thing that can we call a webservice methode from a trigger? Eventually what i want to do is to update the Self Service User Object. Through trigger it is not possible. But some one says that through API we can create or update Self Service Users. That is why i would like to know whether webservice call is possible through Apex? and will it fullfill my requirement? Please help..

Thanks and Regards

Hari G S

Hi,

I have created a custum formula field in Quote Line Item Object and the formula was Product2.Description. When i do check syntax it shows no error. But when i try to create a custom formula field in a custom object it shows an error Field Product2 does not exist. Check spelling. Why this is happenening? Please help.

Thanks and Regards,
Hari G S

Hi,

Can i invoke any Objects trigger when a Quote has been emailed? When a quote has been emailed i want to change its status to Presented to Customer. Is there any way to do this?

Regards

Hari G S

Hi,

Can anyone please help in how to use API. I am using SoapUI. When i try to load the Apex WSDL in SoapUI it shows some error. What is the difference among Enterprise WSDL, Partner WSDL, Apex WSDL, Metadata WSDL and Delegated Authentication WSDLs. , and what is Client Certificate.?

Thanks and Regards

Hari G S

Hi,

Is it possible to call a API method through Apex Trigger?

Thanks and Regards

Hari G S

Hi,

There is a list of Standard Home Page components and i have added Task to my home page. Is there any way to customize the

Task fields or can i create a new custom field in Task.

Complete, Date, Subject, Name and Related To are the Task fields displayed in my home page. I want to add one more field here ,say state, and this field should map to Contacts State field.

Thanks and Regards

Hari G S

Hi,

I am new to API. Can anyone please help me how to create a self service user through API.

Thanks and Regards

Hari G S

Hi ,

Could anyone please explain why DML is not possible in Self Service User Objects. When we edit and save a Salf Service User through UI it will get updated. Is this not a DML operation? What is the issue when we try to update a Self Service User object through a trigger?

Thanks and Regards

Hari G S



Hi,

I want to create a custom object wich should contain accounts which do not have an opportunity added. Please help me to create such a custom object.

Thanks and Regards

Hari G S

Hi,

I have added Tasks to my Home Page. I would like to add one more column there. Is it possible to do that?.

Thanks and Regards

Hari G S

Hi,

Is there any trim function in SOQL? Please help.

Thanks and Regards

Hari G S

Hi,

What should be the query to cancatinate two fields in SOQL

The equivalent mysql query is

select id from User where concat(firstname," ",lastname)="Hari G S";

Thanks and Regards

Hari G S

Hi,

I ahve written some Apex Classes in Sandbox. But when i go to the Setup->App Setup->Develop->Apex Classes page i cannot be able to see the classes. I think this is happening after refreshing sandbox. Please help me to see the Apex Classes i have written. I want to delete some.

Thanks and Regards

Hari G S

Hi,

When a quote is auto-populated from within an Opportunity record, can we limit the available contacts to only those within the connected Account. Currently we can pick any contact inside of SFDC.

Thanks and Regards

Hari G S

Hi

I have written a trigger

trigger oneTimeTrigger on Account (after insert, after update) {
    Account myAcc = trigger.new[0];
    Account[] accs = [SELECT Id, Name FROM Account];
    list<Account> accList = new list<Account>();
    integer count = 0; 
    if(accs.size() > 0) {
        for(Account a : accs){
            count++;
            if(count >= 0 && count <= 500) {
                Opportunity[] opp = [select Id From Opportunity where AccountId = :a.Id];
                if(opp != null) {
                    a.Number_Of_Opportunities__c = opp.size(); // count();
                    accList.add(a);
                }
            }
        }
        update accList;
    }

}

But i am getting a Error

Error: Invalid Data.
Review all error messages below to correct your data.
Apex trigger oneTimeTrigger caused an unexpected exception, contact your administrator: oneTimeTrigger: execution of AfterUpdate caused by: System.DmlException: Update failed. First exception on row 0 with id 001L00000033S7PIAU; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, oneTimeTrigger: maximum trigger depth exceeded Account trigger event AfterUpdate for [001L00000033S0b] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event AfterUpdate for [001L00000033S0b, 001L00000033S7P] Account trigger event BeforeUpdate for [001L00000033S0b, 001L00000033S7P]: []: Trigger.oneTimeTrigger: line 17, column 9

Why is this happening? Please help

Thanks and Regards

Hari  G S

Hi,

I have added a new number field in Account object. I want to set a default value 0 to this field. How is it possible? Please help.

Thanks and Regards

Hari G S

Hi,

I have created a custum formula field in Quote Line Item Object and the formula was Product2.Description. When i do check syntax it shows no error. But when i try to create a custom formula field in a custom object it shows an error Field Product2 does not exist. Check spelling. Why this is happenening? Please help.

Thanks and Regards,
Hari G S

Hi,

Shall I generate reports like all Accounts created this year with no opportunities.

Thanks and Regards

Hari G S

Hi,

While tring to deploy the code to production i am getting this error 

System.LimitException: Too many SOQL Queries:101

Why this error is occuring?

My code is

trigger productTrigger on Product2 (after insert, after update) {
    Product2 myProd = Trigger.new[0];    
    Purchased_Products_del__c[] puchasedProd = [select Id, Product_Code__c from Purchased_Products_del__c where Product__c=:myProd.Id];
    if(puchasedProd != null && puchasedProd.size() > 0) {        
        for(Purchased_Products_del__c pProd:puchasedProd) {
            if(pProd.Product_Code__c != myProd.ProductCode) {
                pProd.Product_Code__c = myProd.ProductCode;
                update pProd;
            }
        }
    }
} 

Thanks and Regards

Hari G S

Hi,

I have a doubt on Self Service User.

Can't we able to write trigger on SelfServiceUser object? and can't we able to do DML operation in SelfServiceUser object using Force.com IDE?

Thanks and Regards
Hari G S

Hi,

I have a doubt in Quote Template.

I have created a new custom field in Setup->Customize->Quote->Quote Line Items->Fields. The field name is Product Description.

When i go to Quote Template I can see this newly added field. What i need to do is i need to display the actual Product Description here. That is the product description from the Product Object. What i suppose to do. The Product Code is a Standard Field in the Quote Line Item, but there is no Product Description available, i need to add this to the Quote Template. Please help.

Thanks and Regards

Hari G S

Hi,

Is there any way to import a table details into SFDC custom objects or any other objects.

Actually what i want to do is, I have some user details in an another CRM(SURADO) and I want to import those user details into SFDC. Is this possible by importing the data in the csv form or something.

Thanks and Regards

Hari G S