Hi Guys,

I have two objects Target List and Selling Area. Also have Target List Member object as junction of both. User can create target list and add selling area based on some search criteria. I am storing that SOQL in query field of Target List. Overnight batch to run through all target list get the query and iterate over query result and insert Target List Member records. But Batch class gives me Too Many DML rows error while insertion.

I am testing this with 4 target lists Each of them have separate query. These quries return 2764 records of selling area. Means 2764*4 target list members.  Now requirement is one target list can have up to 50K-80K selling area, so setting scope to 1 won't solve my problem. Any suggestion or workaround?

Thanks,

Ankur

Hi,

I have visualforce page where I have five level search criterias (SearchField1.. SearchField5) and User will enter input for those search fields. On click of search my dynamically generated query will return results and display on grid with pagination. Current page size is 200 and I am getting more than 2500 records for some filter criteria. If my search result returns more than 2500 records then I am getting viewstate limit exceeds error message.

Any idea or recommendation to resolve this?

Thanks,

Ankur

Hi,

I have requirement to sort cases by Milestone due date. Salesforce.com has CaseMilestone object which has Target Date and I guess that is Milestone due date. I want to create List view on Case object, but while creating new view I am not able to extract Case Milestone fields. Why cant we have SlaDueDate field just like SlaExitDate and SlaStartDate on case? It will help us to find out when is the next milestone due date.

Any idea how to achieve this?

Thanks,

Ankur 

Hi guys,

I have a visualforce page at the bottom of Support Console. This visualforce page will helps support staff to add Time entry for case on which they are working. Time Entry has Master detail relationship with Cases. Once reps click on Save button to it will store entry in Time Entry custom object and after that it should refresh/reload active case Tab on which he/she is working. I have command button named save which calls action method in controller. Once action is performed I need to refresh active case tabs. I am able to add entry in object, but I dont see any way to refresh active case tabs.

Any idea how to refresh/reload active case tab after saving entry in time entry object? I can't use client side onclick javascript because it invokes before action method call. I need some mechanism to refresh after my action method completes successfully.

Thanks,

Ankur

Hi,

I have created Flex grid, on while I want to populate Account sObject's data.

Code of mxml file, After successful build, I have uploaded .swf file into static resource.

<?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" xmlns:salesforce="http://www.salesforce.com/" creationComplete="login(event)"> <salesforce:Connection id="apex" serverUrl="https://www.salesforce.com/services/Soap/u/9.0" /> <mx:Script> <![CDATA[ import mx.collections.ArrayCollection; import com.salesforce.results.QueryResult; import mx.utils.ObjectUtil; import mx.controls.Alert; import com.salesforce.AsyncResponder; import com.salesforce.objects.LoginRequest; private function login(event:Event):void { var lr:LoginRequest = new LoginRequest(); // lr.server_url = parameters.surl; // lr.session_id = parameters.sid; Alert.show(parameters.session_id); Alert.show(parameters.server_url);

// session_id and serverurl is giving authentication error in Firefox, IE, Safari

lr.session_id = parameters.session_id; lr.server_url = parameters.server_url;

 // username and password is working fine only in Firefox, and IE, Safari gives connection error

/* lr.username = "SFDC_username" lr.password = "SFDC_password"; */

lr.callback = new AsyncResponder(loadData, handleFault); apex.login(lr); } [Bindable] private var accountList:ArrayCollection = new ArrayCollection(); private function handleFault(fault:Object):void { Alert.show(ObjectUtil.toString(fault)); } private function loadData(lr:Object):void { apex.query("Select Name, Phone, Type From Account", new AsyncResponder( function(qr:QueryResult):void { if (qr.size > 0) { accountList = qr.records; } }, handleFault) ); } ]]> </mx:Script> <mx:DataGrid dataProvider="{accountList}" left="10" right="10" top="10" bottom="10"> <mx:columns> <mx:DataGridColumn dataField="Name"/> <mx:DataGridColumn dataField="Phone"/> <mx:DataGridColumn dataField="Type"/> </mx:columns> </mx:DataGrid> </mx:Application>

<apex:page > <!-- Begin Default Content REMOVE THIS --> <h1>Congratulations</h1> This is your new Page: SimpleFlexGrid <!-- End Default Content REMOVE THIS --> <apex:flash id="flexSOs" src="{!$Resource.SimpleFlexGrid}" height="100%" width="100%" flashvars="session_id={!$Api.Session_ID}&server_url={!$Api.Partner_Server_URL_90}"/> </apex:page>

While loading  /apex/SimpleFlexGrid page, I am  following error;

(com.salesforce.results::Fault)#0
  context = (null)
  detail = (Object)#1
    fault = (Object)#2
      exceptionCode = "INVALID_SESSION_ID"
      exceptionMessage = "Invalid Session ID found in SessionHeader: Illegal Session"
      xsi:type = "sf:UnexpectedErrorFault"
  faultcode = "sf:INVALID_SESSION_ID"
  faultstring = "INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session"

Flashvars in apex:flash tag gives above error in all browser.

But if I remove flashvars, and hardcode username, and password in actionScript, everything is working fine except in safari browser.

Any help on flashvars session_id, server_url would be appreciated.

Thanks,

Ankur

Hi,

I want to delete all meta-data components which I deployed from Force.com IDE. Is there any ways to clear org? 

Regards,

Ankur

While creating custom object, I have observed IsDeleted field, which is neither standard field nor custom field.

When I delete the records of that custom object. All deleted records goes into recycling bin. But Recycling Bin shows only latest 5000 records. What about older deleted records. SFDC db keep those records?

I also want to retrieve records, but from recycling bin I can undelete only last 5000 records.  Is there any way?

Also this SOQL:  SELECT Id, isDeleted FROM MyObj__c WHERE isDeleted = true ALL ROWS is not working on my Force.com IDE.

Any help would be appreciated

Thanks,

Ankur

I come to know, CRM obejcts (*) are not included in enterprise/ unlimited edition of Force.com. One can buy that with additional fee.

*CRM objects are defined as cases, solutions, campaigns, leads, opportunities, products, and forecasts. 

If I buy with additional fee, does it bring all CRM functionalities or we need to implement it.

Some of the CRM functionalities which I am looking for are;

• Web-to-lead generation
• Lead de-duplication
• Lead conversion
• Rule assignment
• Opportunity Management
• Campaign Management
• Territory Management

Any help would be appreciated. 

Thanks,

Ankur 

Hey folks,

I have existing db schema in MS SQL Server 2005, and I want to create custom objects in Force.com from that tables. Do we have any utility/tools which creates custom Obejcts from existing relational tables?

This is urgent. Any help would be appreciated.

Regards,

Ankur

Wsdl2java (Axis 2.0) generates class extension is properly. But in Apex, generate Apex from WSDL feature is not giving appropriate class relationship.

e.g. I have following xsd in wsdl

<xsd:complexType name="Profile">
      <xsd:simpleContent>
              <xsd:extension base="xsd:string">
                 <xsd:attribute name="lang" type="xsd:string" use="optional"/>
              </xsd:extension>
      </xsd:simpleContent>
</xsd:complexType>

<xsd:complexType name="UserProfile">
        <xsd:simpleContent>
            <xsd:extension base="Profile">
                <xsd:attribute name="code" type="xsd:string"/>
            </xsd:extension>
        </xsd:simpleContent>
</xsd:complexType>

WSDL2Apex generates UserProfile and Profile classes, but dont have any relationship. In java Profile class has String _value containment. But Apex class does not have that containment too.

Any help would be appreciate.

Thanks.

Ankur

Is there any way to create SOAP request envelop and send it to service endpoint? Just like SAAJ (SOAP with Attachment API for Java). Do we have API which deal with SOAP envelop?

Hi Guys,

I have two objects Target List and Selling Area. Also have Target List Member object as junction of both. User can create target list and add selling area based on some search criteria. I am storing that SOQL in query field of Target List. Overnight batch to run through all target list get the query and iterate over query result and insert Target List Member records. But Batch class gives me Too Many DML rows error while insertion.

I am testing this with 4 target lists Each of them have separate query. These quries return 2764 records of selling area. Means 2764*4 target list members.  Now requirement is one target list can have up to 50K-80K selling area, so setting scope to 1 won't solve my problem. Any suggestion or workaround?

Thanks,

Ankur

Hi guys,

I have a visualforce page at the bottom of Support Console. This visualforce page will helps support staff to add Time entry for case on which they are working. Time Entry has Master detail relationship with Cases. Once reps click on Save button to it will store entry in Time Entry custom object and after that it should refresh/reload active case Tab on which he/she is working. I have command button named save which calls action method in controller. Once action is performed I need to refresh active case tabs. I am able to add entry in object, but I dont see any way to refresh active case tabs.

Any idea how to refresh/reload active case tab after saving entry in time entry object? I can't use client side onclick javascript because it invokes before action method call. I need some mechanism to refresh after my action method completes successfully.

Thanks,

Ankur

Hi,

I have created Flex grid, on while I want to populate Account sObject's data.

Code of mxml file, After successful build, I have uploaded .swf file into static resource.

<?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" xmlns:salesforce="http://www.salesforce.com/" creationComplete="login(event)"> <salesforce:Connection id="apex" serverUrl="https://www.salesforce.com/services/Soap/u/9.0" /> <mx:Script> <![CDATA[ import mx.collections.ArrayCollection; import com.salesforce.results.QueryResult; import mx.utils.ObjectUtil; import mx.controls.Alert; import com.salesforce.AsyncResponder; import com.salesforce.objects.LoginRequest; private function login(event:Event):void { var lr:LoginRequest = new LoginRequest(); // lr.server_url = parameters.surl; // lr.session_id = parameters.sid; Alert.show(parameters.session_id); Alert.show(parameters.server_url);

// session_id and serverurl is giving authentication error in Firefox, IE, Safari

lr.session_id = parameters.session_id; lr.server_url = parameters.server_url;

 // username and password is working fine only in Firefox, and IE, Safari gives connection error

/* lr.username = "SFDC_username" lr.password = "SFDC_password"; */

lr.callback = new AsyncResponder(loadData, handleFault); apex.login(lr); } [Bindable] private var accountList:ArrayCollection = new ArrayCollection(); private function handleFault(fault:Object):void { Alert.show(ObjectUtil.toString(fault)); } private function loadData(lr:Object):void { apex.query("Select Name, Phone, Type From Account", new AsyncResponder( function(qr:QueryResult):void { if (qr.size > 0) { accountList = qr.records; } }, handleFault) ); } ]]> </mx:Script> <mx:DataGrid dataProvider="{accountList}" left="10" right="10" top="10" bottom="10"> <mx:columns> <mx:DataGridColumn dataField="Name"/> <mx:DataGridColumn dataField="Phone"/> <mx:DataGridColumn dataField="Type"/> </mx:columns> </mx:DataGrid> </mx:Application>

<apex:page > <!-- Begin Default Content REMOVE THIS --> <h1>Congratulations</h1> This is your new Page: SimpleFlexGrid <!-- End Default Content REMOVE THIS --> <apex:flash id="flexSOs" src="{!$Resource.SimpleFlexGrid}" height="100%" width="100%" flashvars="session_id={!$Api.Session_ID}&server_url={!$Api.Partner_Server_URL_90}"/> </apex:page>

While loading  /apex/SimpleFlexGrid page, I am  following error;

(com.salesforce.results::Fault)#0
  context = (null)
  detail = (Object)#1
    fault = (Object)#2
      exceptionCode = "INVALID_SESSION_ID"
      exceptionMessage = "Invalid Session ID found in SessionHeader: Illegal Session"
      xsi:type = "sf:UnexpectedErrorFault"
  faultcode = "sf:INVALID_SESSION_ID"
  faultstring = "INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session"

Flashvars in apex:flash tag gives above error in all browser.

But if I remove flashvars, and hardcode username, and password in actionScript, everything is working fine except in safari browser.

Any help on flashvars session_id, server_url would be appreciated.

Thanks,

Ankur

Hi,

I want to delete all meta-data components which I deployed from Force.com IDE. Is there any ways to clear org? 

Regards,

Ankur

Wsdl2java (Axis 2.0) generates class extension is properly. But in Apex, generate Apex from WSDL feature is not giving appropriate class relationship.

e.g. I have following xsd in wsdl

<xsd:complexType name="Profile">
      <xsd:simpleContent>
              <xsd:extension base="xsd:string">
                 <xsd:attribute name="lang" type="xsd:string" use="optional"/>
              </xsd:extension>
      </xsd:simpleContent>
</xsd:complexType>

<xsd:complexType name="UserProfile">
        <xsd:simpleContent>
            <xsd:extension base="Profile">
                <xsd:attribute name="code" type="xsd:string"/>
            </xsd:extension>
        </xsd:simpleContent>
</xsd:complexType>

WSDL2Apex generates UserProfile and Profile classes, but dont have any relationship. In java Profile class has String _value containment. But Apex class does not have that containment too.

Any help would be appreciate.

Thanks.

Ankur