Hi all,

  I want to email templates will be send to the corresponding Users.That users only retrieved his own data in email templates.The following query is not executed:

select Name,bid__c.auction__r.name, bid__c.Asset_ST__c,bid__c.Model_No__c,Manufacturer__c,quantity__c,bid_Amount__c,Buyer_Contact__c,Total_Offer__c,Email_Address__c
from bid__c where CreatedDate = today and ownerid =:thisUserId];

Please give some solution:

I listed whole classes,component and email templates

Class:
public class sendoffermail
{

private final List<bid__c> offers;
Id thisUserId;
public Id getthisUserId() {
return thisUserId;
}

public void setthisUserId(Id s) {
thisUserId = s;
}

public sendoffermail()
{


offers= [select Name,bid__c.auction__r.name, bid__c.Asset_ST__c,bid__c.Model_No__c,Manufacturer__c,quantity__c,bid_Amount__c,Buyer_Contact__c,Total_Offer__c,Email_Address__c
from bid__c where CreatedDate = today and ownerid =:thisUserId];
}

public List<bid__c> getofferdata()
{

return offers;
}
}

Components:

<apex:component controller="sendoffermail" access="global">
<apex:attribute name="thisUserId" description="This is the User Id." type="Id" assignTo="{!thisUserId}" />

<pre>
thisUserId = {!thisUserId}
</pre>
<apex:dataTable value="{!offerdata}" var="of" border="1" >




<apex:column >
<apex:facet name="header">auction</apex:facet>
{!of.auction__r.name} </apex:column>

<apex:column >
<apex:facet name="header">Manufacturer</apex:facet>
{!of.Manufacturer__c} </apex:column>
<apex:column >
<apex:facet name="header">ModelNo</apex:facet>
{!of.Model_No__c} </apex:column>

<apex:column >
<apex:facet name="header">quantity</apex:facet>
{!of.quantity__c} </apex:column>

<apex:column >
<apex:facet name="header">bidAmount</apex:facet>
{!of.bid_Amount__c}</apex:column>


<apex:column >
<apex:facet name="header">TotalOffer</apex:facet>
{!of.Total_Offer__c}</apex:column>

</apex:dataTable>
</apex:component>

Email Templates:

<messaging:emailTemplate subject="Your Today Offer Status Displayed Below" recipientType="User" >

<messaging:htmlEmailBody >
<p>Hello {!recipient.name}--</p>
<p>These are Your Today Offer Details</p>

<!-- <c:sendoffermail /> -->
<c:sendoffermail thisUserId="{!recipient.id}" />

</messaging:htmlEmailBody>

</messaging:emailTemplate>

<apex:form id="STForm">
<apex:pageblock >
<apex:pageBlockButtons location="bottom" >
<apex:commandButton value="Next" action="{!doAssets}"/>
</apex:pageBlockButtons>
<apex:pageBlockSection >
<apex:image url="{!$Resource.ExchangeLogo_Transparent}"></apex:image>
</apex:pageBlockSection>
<A HREF="javascript&colon;test2({!ExchangeAssets.size})">Select All</A>
</br>

<apex:pageBlockSection title="Select Assets to Post">

<apex:selectCheckboxes id="STCheckboxes" layout="pageDirection" value="{!ExchangeAssets.selectedAssets}" >
<apex:selectOptions id="STOptions" value="{!ExchangeAssets.AssetResults}" />

This is my visual page,how to edit the checkbox list table.

I want to edit a checkbox list table . How can i edit the checkbox list table in sfdc?

<apex:form id="STForm">
<apex:pageblock >
<apex:pageBlockButtons location="bottom" >
<apex:commandButton value="Next" action="{!doAssets}"/>
</apex:pageBlockButtons>


<apex:pageBlockSection title="Select Assets to Post">

<apex:selectCheckboxes id="STCheckboxes" layout="pageDirection" value="{!ExchangeAssets.selectedAssets}" >
<apex:selectOptions id="STOptions" value="{!ExchangeAssets.AssetResults}" />


</apex:selectCheckboxes>
</apex:pageBlockSection>
</apex:pageblock>

Hi all,

  I want to email templates will be send to the corresponding Users.That users only retrieved his own data in email templates.The following query is not executed:

select Name,bid__c.auction__r.name, bid__c.Asset_ST__c,bid__c.Model_No__c,Manufacturer__c,quantity__c,bid_Amount__c,Buyer_Contact__c,Total_Offer__c,Email_Address__c
from bid__c where CreatedDate = today and ownerid =:thisUserId];

Please give some solution:

I listed whole classes,component and email templates

Class:
public class sendoffermail
{

private final List<bid__c> offers;
Id thisUserId;
public Id getthisUserId() {
return thisUserId;
}

public void setthisUserId(Id s) {
thisUserId = s;
}

public sendoffermail()
{


offers= [select Name,bid__c.auction__r.name, bid__c.Asset_ST__c,bid__c.Model_No__c,Manufacturer__c,quantity__c,bid_Amount__c,Buyer_Contact__c,Total_Offer__c,Email_Address__c
from bid__c where CreatedDate = today and ownerid =:thisUserId];
}

public List<bid__c> getofferdata()
{

return offers;
}
}

Components:

<apex:component controller="sendoffermail" access="global">
<apex:attribute name="thisUserId" description="This is the User Id." type="Id" assignTo="{!thisUserId}" />

<pre>
thisUserId = {!thisUserId}
</pre>
<apex:dataTable value="{!offerdata}" var="of" border="1" >




<apex:column >
<apex:facet name="header">auction</apex:facet>
{!of.auction__r.name} </apex:column>

<apex:column >
<apex:facet name="header">Manufacturer</apex:facet>
{!of.Manufacturer__c} </apex:column>
<apex:column >
<apex:facet name="header">ModelNo</apex:facet>
{!of.Model_No__c} </apex:column>

<apex:column >
<apex:facet name="header">quantity</apex:facet>
{!of.quantity__c} </apex:column>

<apex:column >
<apex:facet name="header">bidAmount</apex:facet>
{!of.bid_Amount__c}</apex:column>


<apex:column >
<apex:facet name="header">TotalOffer</apex:facet>
{!of.Total_Offer__c}</apex:column>

</apex:dataTable>
</apex:component>

Email Templates:

<messaging:emailTemplate subject="Your Today Offer Status Displayed Below" recipientType="User" >

<messaging:htmlEmailBody >
<p>Hello {!recipient.name}--</p>
<p>These are Your Today Offer Details</p>

<!-- <c:sendoffermail /> -->
<c:sendoffermail thisUserId="{!recipient.id}" />

</messaging:htmlEmailBody>

</messaging:emailTemplate>

<apex:form id="STForm">
<apex:pageblock >
<apex:pageBlockButtons location="bottom" >
<apex:commandButton value="Next" action="{!doAssets}"/>
</apex:pageBlockButtons>
<apex:pageBlockSection >
<apex:image url="{!$Resource.ExchangeLogo_Transparent}"></apex:image>
</apex:pageBlockSection>
<A HREF="javascript&colon;test2({!ExchangeAssets.size})">Select All</A>
</br>

<apex:pageBlockSection title="Select Assets to Post">

<apex:selectCheckboxes id="STCheckboxes" layout="pageDirection" value="{!ExchangeAssets.selectedAssets}" >
<apex:selectOptions id="STOptions" value="{!ExchangeAssets.AssetResults}" />

This is my visual page,how to edit the checkbox list table.