[SalesForce] How to use If Condition in Apex: pageBlockTable

I'm trying to display history of action performed on custom object 'Reservation' in VisualForce page in table using apex:pageBlockTable.

I have following method in controller:

public List<Reservation__History> getReservationHistory()
{
    Reservation__c rsv= (Reservation__c)currentcontroller.getRecord();
    List<Reservation__History> history = [SELECT ParentId, OldValue, NewValue, Field, CreatedById, CreatedDate FROM Reservation__History WHERE parentId = : rsv.Id ORDER BY CreatedDate DESC];
    return history;
}

And I'm calling this method in apex:pageBlockTable as follows:

<apex:pageBlockTable value="{!ReservationHistory}" var="history">
   <apex:column headerValue="Date" value="{!history.CreatedDate}"/>
   <apex:column headerValue="User" value="{!history.CreatedById}"/>               
   <apex:column headerValue="Action" value="!IF(history.OldValue='' AND history.NewValue='', 'Created', Changed '{!history.Field}' from '{!history.OldValue}' to '{!history.NewValue}')"/>               
</apex:pageBlockTable>

For "Action" column, if condition I tried above is not working. I want to display Action as 'Created' if both OldValue and NewValue are '' else display a sentence "Changed '{!history.Field}' from '{!history.OldValue}' to '{!history.NewValue}'".

Can anybody please let me know how to conditionally vary content in 'value' of apex:column for above scenario?

Best Answer

To use IF condition and to join conditions in Visualforce page, you should use one of the following approaches:

{!IF(AND(field1 <condition> value, field2 <condition> value), "Show on True", "Show on False")}

{!IF(field1 <condition> value && field2 <condition> value, "Show on True", "Show on False")}

So in your case, to be able to get the first value to be true, your code should look like something as below (I prefer == for comparison to make it clear and not confuse with assignment)

{!IF(history.OldValue == '' && history.NewValue == '', "Created", "Changed history.Field from history.OldValue to history.NewValue}")}"

Notice few things here:

You should enclose the condition within {}, which seems to be missing in your code posted
You use ! with the IF and not with the field names in this case (as mentioned above)

Make necessary adjustments in case of other issues, but this should be your direction. You can refer for more details on how to construct expressions in VF page on its documentation here.

Edit --

Goto w3school code editor http://www.w3schools.com/tags/tryit.asp?filename=tryhtml_button_test

and run below code

<!DOCTYPE html>
<html>
<body>

<button type="button" onclick="if(true){
                                  alert('this is if part');
                              }else{
                                 alert('this is else part'); 
                               }">Click If!</button>

<button type="button" onclick="if(false){
                                  alert('this is if part');
                              }else{
                                 alert('this is else part'); 
                               }">Click Else!</button>
</body>
</html>

[SalesForce] How to use 2 pageblockTable values in 1 pageBlocktable

Here the VF page is having 3 variables that is controlling the visibility of the tables/sections: "NoMatch", "Match" and "SerchMatch". Match is used to show the table which you want to displace without search, NoMatch is used to displace record not found text msg section and SerchMatch is used to displace your search result. One you hit the search button your search method is called and performs the search. Here we are controlling the visibility controlling variables.

Please use the below VF page :

<apex:page controller="ShowPageBlock_Class">
<apex:form >
    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:pageBlockSectionItem >
                <apex:outputLabel value="Last name" for="lastnameId"/>
                <apex:inputText value="{!lastname}" id="lastnameId"/>
            </apex:pageBlockSectionItem>

            <apex:pageBlockSectionItem >
                <apex:outputLabel value="Surname" for="SurnameId"/>
                <apex:inputText value="{!surname}" id="SurnameId"/>
            </apex:pageBlockSectionItem>

            <apex:commandButton value="Search" action="{!searchRec}" reRender="recMatch, recNotMatch,SerachRcdId,recMatchMrgd"/>

        </apex:pageBlockSection> 
    </apex:pageBlock>   

    <apex:pageBlock >
        <apex:pageBlockSection >
            <apex:outputPanel id="recNotMatch">
                <apex:pageBlockSectionItem rendered="{!NoMatch}"> Record Not Found!</apex:pageBlockSectionItem>
            </apex:outputPanel> 

        </apex:pageBlockSection>

        <apex:pageBlockSection >                
            <apex:outputPanel id="SerachRcdId">
                <apex:pageblockSectionItem rendered="{!SerchMatch}">
                    <apex:outputText >Searched Result</apex:outputText>
                    <apex:pageblockTable value="{!searchAccontLst}" var="a">
                         <apex:column headervalue="Account Name" value="{!a.Name}"/>
                         <apex:column headervalue="Account Type" value="{!a.type}"/>   
                    </apex:pageblockTable>
                </apex:pageblockSectionItem>    
            </apex:outputPanel>
        </apex:pageBlockSection> 

        <apex:pageBlockSection >
            <apex:outputPanel id="recMatch">
                <apex:pageblockSectionItem rendered="{!Match}">
                    <apex:outputText >Fixed Table</apex:outputText>
                    <apex:pageblockTable value="{!searchObj}" var="a">
                         <apex:column headervalue="Account Name" value="{!a.Name}"/>
                         <apex:column headervalue="Account Type" value="{!a.type}"/>
                         <apex:column headervalue="Industry" value="{!a.industry}"/>    
                    </apex:pageblockTable>
                </apex:pageblockSectionItem>

            </apex:outputPanel>
        </apex:pageBlockSection>
    </apex:pageBlock>       
</apex:form>

At controller use this:

public with sharing class ShowPageBlock_Class {
public String lastname{get;set;}
public String surname{get;set;}
public Boolean NoMatch{get;set;}
public Boolean Match{get;set;}
public List<Account> searchObj{get;set;}
public List<Account> searchAccontLst{get;set;}
public Boolean SerchMatch{get;set;}    


public ShowPageBlock_Class(){
    NoMatch = False;
    Match = True;  
    SerchMatch = False;
    searchObj = new List<Account>();
    searchObj = [select id,name,type,industry from Account];
}

public Void searchRec(){         
    searchAccontLst = new List<Account>();
    searchAccontLst = [select id,name,type,industry from Account where name=:lastname];
    if(searchAccontLst.size()==0){
        NoMatch = True;
        SerchMatch = False; 
        Match = False;          
    }
    else if(searchAccontLst.size()>0){
        NoMatch = False;
        SerchMatch = True;
        Match = False;
    }

}

}

Snap : Default screen before serach :

Snap: After search : When result found:

Snap: When record not found

Best Answer

Related Solutions

[SalesForce] Apex Command Button onclick condition

Edit --

[SalesForce] How to use 2 pageblockTable values in 1 pageBlocktable

Related Topic