Hi,

I've been working through some SOQL queries, as I'm trying to determine how many open Tasks are attached to our cases.

So I've got a SOQL query like this as part of a batchable class:

Select l.Id, l.Open_Tasks__c, l.CaseNumber, (Select Id, WhatID, IsClosed From Tasks t where t.IsClosed = False and t.IsDeleted = False) From Case l

In this case, if I don't filter out the deleted tasks, it is being returned in the result.

I've got another variation where I don't seem to need to include the filter, where I've built a set of case IDs at the beginning:

Select l.Id, l.Open_Tasks__c,
            (Select Id From Tasks where IsClosed = False)
            From Case l where Id in :CaseIDs

[This logic is done in an Apex trigger]

I'm not sure what I'm missing something here -- and I'm getting the results that I expect now if I include the IsDeleted filter (in both cases) -- but I'm wondering what causes the difference in the results as I find it a bit odd.

Hi,

I'm wondering if there is any way to determine what Dashboard a Dashboard Visualforce Page is on as part of the dashboard.

If I try something that looks at document.location.href, I get something on *.visual.force.com -- and it is referring to the specific visualforce page, and not the dashboard that is "hosting" the visualforce page.  Where what I'd like is the URL of the actual dashboard.

Does anyone have any suggestions?

Thanks,

Michael

I'm working with the Inline Account Hierarchy App, and love the idea.

However, one thing that I'm struggling with is that we want to add some additional fields to the display.  This is easy, with a little bit of Apex and VF.  However,  what I'd really like to do is get it so we have a table view instead so columns line up.

Perhaps I just want to get rid of the tree view piece and just entirely replace it -- but any way to drop things into columns that line up would be ideal.

Anyone have any ideas here?

Hopefully this is an easy question.  I'd rather not have to dive into and code something at the Apex level for this.

I'd like to be able to output a string into a fixed width field when I use apex:outputText

I'd like to output it and say that if the string I'm outputting is less than a specific width, it should be padded out enough to match that width.

I can't really use a table in this case, unfortunately.

Any good ideas?

Hi All,

I have a requirement to show # of open Task on Lead Detailpage. Below is the logic that we are planning to implement. I would like tocheck with you if any one has implemented similar functionality handling BULK insert/update.If so could you please share the code?

Trigger on Task <after insert after update>

{

    for (Task thistask : Trigger.new)

      {

    // Get all leads assosited to Tasks

    if (WhoId.startsWith('00Q'))               

      leadIdToUpdateList.add(taskWhoId.WhoId);

     }

FOR each Lead

           SelectCount() from Task where whoId=LeadId and Status=Completed

           Updatecustom field “ Open Task” on  Lead object

End Loop   

}

Thank You . 

Has anyone had any luck creating a formula field that calculates the difference between two dates but does not include weekends in the calculation?  I have searched and did find one example, however, it does not work for every date... It has to do with the rounding... This is what I have so far:

IF(AND(MOD( Date_Released_to_Sales__c -DATE(1900,1,7),7)< (Date_Released_to_Sales__c- Date_to_U_W__c), ((Date_Released_to_Sales__c- Date_to_U_W__c)<7)),((Date_Released_to_Sales__c- Date_to_U_W__c)-2), ((Date_Released_to_Sales__c- Date_to_U_W__c)-(2 * ((Date_Released_to_Sales__c- Date_to_U_W__c)/7))))

((Date_Released_to_Sales__c- Date_to_U_W__c)-(2 * ((Date_Released_to_Sales__c- Date_to_U_W__c)/7))))

I thought I might need to use ceiling but that did not solve the problem either....

Any help would be greatly appreciated!!

Fred

Hopefully this is an easy question.  I'd rather not have to dive into and code something at the Apex level for this.

I'd like to be able to output a string into a fixed width field when I use apex:outputText

I'd like to output it and say that if the string I'm outputting is less than a specific width, it should be padded out enough to match that width.

I can't really use a table in this case, unfortunately.

Any good ideas?

<apex:page standardController="Fixture_Order__c" extensions="conSEditOverrideFixtureOrder" 
id="mypage">
Hello
</apex:page>

public class conSEditOverrideFixtureOrder {
Fixture_Order__c fixordobj; 

private String vid; 


public conSEditOverrideFixtureOrder(ApexPages.StandardController controller) { 

this.vid = ApexPages.currentPage().getParameters().get('id'); 
reset();

} 

public PageReference reset() { 

if(fixordobj.Approval_Status__c=='Approved'){
 PageReference editPage = new PageReference('/'+this.vid+'/e—retURL=' + this.vid);
 editPage.setRedirect(true);
 return editPage;
}else{
PageReference errPage = new PageReference('/apex/editFixtureOrderError');
 errPage.setRedirect(true);
 return errPage;
 
}

return null; 

} 

public String getApprovalStatus(){
 return this.fixordobj.Approval_Status__c;
}

public Fixture_Order__c getFixtureOrder() { 

if(fixordobj == null) reset(); 

return fixordobj; 

} 


public void setLead(Fixture_Order__c leaddet) { 

fixordobj = leaddet; 

} }

Can anyone please help to understand the cause? Appreciate all your valuable feedbacks.