[SalesForce] Method to highlight a single row in an apex:dataTable

I have a dataTable as part of a Visualforce component, and I'd like to write some code to have it highlight a single row of the table, based on some value in that row's data.

Recall that an <apex:dataTable> contains multiple <apex:column> values, and it does not use an <apex:repeat> to loop through records. I would prefer to keep the dataTable for formatting reasons.

My current thought is whether I can include an <apex:outputPanel> that contains Javascript that can somehow find the parent <tr> of the current <td> and change its background-color.

Am I jumping through too many hoops? Will such a method even work, and what would it look like? Is there a simpler way to accomplish this?

My current workaround is an <apex:outputPanel> wrapping the text of a single cell, and setting the style to background-color:#FFFF00 or an empty string. It doesn't look good, and I'd prefer to highlight the entire row.

Best Answer

I am not sure if this is something you are looking for :

enter image description here

I used style per column based on a specific name to highlight a single row of the table, based on some value in that row's data (assuming row data from one column !!!)

<apex:page Controller="account_multicolor" >
<style>
.value{
background-color: #FCF7F7;}
</style>
<apex:dataTable value="{!account_val}" var="acc" rowclasses="">
<apex:column headervalue="Id" value="{!acc.Id}" style="{!IF((acc.name ='TEST'),"background-color: #0000FF;","")}"/>
<apex:column headervalue="name" value="{!acc.name}" style="{!IF((acc.name ='TEST'),"background-color: #0000FF;","")}"/>
</apex:dataTable>
</apex:page>

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

This is untested so you may need to have play, however this should return a List of the RevenueWrapper classes which contains the 4 columns you are looking to use in your VF page:

public class RevenueController{

Map<String, RevenueWrapper> ResultList = new Map<String, RevenueWrapper>(); 

public RevenueController(){
    List<AggregateResult> result =  [
    SELECT FISCAL_YEAR(Date__c) Date, Type__c, sum(Amount__c) Amount
    FROM Revenue__c
    GROUP BY FISCAL_YEAR(Date__c), Type__c];

    for(AggregateResult ar : result){

        RevenueWrapper RW = new RevenueWrapper();

        //If the RevenueWrapper already exists grab it from the Map
        if(ResultList.containsKey(String.valueOf(ar.get('Date')))){
            RW = ResultList.get(String.valueOf(ar.get('Date')));
        }

        //Set the amount
        RW.setAmount(ar);

        //Save back to the Map
        ResultList.put(String.valueOf(ar.get('Date')), RW);
    }
}

public List<RevenueWrapper> getResults() {
    return ResultList.values();
}


public class RevenueWrapper{
    public String revenueDate { get; set; }
    public Integer budgetAmount { get; set; }
    public Integer actualAmount { get; set; }
    public Integer varianceFYPercent { set; }
    public Integer varianceFYAmount { set; }

    public RevenueWrapper(){

    }

    public void setAmount(AggregateResult ar){
        revenueDate = String.valueOf(ar.get('Date'));

            //Set the amount value based on type
        if(ar.get('Type__c') == 'Budget'){
            budgetAmount = Integer.valueOf(ar.get('Amount'));
        }else if(ar.get('Type__c') == 'Actual'){
            actualAmount = Integer.valueOf(ar.get('Amount'));
        }else{ //Catch all for a type that isn't recognised
            return;
        }

    }

    public Integer getVarianceFYAmount(){
        return actualAmount - budgetAmount;
    }

    public Decimal getVarianceFYPercent(){
        if(budgetAmount != 0){
            return Decimal.valueOf((Double.valueOf(actualAmount) / Double.valueOf(budgetAmount)) * 100).setscale(1);
        } else{
            return 0;
        }
    }
}

}

[SalesForce] Using apex:outputPanel within apex:repeat

Visualforce generates unique DOM ids and, in your case, a different one for each row in the repeat. The ActionFunction (outside the repeat) does not know which row id to rerender.

Try using an apex:ActionSupport from within the apex:inputCheckbox. Called from here (within the loop), rerender will work correctly.

Best Answer

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

[SalesForce] Using apex:outputPanel within apex:repeat

Related Topic