I have a page which queries to data from a customer table. This is then displayed in a pageblocktable in a pageblock with many row.

I want to have (if possible) a pageblock that will display the details of a record based on a record being selected 'onclick' but I can't seem to figure out how to rerender the pageblock based on clicking an item in the pageblocktable. I have tried using the actionSupport but this doesn't see to work inside the pageblocktable?

Any help is appreciated.

Hi,

My query "Select l.Owner.ManagerId, l.OwnerId, l.Name From Lead l" is not giving me any results. I have tried using eclipse, SForce explorer and even th debugger, but it returns "No such column 'ManagerId' on entity 'Name'." I am able to access all other fields from the User object.

Can someone confirm me if this is a bug or whether this field is not accessible.

Thanking you in anticipation

Siddharth

Hi All,

I am trying to integrate public sites to show data from google blogs, but the issue is that everytime I fetch data I am asked to provide access to gdata API. I am using Google toolkit and AuthSub authentication process. Also I want this authentication process to be hidden from end user and should actually be once. Is there a API where i can send google signing credentials in URL and that returns me token to access my data anytime.

Thanks

Siddharth

Hi All,

Is there a way to delete all the data from Salesforce production accounts with using data loader. I am looking for a button or a link in salesforce to perform this action.

Thanks

Siddharth

We have a managed package which uses FLEX, can some tell me how to set the value for ClientId in Flex in SOAP Header.

Thanks

Siddharth

Astadia

We have installed a force.com package in sandbox environment using the system admin profile. While installation we turned off the apex warning and configured field level security. It installed smoothly but for system admin profile client is not getting access to all the apex classes.

When we go to profile and try to edit and add apex class access it doesnot show all the classes there, its only one apex class that has got access out of 20 classes. However i can see all the classes available under develeopement -> Apex Class section.

Any idea why this is happening as it is only for this install or is it some issue with spring 09 release because for all other instances it worked fine.

Thanks

Siddharth

All,

We are facing issues with the deployment of Dashboards through the manages package. 

We have components in one of our Dashboard that display the Top and Bottom 5 rows with certain value e.g. Top 5 Campaigns with Max ROI. 

Issue #1: Dashboard component setting not set during New Package InstallationWhen this Dashboard is deployed in a freash SF instance through a Managed Package, all components are displayed but the setting in "Maximum Values Displayed" field of the Components is not reflected. This results in all records getting displayed in the Component (instead of Top '5'). 

Issue #2: Dashboard changes not reflected in Package UpgradeIt appears that when we install a managed package upgrade, we do not get the benefit of the new components in a Dashboard. We have a managed application installed in our SF instance and when an upgrade to the Package was released, Dashboard changes (new components, deleted components and changed components) didn't reflect even though the supporting custom reports got deployed. We have tired installing the package upgrade in 3 different instances, but the issue persists. 

Thanks

Siddharth

I have a page which queries to data from a customer table. This is then displayed in a pageblocktable in a pageblock with many row.

I want to have (if possible) a pageblock that will display the details of a record based on a record being selected 'onclick' but I can't seem to figure out how to rerender the pageblock based on clicking an item in the pageblocktable. I have tried using the actionSupport but this doesn't see to work inside the pageblocktable?

Any help is appreciated.

I have a before trigger that calls this class which auto assigns the region and the ownerid to the account based on the recordtype, state and zip of the region object. the region object holds all the assignments. It works great but when I execute a batch load through data laoder I hit too many script statements 200001 error. any way i can fix?

public with sharing class AccountUtilities
{
public static void acctAssign(List<Account> aList)
{
List<region__c> rList = [select id, zip_start__c, zip_end__c, state__c,sales_user__c, business_unit__c, recordTypeId from region__c];
Map<Id,RecordType> rtMap = new Map<Id,RecordType>([Select id,Name from RecordType where sObjectType IN ('Account','region__c')]);
for(Account a:aList)
{
try
{
for(integer i= 0; i< rList.size(); i++)
{
String billingPostalCode= String.valueOf(a.BillingPostalCode);
if(a.billingstate== rList.get(i).state__c && a.Protected__c != true && rtMap.get(a.recordtypeid).Name == rtMap.get(rList.get(i).recordtypeid).Name && a.business_unit__c == tList.get(i).business_unit__c)
{
if(a.billingPostalCode >= rList.get(i).zip_start__c && a.billingPostalCode<=rList.get(i).zip_end__c || rList.get(i).zip_start__c ==null && rList.get(i).zip_end__c ==null )
{
a.region__c = rList.get(i).id;
a.OwnerId = rList.get(i).sales_user__c;
}
}
}
}
catch (System.Exception e)
{
// process exception
}

}
}

Has anyone created a code for this? We would like to create a new field that returns the last time a lead, or contact, was called. The problem with the "last activity" field is that it includes mass emails which doesn't really help us. Figure we need to use Apex code to query the type of activity etc. and bring back the date of the last phone call. 

Hi,

My query "Select l.Owner.ManagerId, l.OwnerId, l.Name From Lead l" is not giving me any results. I have tried using eclipse, SForce explorer and even th debugger, but it returns "No such column 'ManagerId' on entity 'Name'." I am able to access all other fields from the User object.

Can someone confirm me if this is a bug or whether this field is not accessible.

Thanking you in anticipation

Siddharth

We have a managed package which uses FLEX, can some tell me how to set the value for ClientId in Flex in SOAP Header.

Thanks

Siddharth

Astadia

Hi,

We are facing a problem in updating Sales Price for an Opportunity Line Item.

As per the API document the label Sales Price on the screen represents field Unit Price in Opportunity Line Item Object.(Is this correct??)

We are making an API call to update a few custom fields along with Unit Price. Other Fields are getting updated but Unit Price is not getting updated. Our objective is to set Sales Price to a value equal to value of a Custom Field.

Is there some catch into it that we are missing?

Any help would be appreciated.

Hi,

 There is a problem in getting the dates. I update the Opportunity table and insert the ADI_Last_Calculated_date as the Server Timestamp and at the same time SalesForce updates the last modified date for the opportunity. So there is difference in the Time. Can anyone suggest why is it so? I have tried using different date formats.

***********************************Function Description*********************************

Public Function updateRevenueToOpportunity(ByVal ID As String, ByVal Opp_ExpTotalValue As Integer, ByVal Opp_TotalValue As Integer, ByVal Opp_PeakAnnualValue As Integer, ByVal Opp_ExpPeakAnnualValue As Integer)

Dim saveResults() As SaveResult

Dim updateOpp As sObject = New sObject

Dim ilength = 0, iError As Integer = 0

Dim xElemnt(6) As System.Xml.XmlElement

Dim Doc As New System.Xml.XmlDocument

Try

xElemnt(0) = Doc.CreateElement("ADI_Expected_Total_Amount__c")

xElemnt(0).InnerText = Opp_ExpTotalValue

xElemnt(1) = Doc.CreateElement("ADI_Total_Amount__c")

xElemnt(1).InnerText = Opp_TotalValue

xElemnt(2) = Doc.CreateElement("ADI_Peak_Annual_Amount__c")

xElemnt(2).InnerText = Opp_PeakAnnualValue

xElemnt(3) = Doc.CreateElement("ADI_Expected_Peak_Annual_Amount__c")

xElemnt(3).InnerText = Opp_ExpPeakAnnualValue

xElemnt(4) = Doc.CreateElement("ADI_Last_Calculated_Date__c")

xElemnt(4).InnerText = Replace(Format(objService.getServerTimestamp.timestamp, "yyyy-MM-ddThh:mm:ss.millisZ"), "illi", "", 1)

xElemnt(5) = Doc.CreateElement("ADI_Generate_Forecast__c")

xElemnt(5).InnerText = "False"

updateOpp.Id = ID

updateOpp.Any = xElemnt

updateOpp.type = "Opportunity"

saveResults = objService.update(New SFPartner.sObject() {updateOpp})

Dim Err As [Error]

While (ilength < saveResults.Length)

If saveResults(ilength).success Then

_Logger.LogInfo("OpportunityLineItem successfully updated with " + saveResults(ilength).id + " as the ID")

Else

While (iError < saveResults(ilength).errors.Length)

Err = saveResults(ilength).errors(iError)

_Logger.LogError("Opportunity Line Item could not be updated : '" + Err.message + "'", "updateRevenueToOpportunitylineItem")

iError = iError + 1

End While

End If

ilength = ilength + 1

End While

Catch ex As Exception

Throw New Exception("Failed to update Opportunity")

End Try

End Function

*************************************Output Result***************************************

OpportunityID - 006000000077XUuAAM  

LastModifiedDate - 5/19/2005 5:01 PM   

Name - Punit Opportunity 1 Product

ADI_Last_Calculated_date  -  5/19/2005 10:31 AM