I want to print a list of a customer's recent jobs (Job__c) on a public page with the percent completed for each.
I made VF with a dataTable, and a StandardSetController. But found these problems and am stuck.
- ORDER BY clause is being ignored. Displays ASC no matter whether I choose ASC or DESC.
- WHERE clause is being ignored. Displays all records even if I choose CreatedDate > :mydate)
- CSS. I want to make it look just like ordinary Salesforce list views as shown when you click on an object's tab. I was able to put some css into the VF file to make it look better than raw text but still it is not what I want. (I used some css found in this forum as a test but don't want to use it in production). I've tried various things and can't figure out what the right way to do it is.
- Pagination. I have seen some roll your own pagination posted but I just want to use that standard Salesforce stuff.
- Sorting. Ideally it would display as DESC (latest job at top) and also you could click on a column header to sort the column. Not critical though.
I am thinking right now that the problem is StandardSetController which was said to be buggy in 2008.. so maybe I should make a list of lists of strings? Still, how do you in fact make a list view of custom objects that has the salesforce look? It is said you should copy their stylesheets but in fact these are old articles, the urls don't exist anymore, and it bears no resemblence to the source code of salesforce pages. Where are the dataTable styles for example?
Here is what I have now, including the VisualForce page, Apex list controller, and a screenshot. (Please ignore the Japanese, there is translation in the attached screenshot if you care.)
Thank you very much for your help. I think I can at the minimum deal with what I have here though I'd like it to look like Salesforce.
public class factoryCustPortal_JobStatusDisplay {
// Customer has logged in by providing their password.
// Now display a list of the customer's recent jobs, showing %completed for each.
// Note this does not check which System or Factory.
private Integer monthsback = -2;
private Customer__c cust;
public String custpass;
public String teststr {get; set;}
public ApexPages.StandardSetController jobs {
get {
if (jobs == null) {
if (checkcust()) {
Date timeago = Date.today().addMonths(monthsback);
Job__c[] joblist = [select name,Customer__c,CreatedDate,Percent_Done__c,Item_Count__c
from Job__c where Customer__c = :cust.id
and CreatedDate > :timeago
order by name asc];
return new ApexPages.StandardSetController(joblist);
} // if valid cust
else {
return null; // die with message in teststr. Haven't tested to see if this works yet.
}
} // if jobs is null
return jobs;
}
private set;
}
public List<Job__c> getfactoryCustPortal_JobStatusDisplay() {
return (List<Job__c>)jobs.getRecords();
}
public factoryCustPortal_JobStatusDisplay(ApexPages.StandardSetController controller) {
// this.Customer__c = (Customer__c)controller.getRecord();
}
public Boolean checkcust() {
// Get password from hidden input field, validate, then set cust or die
// Get user's password from query params
PageReference thisPage = ApexPages.currentPage();
custpass = thisPage.getParameters().get('custpass'); // password is posted from an apex:inputHidden field
// Get Customer from pass
try {
cust = [select Id,Name,Portal_Password__c from Customer__c where Portal_Password__c = :custpass limit 1];
String custname = cust.name;
teststr = custname + ' (' + cust.id +')';
return true;
}
catch (Exception e) {
String badpass = 'Bad Password. Please contact your account executive.';
teststr = badpass;
}
return false;
}
}
(p.s. I got the following message but it seems okay and I can't tell what the forum software deleted..)
"Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied."
I have a set of three dependent picklists in my Item__c object: Item__c.Type__c, Item__c.Subtype__c and Item__c.Subsubtype__c. The latter two picklists have many entries each.
How do I display just the latter two picklists prefiltered based on a hidden input tag that sets Item__c.Type__c?
Here is my code and the behavior I am seeing. It seems to be some kind of bug, or maybe I am just obtuse ;)
(Here, even if in apex constructor we have item.Type__c = myitemtype but still the subtype picklist does not narrowed down. maybe I should be using getter..?)
2) When the following code is used, selecting a Subtype does not narrow down the Subsubtype field.
Although I have seen invisible differences in encoding (using UTF-8 to show Japanese, I have translated to post here) I have double-checked by copy-pasting from the picklist value edit dialog box into Eclipse so this is not an issue.
Additional information regarding case 2 above:
Type <apex:inputField value="{!Item__c.Type__c}" id="itemtype" onchange="itemtype.value='Raw Materials'" rendered="true"/>{!Item__c.Type__c}
- Type picklist is displayed, showing all values of the picklist (which is not what I want)
- Type gets set to Raw Materials, and Subtype picklist gets narrowed down correctly.
- Even if a different value such as "Waste" is selected for Type, the Subtype picklist remains narrowed down as if Type still equals Raw Materials.
- However, the Type picklist displays "Waste". (Which is confusing since the UI lies, displaying the a different value from that to which the Type variable was set.)
- I was unable to obtain the desired action with other javascript tags than onchange.
- Should I be making an Action?
- If rendered is changed to "False", the Subtype picklist does not get narrowed down anymore.
Some questions about dependent picklists and rolling my own from another object. I've already successfully built my own picklists in apex and used them in VF pages, this is a little more involved.
I have an Item__c which has a type, subtype and subsubtype. They would be dependent picklists, but I need to be able to allow my client to update this hierarchy of product types, so I have made a separate object to hold them, Item_Type__c and plan to roll my own picklists from apex to show in a VF page.
This will also let me access the hierarchy information from other objects and easily select a set of values for custom reports, etc. I don't see much information on how to explore the dependency matrix used in dependent picklists.
My questions:
1. What is the standard way to build dependent picklists from apex, or is this still not possible? Is the Javascript remoting from Summer 2011 the way to do it? I'm targeting IE, Chrome and also Windows Mobile 6.5 Professional's IE where I don't know how well it would work...
2. Is there a standard way to ask an object's picklist what is the controlling value? For example, if I have a SubSubType "Pellets" dependent on SubType "Plastic", given "Pellets" what query will give me "Plastic"?
3. Is there a way to override Item__c 's standard detail page so that these custom picklists will show up inside them, without making an entire VF page to completely replace the object edit page? It seems possible to add VF pages or Components into a page layout but I have not been able to find the relevant documentation yet. This would have to also be a set of dependent picklists that would operate the same way as normal dependent picklists would, despite that the values are coming from a SOQL query on a separate object's records.
4. Summer 2010 introduced picklists in VF with code like <apex:inputField Can I in fact show in VF dependent picklists from Item_Type__c within a VF page (controller extension based on an Item__c or maybe a different object, Transaction__c).
Regarding the new QuickFind function.. it is not very useful.
How come it doesn't include all the names / descriptions / help of my objects/fields/classes/pages?
It should be quite easy to do so.
Failing that, how about making the Objects, Classes and Pages links in the sidebar expand to a full preloaded list so we can save time reloading the relevant index pages?
Since the Summer11 release says "easy as Google" you would think that Everything (even perish the thought, online help and developer documentation) would have been indexed. Would be nice.
Another question.. How do you display a google maps URL to a certain location?
A sample url is below. (it goes to a place in Sendai, Japan)
It is over 255 characters so we have to use a long text field.
But when the standard page a user sees for that object appears, the long url makes the entire page become way too wide because there are no spaces in the url. In other words, the field should be wrapped but it doesn't.
I am developing a custom app in force.com and since the first version is in Japanese, the object names are also Japanese.
The listing of my objects that appears when you go to Create > Objects in the app builder is difficult to use; it shows unused standard English objects at the top, and my own custom objects in Japanese are not arranged in a meaningful order. I would like to reorder them so they match my entity diagram's connections somewhat so I don't have to hunt around every time I go to this page.
How can I customize the order in which my custom objects appear to the developer (me) in the Create > Objects page?
I want to print a list of a customer's recent jobs (Job__c) on a public page with the percent completed for each.
I made VF with a dataTable, and a StandardSetController. But found these problems and am stuck.
- ORDER BY clause is being ignored. Displays ASC no matter whether I choose ASC or DESC.
- WHERE clause is being ignored. Displays all records even if I choose CreatedDate > :mydate)
- CSS. I want to make it look just like ordinary Salesforce list views as shown when you click on an object's tab. I was able to put some css into the VF file to make it look better than raw text but still it is not what I want. (I used some css found in this forum as a test but don't want to use it in production). I've tried various things and can't figure out what the right way to do it is.
- Pagination. I have seen some roll your own pagination posted but I just want to use that standard Salesforce stuff.
- Sorting. Ideally it would display as DESC (latest job at top) and also you could click on a column header to sort the column. Not critical though.
I am thinking right now that the problem is StandardSetController which was said to be buggy in 2008.. so maybe I should make a list of lists of strings? Still, how do you in fact make a list view of custom objects that has the salesforce look? It is said you should copy their stylesheets but in fact these are old articles, the urls don't exist anymore, and it bears no resemblence to the source code of salesforce pages. Where are the dataTable styles for example?
Here is what I have now, including the VisualForce page, Apex list controller, and a screenshot. (Please ignore the Japanese, there is translation in the attached screenshot if you care.)
Thank you very much for your help. I think I can at the minimum deal with what I have here though I'd like it to look like Salesforce.
public class factoryCustPortal_JobStatusDisplay {
// Customer has logged in by providing their password.
// Now display a list of the customer's recent jobs, showing %completed for each.
// Note this does not check which System or Factory.
private Integer monthsback = -2;
private Customer__c cust;
public String custpass;
public String teststr {get; set;}
public ApexPages.StandardSetController jobs {
get {
if (jobs == null) {
if (checkcust()) {
Date timeago = Date.today().addMonths(monthsback);
Job__c[] joblist = [select name,Customer__c,CreatedDate,Percent_Done__c,Item_Count__c
from Job__c where Customer__c = :cust.id
and CreatedDate > :timeago
order by name asc];
return new ApexPages.StandardSetController(joblist);
} // if valid cust
else {
return null; // die with message in teststr. Haven't tested to see if this works yet.
}
} // if jobs is null
return jobs;
}
private set;
}
public List<Job__c> getfactoryCustPortal_JobStatusDisplay() {
return (List<Job__c>)jobs.getRecords();
}
public factoryCustPortal_JobStatusDisplay(ApexPages.StandardSetController controller) {
// this.Customer__c = (Customer__c)controller.getRecord();
}
public Boolean checkcust() {
// Get password from hidden input field, validate, then set cust or die
// Get user's password from query params
PageReference thisPage = ApexPages.currentPage();
custpass = thisPage.getParameters().get('custpass'); // password is posted from an apex:inputHidden field
// Get Customer from pass
try {
cust = [select Id,Name,Portal_Password__c from Customer__c where Portal_Password__c = :custpass limit 1];
String custname = cust.name;
teststr = custname + ' (' + cust.id +')';
return true;
}
catch (Exception e) {
String badpass = 'Bad Password. Please contact your account executive.';
teststr = badpass;
}
return false;
}
}
(p.s. I got the following message but it seems okay and I can't tell what the forum software deleted..)
"Your post has been changed because invalid HTML was found in the message body. The invalid HTML has been removed. Please review the message and submit the message when you are satisfied."
I have a set of three dependent picklists in my Item__c object: Item__c.Type__c, Item__c.Subtype__c and Item__c.Subsubtype__c. The latter two picklists have many entries each.
How do I display just the latter two picklists prefiltered based on a hidden input tag that sets Item__c.Type__c?
Here is my code and the behavior I am seeing. It seems to be some kind of bug, or maybe I am just obtuse ;)
(Here, even if in apex constructor we have item.Type__c = myitemtype but still the subtype picklist does not narrowed down. maybe I should be using getter..?)
2) When the following code is used, selecting a Subtype does not narrow down the Subsubtype field.
Although I have seen invisible differences in encoding (using UTF-8 to show Japanese, I have translated to post here) I have double-checked by copy-pasting from the picklist value edit dialog box into Eclipse so this is not an issue.
Additional information regarding case 2 above:
Type <apex:inputField value="{!Item__c.Type__c}" id="itemtype" onchange="itemtype.value='Raw Materials'" rendered="true"/>{!Item__c.Type__c}
- Type picklist is displayed, showing all values of the picklist (which is not what I want)
- Type gets set to Raw Materials, and Subtype picklist gets narrowed down correctly.
- Even if a different value such as "Waste" is selected for Type, the Subtype picklist remains narrowed down as if Type still equals Raw Materials.
- However, the Type picklist displays "Waste". (Which is confusing since the UI lies, displaying the a different value from that to which the Type variable was set.)
- I was unable to obtain the desired action with other javascript tags than onchange.
- Should I be making an Action?
- If rendered is changed to "False", the Subtype picklist does not get narrowed down anymore.
Another question.. How do you display a google maps URL to a certain location?
A sample url is below. (it goes to a place in Sendai, Japan)
It is over 255 characters so we have to use a long text field.
But when the standard page a user sees for that object appears, the long url makes the entire page become way too wide because there are no spaces in the url. In other words, the field should be wrapped but it doesn't.
I am developing a custom app in force.com and since the first version is in Japanese, the object names are also Japanese.
The listing of my objects that appears when you go to Create > Objects in the app builder is difficult to use; it shows unused standard English objects at the top, and my own custom objects in Japanese are not arranged in a meaningful order. I would like to reorder them so they match my entity diagram's connections somewhat so I don't have to hunt around every time I go to this page.
How can I customize the order in which my custom objects appear to the developer (me) in the Create > Objects page?
