Anyone know how I can create a formula that will return True if a given case has child cases and False if not?

Thanks! 

I am getting the following error on a custom Visualforce page:

Type is not visible: test

Vforce Page:

<apex:page controller="EditCases" tabstyle="Case"> <apex:sectionHeader title="Edit Cases" subtitle="Bug Meeting Mass Update" /> <apex:form > <apex:pageBlock mode="edit" title="Mass Update Cases"> <p><apex:outputText value="{!headerMessage}" /></p> <h3>Report Criteria: </h3> <p></p> <table style="width: 100%"> <tr> <td rowspan="3" width="50px" height="50px"><img src="https://ssl.salesforce.com/servlet/servlet.ImageServer?id=01500000000crMo&oid=00D00000000hZTB&lastMod=1235399976000"></img></td> <td>Sub Status contains <i>bug</i> </td> </tr> <tr> <td>ETA is <i>NULL</i></td> </tr> <tr> <td>Status is <i>Pending</i> or <i>Suspended</i></td> </tr> </table> <br /> <apex:pageblockSection id="Cases" columns="1" title="Bug Meeting Cases" rendered="{!canEdit}"> <apex:pageblocktable align="center" value="{!Cases}" var="Case" title="Cases" width="100%"> <apex:column headerValue="Case Number" width="10%"><apex:outputLink value="/{!Case.ID}">{!Case.CaseNumber}</apex:outputlink></apex:column> <apex:column headerValue="Account" width="15%"><apex:outputLink value="/{!Case.Account.ID}">{!Case.Account.Name}</apex:outputlink></apex:column> <apex:column headerValue="Bug ID" width="50%"><apex:inputField value="{!Case.Bug_ID__c}" /></apex:column> <apex:column headerValue="Subject" width="50%"><apex:inputField value="{!Case.Subject}"/></apex:column> <apex:column headerValue="Bug Description" width="50%"><apex:inputField value="{!Case.Bug_Description__c}" /></apex:column> <apex:column headerValue="Summary" width="50%"><apex:inputField value="{!Case.Bug_Meeting_Summary__c}" /></apex:column> <apex:column headerValue="ETA" width="50%"><apex:inputField value="{!Case.ETA_version__c}" /></apex:column> <apex:column headerValue="Assigned To" width="50%"><apex:inputField value="{!Case.Bug_Assigned__c}" /></apex:column> <apex:column headerValue="Status" width="15%"><apex:inputField value="{!Case.Status}"/></apex:column> <apex:column headerValue="Sub Status" width="15%"><apex:inputField value="{!Case.Sub_Condition__c}"/></apex:column> </apex:pageblockTable> </apex:pageblockSection> <p/> <apex:pageBlockButtons > <apex:commandButton action="{!save}" value="Save Cases" rendered="{!canEdit}" /> <apex:commandButton action="{!cancel}" value="Cancel" /> </apex:pageblockButtons> </apex:pageBlock> </apex:form> </apex:page>

Apex Class+Test:

public class EditCases { List<Case> cases; String headerMessage; Boolean canEdit = true; public EditCases() { cases = getcases();+ headerMessage = getHeaderMessage(); canEdit = getCanEdit(); } public List<Case> getCases() { if (cases == null) { cases = [ select Id, CaseNumber, Priority, Status, Subject, Case.Account.ID,Case.Account.Name,Case.Bug_ID__c,Case.Bug_Description__c,Case.Bug_Meeting_Summary__c,Case.ETA_version__c, CreatedDate,Sub_Condition__c, Bug_Assigned__c from Case where sub_condition__C like '%Bug%' and ETA_version__C = null and (Status = 'Pending' or Status = 'Suspended') order by CaseNumber]; return cases; } else { return cases; } } public String getHeaderMessage() { String message = ''; if (cases.size() == 0) { message = 'There are no cases to edit.'; canEdit = false; } else { canEdit = true; } return message; } public Boolean getCanEdit() { return canEdit; } // Action that is executed if Save button is clicked public PageReference save() { // Return to Cases tab page after editing PageReference returnPage = new PageReference('/500/o'); // Save all changes update cases; return returnPage; } // Action that is executed if Cancel button is clicked. public PageReference cancel() { // Return to Cases tab page after editing PageReference returnPage = new PageReference('/500/o'); return returnPage; } public static testMethod void tesEditCases() { // Create the necessary records to test automatic order creation // Create a case // This assumes that the pick list values used exist for // - Priority (High) // - Status (New) // - Origin (Phone) Case testCase = new Case( Priority = 'High', Subject = 'Test Subject', Status = 'Pending', LPTicket__c = 'LTK12345X', sub_condition__C = 'Bug Meeting', // ETA_version__C = '8.4', // Bug_ID__C = '1234', Origin = 'Phone'); insert testCase; //************************** // Test EditCases controller //************************** PageReference pageRef = Page.EditCases; Test.setCurrentPage(pageRef); // Create an instance of the controller EditCases editCasesController = new EditCases(); // Get the list of cases from the controller List<Case> casesToEdit = editCasesController.getCases(); // Verify that there is at least one case to edit system.assertEquals(casesToEdit.size() > 0, true); // Retrieve the header message String editCasesMessage = editCasesController.getHeaderMessage(); // Verify that the header message is blank system.assertEquals(editCasesMessage, ''); // Check the Cancel action String canceleditCasesPage = editCasesController.cancel().getUrl(); // Check the save action String editCasesPage = editCasesController.save().getUrl(); } }

Nothing has changed in my environment or in my apex class and Vforce pages. Any help or suggestions welcome.

We have parent child account relationships. I currently calculate the RMR rollup on child accounts.

I want the parent account to also display of all RMR rollups on child accounts.

How can I achieve this?

Thanks 

Hi,

I know I can pass spaces in a URL using %20. I was wondering if it is possible to pass line breaks as well?

Any ideas?

Hi,

I have a field called sub status which tracks the different departments who handle cases.

My trigger sums time between each status change in new custom fields on the case object (in hours). My problem is, that if a case is assigned a sub_status of Deployment and then resolve (closed) with the same sub_status, it doest count the time.

Can anyone take a quick look and see what I should change? I dont know how make sure that it sums the time between statuses when the case is closed, even if the sub_status didnt change

ii,

I have two Vforce pages.

I want to show page X if the case is high priority and show page Y if it is not.

How can I do this within Vforce? 

we have account hierarchies: parent and child accounts.

The parent account has an account team assigned. Can I reference account team members in custom fields on the child levels?

If not, is there any way with apex triggers to make sure that the parent team is copie to the child team each time an update is administered? 

I would like to customize the following trigger to PROMPT the user when a duplicate value is found and ask if he wants to continue. If he clicks yes, then it should save the value

trigger ContactDuplicateTrigger on Contact (before insert) { for (Contact c : Trigger.new){ Contact[] contacts= [select id from Contact where Email = :c.Email]; if (contacts.size() > 0) { c.LastName.addError('Contact cannot be created - Contact already exists'); } }}

Hi,

I was wondering whether there was any attribute for creating inline editable fields.

I am particulalry looking for the same experience as the standard inline editing option in Salesforce = Doubleclicking on the field allows you to edit it.

Nothing found in the documentation.

How do I convert these conditions into SWITCH or CASE format:

if (oldCase.Sub_Condition__c == 'Support - 2nd Tier') { updatedCase.Time_With_Tier2__c += timeSinceLastStatus; } else { if (oldCase.Sub_Condition__c == 'Support - 3rd Tier') { updatedCase.Time_With_Tier3__c += timeSinceLastStatus; } else { if (oldCase.Sub_Condition__c == 'Customer - Confirmation of Fix')...

I have a picklist on a parent field with dropdown options from 1 through 50.

I want to have a formula on the child account which copies the same selection from the parent.

I have tried combinations of CASE, ISPICKLIST, OR and evrey other option to no avail.

Any suggestions? 

We have a custom field called WAITING_FOR on the case level with 4 options:

SUPPORT

DEVELOPMENT

PRODUCTION

CUSTOMER 

We'd like to populate 4 additional fields on the case level indicating the time spent in each status in days.

How can we achieve this with triggers? 

I use account hierarchies and have PARENT accounts which have multiple CHILD accounts.

The PARENT account contains a custom field which is only displayed on the parent level. How can I pull this field into the CHILD accounts to be displayed?

Also, is there any way to include this field in any of the reports for CHILD accounts? 

Can I create a validation rule which checks if a value in a picklist object in contains a certain strong?

I have a picklist of the following

SMB_Phone

SMB_Email

ENT_Phone

ENT_Email

I dont want to reference each value individually - how can I achieve this?

Hi,

I am getting " Unable to fetch organization details " error. I have verified the userid, password and security key. I am using the Production/Developer Editiion with a trial account. 

My environment is MyEclipse. Could someone give me some pointers to debug and resolve this??

Thank You.

Hi,

I have a field called sub status which tracks the different departments who handle cases.

My trigger sums time between each status change in new custom fields on the case object (in hours). My problem is, that if a case is assigned a sub_status of Deployment and then resolve (closed) with the same sub_status, it doest count the time.

Can anyone take a quick look and see what I should change? I dont know how make sure that it sums the time between statuses when the case is closed, even if the sub_status didnt change

I would like to customize the following trigger to PROMPT the user when a duplicate value is found and ask if he wants to continue. If he clicks yes, then it should save the value

trigger ContactDuplicateTrigger on Contact (before insert) { for (Contact c : Trigger.new){ Contact[] contacts= [select id from Contact where Email = :c.Email]; if (contacts.size() > 0) { c.LastName.addError('Contact cannot be created - Contact already exists'); } }}

Hi,

I was wondering whether there was any attribute for creating inline editable fields.

I am particulalry looking for the same experience as the standard inline editing option in Salesforce = Doubleclicking on the field allows you to edit it.

Nothing found in the documentation.

I have a picklist on a parent field with dropdown options from 1 through 50.

I want to have a formula on the child account which copies the same selection from the parent.

I have tried combinations of CASE, ISPICKLIST, OR and evrey other option to no avail.

Any suggestions? 

I use account hierarchies and have PARENT accounts which have multiple CHILD accounts.

The PARENT account contains a custom field which is only displayed on the parent level. How can I pull this field into the CHILD accounts to be displayed?

Also, is there any way to include this field in any of the reports for CHILD accounts?