Apex Code Development You need to sign in to do that
Don't have an account?
SFDC-NOOB Conditional Color Change + Debug Log
Hello,
I am attempting to change the color of names in a list based on whether the ID in the field "Team__c" on the carrier object matches any ID in the list of users. My controller is returning the color one time and this color applies to all records (See debug log). All values in the list are blue, some should be red. Any help is greatly appreciated, thank you in advance.
Visualforce:::
<apex:pageblocktable value="{!carriers}" var="c">
<apex:column headervalue="Carrier">
<font color="{!color2}">
<apex:outputtext value="{!c.name}"/>
</font>
</apex:column>
Controller:::
public string getcolor2() {
list<carrier__c> carriers = [select team__c from carrier__c where team__c != NULL];
list<user> users= new list<user>();
users = [select id from user where userrole.name = 'Executive'];
set<string> uid = new set<string>();
for(user us: users){
uid.add(us.id);
}
string color = 'red';
for(carrier__c car: carriers){
system.debug('*****List of carriers: ' + carriers);
system.debug('*****List of users: ' + uid);
system.debug('*****Current carrier= '+car);
if(uid.contains(car.team__c) ){
color='blue';
system.debug('***** Set color to:'+color);
}
}
system.debug('***** Returning color: ' + color);
return color;
}
Debug Log::::
*****List of carriers: (Carrier__c:{Team__c=005U0000001D3E5IAK, Id=a0HJ0000003bl8nMAA}, Carrier__c:{Team__c=005J0000001EEIHIA4, Id=a0HJ0000003bitnMAA}, Carrier__c:{Team__c=005U0000001BHRKIA4, Id=a0HJ0000003eD64MAE})
*****List of users: {005U0000001D3E5IAK}
*****Current carrier= Carrier__c:{Team__c=005U0000001D3E5IAK, Id=a0HJ0000003bl8nMAA}
***** Set color to:blue
*****List of users: {005U0000001D3E5IAK}
*****Current carrier= Carrier__c:{Team__c=005J0000001EEIHIA4, Id=a0HJ0000003bitnMAA}
*****List of users: {005U0000001D3E5IAK}
*****Current carrier= Carrier__c:{Team__c=005U0000001BHRKIA4, Id=a0HJ0000003eD64MAE}
***** Returning color: blue
Hi,
I will suggest you to wrap Carrier records in a wrapper class and have one additional field say 'Color'. For every record you can have some default value like 'BLUE' and if matched criteria you can set value of 'Color' for that record to say 'RED'.
Let me know if you need more help on this.
Happy to help you!
Records,
Digamber Prasad
All Answers
Hi,
I will suggest you to wrap Carrier records in a wrapper class and have one additional field say 'Color'. For every record you can have some default value like 'BLUE' and if matched criteria you can set value of 'Color' for that record to say 'RED'.
Let me know if you need more help on this.
Happy to help you!
Records,
Digamber Prasad
Thank you for your reply!! I was able to use a wrapper class to solve the problem. It broke my column sorting though, I guess it's time to learn the comparable interface!
My functioning code:
********************************************Controller***********************************************************
public class CarrierList_Controller {
public class MyCarrier {
carrier__c c;
public MyCarrier(carrier__c car) {c = car;}
public Carrier__c getCarrier(){ return c; }
public String getColor(){
list<user> users= new list<user>();
users = [select id from user where userrole.name = 'Executive' and user.alias = 'jberg'];
set<string> uid = new set<string>();
for(user us: users)
{
uid.add(us.id);
}
if(uid.contains(c.Team__c)) return 'Blue';
else return 'red';
}
}
public List<MyCarrier> results = new List<MyCarrier>{};
public list<MyCarrier> getCarriers(){
results.clear();
for(carrier__c c : [select id, team__c, name from carrier__c where team__c != NULL]){
results.add(new myCarrier(c));
}
return results;
}
}
**************************************************Visualforce Page****************************************************************
<apex:page controller="CarrierList_Controller"
showHeader="true" sidebar="true" >
<apex:form >
<apex:pageBlock title="" id="pageBlock">
<apex:pageMessages ></apex:pageMessages>
<apex:pageBlockTable value="{!carriers}" var="c"
rendered="{!NOT(ISNULL(carriers))}">
<apex:column >
<apex:facet name="header">Carrier Name</apex:facet>
<div style="color:{!c.color};font-weight:bold;text-decoration:underline;cursor:hand;cursor:pointer;">
{!c.carrier.Name}
</div>
</apex:column>
<apex:column value="{!c.carrier.Team__c}"></apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
Hi,
Happy that it worked for you! :)
Will you please let me know what do you exactly mean by 'broke my column sorting'. If you explain it to me, probably I will be able to comment on this.
Happy to help you!
Regards,
Digamber Prasad
Ok so I would like my users to be able to click the column names to sort the columns by ascending or descending order. My code is as follows:
*******************************************************Controller******************************************************
public class carrierlist {
private String sortDirection = 'ASC';
private String sortF = 'name';
public String sortField {
get
{
return sortF;
}
set
{
//if the column is clicked on then switch between Ascending and Descending modes
if (value == sortF)
sortDirection = (sortDirection == 'ASC')? 'DESC' : 'ASC';
else
sortDirection = 'ASC';
sortF = value;
}
}
public String getSortDirection() {
//if no column is selected
if (sortField == null || sortField == '')
return 'ASC';
else
return sortDirection;
}
public void setSortDirection(String value) {
sortDirection = value;
}
public class MyCarrier {
carrier__c c;
public MyCarrier(carrier__c car) {c = car;}
public Carrier__c getCarrier(){ return c; }
public String getColor(){
list<user> users= new list<user>();
users = [select id from user where userrole.name = 'Executive' and user.alias = 'jberg'];
set<string> uid = new set<string>();
for(user us: users)
{
uid.add(us.id);
}
if(uid.contains(c.Team__c))
return 'red';
else
return 'blue';
}
}
public List<MyCarrier> carriers = new List<MyCarrier>{}; public list<MyCarrier> getCarriers(){
string sortFullExp = sortfield + ' ' + sortDirection;
carriers.clear();
for(carrier__c c : [select id, team__c, references__c, requester__c, fraud_websites__c, Insurance_received__c, conditional_letter__c,
contract__c, MC_Number__c, compliance_action__c, attachment__c, name from carrier__c where team__c != NULL]){
carriers.add(new myCarrier(c));
}
return carriers; /**********************What I need to return ------>>
//carrier = Database.query('select team__c, attachment__c, MC_number__c, contract__c, conditional_letter__c, references__c, insurance_received__c, fraud_websites__c, requester__c, compliance_action__c, Name from carrier__c where team__c != NULL ORDER BY ' + sortFullExp + ' limit 1000');
return carrier;*****************************************/
}
}
****************************************************Visualforce Page************************************************************************************
<apex:page controller="carrierlist" showHeader="true" sidebar="true" >
<apex:form >
<apex:pageBlock title="" id="pageBlock">
<apex:pageBlockTable value="{!carriers}" var="c" rendered="{!NOT(ISNULL(carriers))}">
<apex:column >
<apex:facet name="header">Carrier Name</apex:facet>
<div style="color:{!c.color};font-weight:bold;text-decoration:underline;cursor:hand;cursor:pointer;">
<apex:outputlink style="color:{!c.color}" value="/{!c.carrier.id}" target="_blank" > {!c.carrier.name} </apex:outputlink>
</div>
</apex:column>
<apex:column value="{!c.carrier.References__c}">
<apex:facet name="header">
<apex:commandlink value="References{!IF(sortField =='References__c',IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="References__c" name="column" assignto="{!sortField }" ></apex:param>
</apex:commandlink>
</apex:facet>
</apex:column>
<apex:column value="{!c.carrier.Compliance_Action__c}">
<apex:facet name="header">
<apex:commandlink value="Compliance Action{!IF(sortField =='compliance_action__c', IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="compliance_action__c" name="column" assignto="{!sortField}" ></apex:param>
</apex:commandlink>
</apex:facet>
</apex:column>
<apex:column value="{!c.carrier.MC_Number__c}">
<apex:facet name="header">
<apex:commandlink value="MC Number{!IF(sortField =='MC_Number__c', IF(sortDirection='ASC','▼','▲'),'')}">
<apex:param value="MC_Number__c" name="column" assignto="{!sortField}" ></apex:param>
</apex:commandlink>
</apex:facet>
</apex:column>
Hi,
Did you put debug log and check how query build on run time based upon clicking on column name?
Regards,
Digamber Prasad
Therefore, I cannot use the database.query(' select . . . from carrier__c Order by ' + SortFullExp);
When I use the query I need, I get this error:
carrierlist Compile Error: line breaks not allowed in string literals at line 61 column -1
Code generating error:::
for(carrier__c c : database.query('select id, team__c, references__c, requester__c, fraud_websites__c, Insurance_received__c, conditional_letter__c, contract__c, MC_Number__c, compliance_action__c, attachment__c, name from carrier__c where team__c != NULL order by ' + sortFullExp ){
carriers.add(new myCarrier(c));
}
Hi,
I found there was a ')' missing in for statement. Could you please try below code snippet:-
for(carrier__c c : database.query('select id, team__c, references__c, requester__c, fraud_websites__c, Insurance_received__c, conditional_letter__c, contract__c, MC_Number__c, compliance_action__c, attachment__c, name from carrier__c where team__c != NULL order by ' + sortFullExp )){ carriers.add(new myCarrier(c)); }Let me know if it doesn't work for you.
Regards,
Digamber Prasad
Just a small change:--
for(carrier__c c : database.query('select id, team__c, references__c, requester__c, fraud_websites__c, Insurance_received__c, conditional_letter__c, contract__c, MC_Number__c, compliance_action__c, attachment__c, name from carrier__c where team__c != NULL order by ' + sortFullExp )){ carriers.add(c); }Below could be one more possible solution:-
for(SObject c : database.query('select id, team__c, references__c, requester__c, fraud_websites__c, Insurance_received__c, conditional_letter__c, contract__c, MC_Number__c, compliance_action__c, attachment__c, name from carrier__c where team__c != NULL order by ' + sortFullExp )){ carriers.add((carrier__c)c); }Thanks so much!! KUDOS TO YOU!
Happy that I was able to help you! :)
Happy coding.
Regards,
Digamber Prasad