I have a component which sits on a visualforce page, everytime this component is rendered I would like to do a check and insert some data. Initially I tried to put this code in the component controllers' constructor obviously this failed because no DML operations are allowed at this point.
Instead I now call the method from one of the components get properties. This appears to work and the debug logs show it as working, unfortunatly the data is not there. If I execute the same code anonamously from Eclipse it works perfectly.
Here is the log of the particular method in question:
17:6:34.930|METHOD_ENTRY|[16,6]|01pS00000005AJs|FieldAuditController.CreateSnapShot() 17:6:34.930|METHOD_ENTRY|[31,6]|01pS00000005AJs|FieldAuditController.MustCreateSnapshot() 17:6:34.930|METHOD_ENTRY|[46,192]|LIST<FieldAuditSnapshot__c>.size() 17:6:34.930|SOQL_EXECUTE_BEGIN|[46,15]|Aggregations:0|SELECT Id FROM FieldAuditSnapshot__c WHERE User__c=:Userinfo.getUserId() AND Month__c=:DateTime.Now().month() AND Year__c=:DateTime.Now().Year() AND ObjectType__c=:objectType 17:6:34.930|METHOD_ENTRY|[46,68]|Userinfo.getUserId() 17:6:34.930|METHOD_EXIT|[46,68]|Userinfo.getUserId() 17:6:34.930|METHOD_ENTRY|[46,118]|Datetime.month() 17:6:34.930|METHOD_ENTRY|[46,103]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,103]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,118]|Datetime.month() 17:6:34.930|METHOD_ENTRY|[46,154]|Datetime.Year() 17:6:34.930|METHOD_ENTRY|[46,139]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,139]|DateTime.Now() 17:6:34.931|METHOD_EXIT|[46,154]|Datetime.Year() 17:6:34.937|SOQL_EXECUTE_END|[46,15]|Rows:0 17:6:34.937|METHOD_EXIT|[46,192]|LIST<FieldAuditSnapshot__c>.size() 17:6:34.937|METHOD_EXIT|[31,6]|FieldAuditController.MustCreateSnapshot() 17:6:34.938|METHOD_ENTRY|[36,18]|Userinfo.getUserId() 17:6:34.938|METHOD_EXIT|[36,18]|Userinfo.getUserId() 17:6:34.938|METHOD_ENTRY|[37,33]|Datetime.year() 17:6:34.938|METHOD_ENTRY|[37,18]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[37,18]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[37,33]|Datetime.year() 17:6:34.938|METHOD_ENTRY|[38,34]|Datetime.month() 17:6:34.938|METHOD_ENTRY|[38,19]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[38,19]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[38,34]|Datetime.month() 17:6:34.938|METHOD_ENTRY|[39,5]|Database.insert(SOBJECT:FieldAuditSnapshot__c) 17:6:34.938|DML_BEGIN|[39,5]|Op:Insert|Type:FieldAuditSnapshot__c|Rows:1 17:6:34.979|DML_END|[39,5] 17:6:34.979|METHOD_EXIT|[39,5]|Database.insert(SOBJECT:FieldAuditSnapshot__c) 17:6:34.979|METHOD_EXIT|[16,6]|FieldAuditController.CreateSnapShot()
Here is the controller:
public without sharing class FieldAuditController {
public string objectType{get;set;}
public string title{get;set;}
public FieldAuditController(){ }
//for this prototype we'll just use the candidate object with a small set of fields
public integer AuditPercent{
get{
if(AuditPercent == null){
//these queries would be where we filter by date
string q = 'SELECT AVG(Completedness__c) FROM '+objectType+' WHERE OwnerId=\''+Userinfo.getUserId()+'\'';
AggregateResult result = Database.query(q);
AuditPercent = double.valueOf(result.get('expr0')).intValue();
CreateSnapShot();
}
return AuditPercent;
}
set;
}
// the incomplete percentage
public integer AuditIncompletePercent{
get{
return 100 - AuditPercent;
}set;
}
public void CreateSnapShot(){
//check if its neccessary to create snapshot
if(MustCreateSnapshot()){
FieldAuditSnapshot__c ss = new FieldAuditSnapshot__c();
ss.Complete__c = AuditPercent;
ss.ObjectType__c = objectType;
ss.User__c = Userinfo.getUserId();
ss.Year__c = DateTime.Now().year();
ss.Month__c = DateTime.Now().month();
Database.insert(ss);
}
}
private boolean MustCreateSnapshot(){
//Query the FieldAuditSnapshot__c record to see if a snapshot has been created for this user on candidate for this month and year
integer c = [SELECT Id FROM FieldAuditSnapshot__c WHERE User__c=:Userinfo.getUserId() AND Month__c=:DateTime.Now().month() AND Year__c=:DateTime.Now().Year() AND ObjectType__c=:objectType].size();
if(c==0){
return true;
}
return false;
}
}
I have a visualforce page for a custom object with an input field for the contact lookup. When the lookup dialog window is opened, the user can now search for a contact or create a new one, which navigates them to the quick create form for contact.
I would like to know, how I can go about adding fields to this form?
Secondly, and less importantly, does anyone know how to stop salesforce closing the browser dialog windows (for example the lookup dialog) when they loose focus?
Some of my custom object layout pages double-click inline editing functionality has stopped working. It has also stopped working on Contacts but not Accounts.
No doubt this is caused by something I have done, is anyone aware of what could cause this feature to break?
Hello, I hope someone can help me, I have the following function:
public static void CreateNote(Id parentId, string subject, string msg){
Note n = new Note();
n.Body = msg;
n.ParentId = parentId;
n.Title = subject;
insert n;
}
Now, I need to update the parent records last modified timestamp, but in order to query the parent I need to determine the parents sObjectType from the parentId.
I have a component which sits on a visualforce page, everytime this component is rendered I would like to do a check and insert some data. Initially I tried to put this code in the component controllers' constructor obviously this failed because no DML operations are allowed at this point.
Instead I now call the method from one of the components get properties. This appears to work and the debug logs show it as working, unfortunatly the data is not there. If I execute the same code anonamously from Eclipse it works perfectly.
Here is the log of the particular method in question:
17:6:34.930|METHOD_ENTRY|[16,6]|01pS00000005AJs|FieldAuditController.CreateSnapShot() 17:6:34.930|METHOD_ENTRY|[31,6]|01pS00000005AJs|FieldAuditController.MustCreateSnapshot() 17:6:34.930|METHOD_ENTRY|[46,192]|LIST<FieldAuditSnapshot__c>.size() 17:6:34.930|SOQL_EXECUTE_BEGIN|[46,15]|Aggregations:0|SELECT Id FROM FieldAuditSnapshot__c WHERE User__c=:Userinfo.getUserId() AND Month__c=:DateTime.Now().month() AND Year__c=:DateTime.Now().Year() AND ObjectType__c=:objectType 17:6:34.930|METHOD_ENTRY|[46,68]|Userinfo.getUserId() 17:6:34.930|METHOD_EXIT|[46,68]|Userinfo.getUserId() 17:6:34.930|METHOD_ENTRY|[46,118]|Datetime.month() 17:6:34.930|METHOD_ENTRY|[46,103]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,103]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,118]|Datetime.month() 17:6:34.930|METHOD_ENTRY|[46,154]|Datetime.Year() 17:6:34.930|METHOD_ENTRY|[46,139]|DateTime.Now() 17:6:34.930|METHOD_EXIT|[46,139]|DateTime.Now() 17:6:34.931|METHOD_EXIT|[46,154]|Datetime.Year() 17:6:34.937|SOQL_EXECUTE_END|[46,15]|Rows:0 17:6:34.937|METHOD_EXIT|[46,192]|LIST<FieldAuditSnapshot__c>.size() 17:6:34.937|METHOD_EXIT|[31,6]|FieldAuditController.MustCreateSnapshot() 17:6:34.938|METHOD_ENTRY|[36,18]|Userinfo.getUserId() 17:6:34.938|METHOD_EXIT|[36,18]|Userinfo.getUserId() 17:6:34.938|METHOD_ENTRY|[37,33]|Datetime.year() 17:6:34.938|METHOD_ENTRY|[37,18]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[37,18]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[37,33]|Datetime.year() 17:6:34.938|METHOD_ENTRY|[38,34]|Datetime.month() 17:6:34.938|METHOD_ENTRY|[38,19]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[38,19]|DateTime.Now() 17:6:34.938|METHOD_EXIT|[38,34]|Datetime.month() 17:6:34.938|METHOD_ENTRY|[39,5]|Database.insert(SOBJECT:FieldAuditSnapshot__c) 17:6:34.938|DML_BEGIN|[39,5]|Op:Insert|Type:FieldAuditSnapshot__c|Rows:1 17:6:34.979|DML_END|[39,5] 17:6:34.979|METHOD_EXIT|[39,5]|Database.insert(SOBJECT:FieldAuditSnapshot__c) 17:6:34.979|METHOD_EXIT|[16,6]|FieldAuditController.CreateSnapShot()
Here is the controller:
public without sharing class FieldAuditController {
public string objectType{get;set;}
public string title{get;set;}
public FieldAuditController(){ }
//for this prototype we'll just use the candidate object with a small set of fields
public integer AuditPercent{
get{
if(AuditPercent == null){
//these queries would be where we filter by date
string q = 'SELECT AVG(Completedness__c) FROM '+objectType+' WHERE OwnerId=\''+Userinfo.getUserId()+'\'';
AggregateResult result = Database.query(q);
AuditPercent = double.valueOf(result.get('expr0')).intValue();
CreateSnapShot();
}
return AuditPercent;
}
set;
}
// the incomplete percentage
public integer AuditIncompletePercent{
get{
return 100 - AuditPercent;
}set;
}
public void CreateSnapShot(){
//check if its neccessary to create snapshot
if(MustCreateSnapshot()){
FieldAuditSnapshot__c ss = new FieldAuditSnapshot__c();
ss.Complete__c = AuditPercent;
ss.ObjectType__c = objectType;
ss.User__c = Userinfo.getUserId();
ss.Year__c = DateTime.Now().year();
ss.Month__c = DateTime.Now().month();
Database.insert(ss);
}
}
private boolean MustCreateSnapshot(){
//Query the FieldAuditSnapshot__c record to see if a snapshot has been created for this user on candidate for this month and year
integer c = [SELECT Id FROM FieldAuditSnapshot__c WHERE User__c=:Userinfo.getUserId() AND Month__c=:DateTime.Now().month() AND Year__c=:DateTime.Now().Year() AND ObjectType__c=:objectType].size();
if(c==0){
return true;
}
return false;
}
}
I have a visualforce page for a custom object with an input field for the contact lookup. When the lookup dialog window is opened, the user can now search for a contact or create a new one, which navigates them to the quick create form for contact.
I would like to know, how I can go about adding fields to this form?
Secondly, and less importantly, does anyone know how to stop salesforce closing the browser dialog windows (for example the lookup dialog) when they loose focus?
I used to create Work Order object using a Custom Button (create work order) in Service Order page. This used to call one S-Control which had sforce.connection.create([workorder]);
How can I do similar thing in visualforce, it seems I can't execute any DML like that.
I've set the attribute to required="true" and as far as I can tell it has not effect at all.
I added an onsubmit javascript function:
function validateForm() {
var fileVal = document.getElementById("{!$Component.UploadForm.firstBlock.requiredElements.fileNameSection.theFile}").value;
if ("" == fileVal) {
alert("The File Name field is required.");
return false;
}
var accessVal = document.getElementById("{!$Component.UploadForm.firstBlock.requiredElements.fileAccessSection.theAccess}").value;
if ("" == accessVal) {
alert("The File Access field is required.");
return false;
}
var folderVal = document.getElementById("{!$Component.UploadForm.firstBlock.requiredElements.fileFolderSection.theFolder}").value;
if ("" == folderVal) {
alert("The Folder field is required.");
return false;
}
}
I've tested the javascript function against inputText, inputTextarea, and selectList and it works just fine. I have verified that I am accessing the inputFile field using the same pattern as all other fields and have even compared the actual View Source on the form against the $Component call.
How can I make my inputFile field absolute required? I don't want the user to be able to submit the form without specifying a file to upload.
