function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Tiruchuri AdityanTiruchuri Adityan 

onRowClick

When I click on a row in a table it should retrieve particular fields of a particular coloumn in below table.

<apex:page controller="prac1">
    <apex:pageBlock title="Multiple Search and Split">
            <table cellpadding="3px" cellspacing="4px" >
                <tr height="20px">
                    <apex:form >
                    <td style="vertical-align:middle;">
                    Search by </td> <td style="vertical-align:middle;">
                 <apex:selectList size="1">
                <apex:selectOption itemValue="Serial" itemLabel="Serial Number"/>
                <apex:selectOption itemValue="Oppo" itemLabel="Opportunity"/>
                <apex:selectOption itemValue="EUC" itemLabel="End User Company"/>
            </apex:selectList>
                </td>
                <td style="vertical-align:middle;">
            <apex:inputTextarea style="overflow-y:scroll; resize:none; min-height:30px; max-height:30px; min-width:250px; max-width:250px" value="{!searchstring}"/> </td>  
            <td style="vertical-align:middle;">    <apex:commandButton value="Search" action="{!search}"/> </td>  
           <td style="vertical-align:middle;">    <apex:commandButton value="Split"/></td>  
           <td style="vertical-align:middle;">    <apex:commandButton value="Consolidate"/></td>  
           <td style="vertical-align:middle;">    <apex:commandButton value="Unconsolidate"/> </td>  
           <td style="vertical-align:middle;">    <apex:commandButton value="Export"/> </td>  
                    <td style="vertical-align:middle;">    <apex:commandButton value="Export Asset"/> </td>
                    </apex:form>
                </tr>
                </table>
         <apex:pageBlockTable value="{!acc}" var="a" cellpadding="10px" width="100%">
         <apex:column >
         <apex:facet name="header">Name</apex:facet>
         <apex:outputlink value="https://ap1.salesforce.com/{!a.id}">{!a.Name} </apex:outputlink>
         </apex:column>
         <apex:column >
                <apex:facet name="header">Opportunity id</apex:facet>
                        {!a.id}
         </apex:column>
     <apex:column >
                 <apex:column >
                <apex:facet name="header">Amount</apex:facet>
                        {!a.amount}
         </apex:column>
       <apex:actionSupport event="onRowClick" reRender="" action="{!click}">
        <apex:param name="cId" value="{!a.Name}" assignTo="{!myStringValue}"/>
      </apex:actionSupport>
    </apex:pageBlockTable>   
       <apex:pageBlockTable id="sa" value="{!ass}" var="b" rendered="true">
            <apex:column value="{!b.asset1__c}"/>
              </apex:pageBlockTable>
           </apex:pageBlock>
</apex:page>

And the controller is

public with sharing class prac1 {
   public list <opportunity> acc {get;set;}
   public list <Asset> ass {get;set;}
   public string searchstring {get;set;}
   public string myStringValue {get;set;}

public prac1()
   {
   }

public void search()
{
     string searchquery='select name, Id, Amount, CloseDate, StageName from Opportunity where name like \''+searchstring+'%\' Limit 20';
     acc= Database.query(searchquery);
}
public void click()
  {
   string squery='select name, asset1__c, asset2 from Asset__c where name like \''+myStringValue+'%\' Limit 20';
        ass= Database.query(squery);
  } 
}

And in this Opportunity is a standard object and Asset is a custom object..
SravsSravs
public void click(){

myStringValue = ApexPages.CurrentPage().getParameters().get('cId');
string squery='select name, asset1__c, asset2 from Asset__c where name like \''+myStringValue+'%\' Limit 20';
ass= Database.query(squery);
}
Try Using this. 
Tiruchuri AdityanTiruchuri Adityan
I havent observed any change..
SravsSravs
can you confor wether the methodk click() is being fireed or not? 

If you are tying to see the change in page block table you need to add rerender value in action support. 
Tiruchuri AdityanTiruchuri Adityan
No value is being retrieved. I can c no change in pageblock table
SravsSravs
I just modified your code that works with account isted of Asset. 
Page  
<apex:page controller="prac1">

    <apex:pageBlock title="Multiple Search and Split">
            <table cellpadding="3px" cellspacing="4px" >
                <tr height="20px">
                    <apex:form >
                        <td style="vertical-align:middle;">
                            Search by 
                        </td> 
                        <td style="vertical-align:middle;">
                            <apex:selectList size="1">
                                <apex:selectOption itemValue="Serial" itemLabel="Serial Number"/>
                                <apex:selectOption itemValue="Oppo" itemLabel="Opportunity"/>
                                <apex:selectOption itemValue="EUC" itemLabel="End User Company"/>
                            </apex:selectList>
                        </td>
                        <td style="vertical-align:middle;">
                            <apex:inputTextarea style="overflow-y:scroll; resize:none; min-height:30px; max-height:30px; min-width:250px; max-width:250px" value="{!searchstring}"/> 
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Search" action="{!search}"/> 
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Split"/>
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Consolidate"/>
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Unconsolidate"/> 
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Export"/> 
                        </td>  
                        <td style="vertical-align:middle;">    
                            <apex:commandButton value="Export Asset"/> 
                        </td>
                    </apex:form>
                </tr>
            </table>
            <apex:form >
         <apex:pageBlockTable value="{!acc}" var="a" cellpadding="10px" width="100%">
             <apex:actionSupport event="onRowClick" reRender="result" action="{!click}">
                <apex:param name="cId" value="{!a.Account.Name}" assignTo="{!myStringValue}"/>
             </apex:actionSupport>
             <apex:column >
                 <apex:facet name="header">Name</apex:facet>
                 <apex:outputlink value="https://ap1.salesforce.com/{!a.id}">{!a.Name} </apex:outputlink>
             </apex:column>
             <apex:column >
                    <apex:facet name="header">Opportunity id</apex:facet>
                            {!a.id}
             </apex:column>
            <apex:column >
                <apex:facet name="header">Amount</apex:facet>
                        {!a.amount}
            </apex:column>
        </apex:pageBlockTable>   
        <apex:outputPanel id="result">
            <apex:pageBlockTable id="sa" value="{!ass}" var="b" rendered="true">
                <apex:column value="{!b.name}"/>
            </apex:pageBlockTable>
        </apex:outputPanel>
        </apex:form>
    </apex:pageBlock>

</apex:page>
controller
public class prac1 {
   public list <opportunity> acc {get;set;}
   public list <Account> ass {get;set;}
   public string searchstring {get;set;}
   public string myStringValue {get;set;}

public prac1(){
    acc = new list<Opportunity>([select id, name, account.name, Amount from opportunity limit 10]);
}

public void search()
{
     string searchquery='select name, Id, Amount, CloseDate, StageName from Opportunity where name like \''+searchstring+'%\' Limit 20';
     acc= Database.query(searchquery);
}
public void click()
  {
  myStringValue = string.escapeSingleQuotes(myStringValue);
   string squery='select name from Account where name like \''+myStringValue+'%\' Limit 20';
        ass= Database.query(squery);
  } 
}
The change is added an output pannel and apex form tags to the page. 
To avoid dynamic soql exception added escapeSingleQuotes() method.

Hope this solves your issue. 
SravsSravs
what do you meen by clicks?? Please elaborate. 
Tiruchuri AdityanTiruchuri Adityan
Still I found no change
SravsSravs
please post your latest page and controller. It might be helpfull for me to identofy the issue.