Is it possible to write records to the ExternalDataUserAuth object via Apex code?
When I try to write some Apex code to insert records into the ExternalDataUserAuth object I get an 'illegal dml object' message.

I know that you can create records manaually using the UI but our solution requires that we create these records automatically via code.

Any help appreciated.
 

Hello,
I am trying to deploy a community from one sandbox to another sandbox using the sfdx force:source:deploy command from with VS Code.
I have successfully retrieved the community components using a manifest file into a VS Code project.
However when deploying these components to a different sandbox I get the error below:
ExperienceBundle  force-app\main\default\experiences\Self_Service_Portal1.site-meta.xml  You seem to be missing the property componentAttributes in Self_Service_Portal1/themes/ember.json with component ID: 06515b9d-2dcf-4ac4-9b20-7371a1274f93

I have looked at the ember.json file and the component with the ID is named "siteforce:themeLayoutStarter".
I have looked at the ember.json file in the target sandbox and the values are exactly the same, so it exists in the target sandbox?
So it would seem I need the component within my project and part of the deployment?
Any help appreciated.
 

When setting your Dev Hub using SFDX does it have to be your production org?

Or can you set a sandbox as your Dev Hub?
 

I was wondering what peoples views were on big deployments when you have hundreds of components of various types.

I have seen developers build one huge change set which includes everything, so hundreds of components including Apex code, sharing rules, custom objects, process flows etc.

I have also seen developers break this down into smaller more manageable change sets, deployed in a strategic order. For example, the first changes set would include the custom objects and fields, so the data model is deployed. The second change set the Apex code and flows etc. A third changes set for sharing rules, permission sets etc. A fourth change set including page layouts, Lightning Pages.

What are peoples views on this, is it just preference, does one method make it easier to deploy?
 

I want to be able to create a Case and when the Case is created automatically link a File or Attachment.

I have a word document that I want attached to cases when they are created.

What is the best way to achieve this? Presumably it will require Apex code? Will I need to make a copy of the Word document from somewhere then create the required File records to attach it to the Case?
 

Our Salesforce team are planning to use a code repository to commit all code changes.
However, the question we are currently asking ourselves is what metatdata should be committed to the repository.
We definately want all Apex code and triggers under version control.
We are thinking that profiles and permission sets should be excluded from version control.
However what about standard and custom objects, which of course include validation rules, sharing etc?
And what about workflow rules, process flows etc, they contain logical processing so should they be under version control?

Lots to think about, if anyone has been through this and has any advice on what worked well for them that would be great.

Many thanks

What is the best way to create an index on a custom field?

I believe the only way to do this yourself is by creating the custom field as an External Id, this ensures the field has an index.

Is that the best option? Is there any down side to doing this?

Regards
 

Is there any way of displaying a picklist within an aura datatable?

I've read that only certain data types can be used within a datatable, but there must be a way of displaying a picklist or something similar where the user can select a value from a list of values?

Anybody managed to do this?
 

I'm using the Lightning Datatable component as an editable table.
When I click the Save button I am able to retrieve the draftValues however the record Id's are not stored, only the row id of the table, for example id=row-1.

So when I call my Apex controller to save the values I get the exception:

FATAL_ERROR|System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

I'm having issues when using the Bulk API to upsert records with an Autonumber field. The field in question is the Name field on a custom object, which has a datatype of Autonumber.

I wouldn't expect to have to pass a value for an Autonumber field but I get the following error:
MISSING_ARGUMENT:Name not specified:

If I pass a value for the autonumber field I get the following message:
INVALID_FIELD_FOR_INSERT_UPDATE:Unable to create/update fields

Any idea of what the issue might be, should I be passing a value at all?

I'm aware that the Summer 19 release has caused an issue with parameters in URL's so they need to be prefixed with the default c__ name space.
Is this issue also effecting lightning events? As the event below has stopped working due to the contractId parameter being undefined?
I have tried prefxing the parameter name with c__ but that hasn't worked.
 

navigateToPlan : function(component, event) {

        var contractId = event.target.attributes.getNamedItem("data-contractid").value;

        var navigateEvent = $A.get("e.force:navigateToComponent");
        navigateEvent.setParams({
            componentDef : 'c:ContractPage',
            componentAttributes: { contractId : contractId }
        });

        navigateEvent.fire();
    }

 

I have been using the lightning:listView componenet and have successfully got one to display within a community page.

However, the nature of the lightning:listView component is that it links itself directly to an existing List View.

I would like to use the functionlaity of a lightning:listView component within my community but I want to be able to select the data from potentially more than one object, so I might need a SOQL query.

Is there a way to achieve this, or if I have to create something that gives my the ordering and search capability of a List View what's the best way to create it?

Regards
 

Hi there,

I want to be able to bring data from an on premise Oracle database into external objects within a Salesforce Org.

Can the OData connectors be used to connect to an on premise Oracle database?
If not, is there a type of connector that will allow me to connect to an on premise Oracle database or will I have to write an Apex solution or use Heroku?

Any help appreciated. I understand the concept of using external objects, its just determini g the best way to connect to the Oracle database.

Many thanks

Jon

What are peoples thoughts on spreading record ownership in the database?

For example, if you have 5 million Account records, many of which have been uploaded from an extenal system Salesforce suggests the records are not all owned by one User as it can cause data skew, which in turn can cause cause issues with future processing.

Do you spread ownership of the Account records with some selected Users within the business, preferably Users high up in the role hierarchy so it's easier to share the records.

Do you spread ownership of the records between selected System Admin users? This was business users will not automatically gain access to any Account records, only via sharing rules?

What if you have an ETL that is uploading new Account records regularly, these will be created using the owner of the process, do you put something in place to spread ownership of all records created vai the ETL?

 

Hello,

I have an Apex controller that updates a Case record then redirects back to a Case Lightning Record Page. Although the redirect to the Case page is successful, the values on the page are not refreshed, so still showing the old values?

I am using the code below:

        PageReference retURL = new PageReference('/lightning/r/Case/' + updatedCase.Id + '/view');
        retURL.setRedirect(true);
        return retURL;

I don't understand why it would navigate to the Case Lightning Page but not display the latest values?

Anybody had similar issues, if so how did you resolve this?
 

I have read in the Salesforce documentation that it is not possible to create a custom button and pass parameters in Lightning Experience.

Is there any way to resolve this? I have tried a few things but cant not get the values to pass through.

I am trying to create a custom List button, when clicked I want to create a new record but pass through some of the values from the original record. This was working fine with a URL button in classic, but the values are not passed through in Lightning Experience.

 

Hello all,

I am having some difficulty with Step 8 of the Advanced Apex Specialist Superbadge.

I am getting the following error:



I have written all my test classes and test methods and have the sufficient coverage as below:



I can't see what the issue is, I have tried a few things but nothing seems to work. I'm not sure what I could have changed so that the logic that was working for a previous challenge is no longer working?

My guess is that it is some random thing and the error message is misleading.

Anybody had a similar error message?

Thanks in advance.
 

I keep getting this on the 'Check Challenge' for Step 4 of the Adavanced Apex Specialist:

Ensure constructAccounts returns a list of size cnt of uniquely named Account records with all of the required fields populated.

This makes no sense to me as my method does create the correct number of Accounts and places them in a List? They are also uniquely named?

     /**
     * @name CreateAccounts
     * @description Constructs a list of Account records for unit tests
    **/
    public static List<Account> ConstructAccounts(Integer cnt) {
    
        // Ensure this method returns a list of size cnt of uniquely named Account records
        // with all of the required fields populated.
        
        List<Account> accounts = new List<Account>();
        
        // Create the number of Accounts that was passed in
        for (Integer i=0; i < cnt; i++ ) {
            
            Account oAccount = new Account();
            
            oAccount.Name = 'TestAccountLtd_' + cnt;
            
            accounts.add(oAccount);
            
        }
        
        return accounts;
    }

Any ideas why it is failing this?

 

Hello all,

Since the introduction of Summer 16 we have started seeing a new Warning message appear on a custom Visualforce page, see below:



We have no idea why this warning message has started displaying, having looked at the controller code it is working as expected and is not throwing any exceptions, the data loads and displays as we would expect?

This is not a warning message we have customised the code to display so must be a Salesforce generated message. The custom Visualforce page is a customised page showing Knowledge articles, not sure if this has any relevance.

Anybody seen anything similar since Summer 16 was introduced?

Thanks
 

Hello,
I am trying to deploy a community from one sandbox to another sandbox using the sfdx force:source:deploy command from with VS Code.
I have successfully retrieved the community components using a manifest file into a VS Code project.
However when deploying these components to a different sandbox I get the error below:
ExperienceBundle  force-app\main\default\experiences\Self_Service_Portal1.site-meta.xml  You seem to be missing the property componentAttributes in Self_Service_Portal1/themes/ember.json with component ID: 06515b9d-2dcf-4ac4-9b20-7371a1274f93

I have looked at the ember.json file and the component with the ID is named "siteforce:themeLayoutStarter".
I have looked at the ember.json file in the target sandbox and the values are exactly the same, so it exists in the target sandbox?
So it would seem I need the component within my project and part of the deployment?
Any help appreciated.
 

I want to be able to create a Case and when the Case is created automatically link a File or Attachment.

I have a word document that I want attached to cases when they are created.

What is the best way to achieve this? Presumably it will require Apex code? Will I need to make a copy of the Word document from somewhere then create the required File records to attach it to the Case?
 

Hello there,
We have a strange situation where all our Lightning Components have stopped working in one of our sandboxes?
When you try to open a field to edit a value the component just goes blank?
Anyone else had this issue?
Any idea what it could be?
 

Our Salesforce team are planning to use a code repository to commit all code changes.
However, the question we are currently asking ourselves is what metatdata should be committed to the repository.
We definately want all Apex code and triggers under version control.
We are thinking that profiles and permission sets should be excluded from version control.
However what about standard and custom objects, which of course include validation rules, sharing etc?
And what about workflow rules, process flows etc, they contain logical processing so should they be under version control?

Lots to think about, if anyone has been through this and has any advice on what worked well for them that would be great.

Many thanks

Is there any way of displaying a picklist within an aura datatable?

I've read that only certain data types can be used within a datatable, but there must be a way of displaying a picklist or something similar where the user can select a value from a list of values?

Anybody managed to do this?
 

I'm using the Lightning Datatable component as an editable table.
When I click the Save button I am able to retrieve the draftValues however the record Id's are not stored, only the row id of the table, for example id=row-1.

So when I call my Apex controller to save the values I get the exception:

FATAL_ERROR|System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

I'm having issues when using the Bulk API to upsert records with an Autonumber field. The field in question is the Name field on a custom object, which has a datatype of Autonumber.

I wouldn't expect to have to pass a value for an Autonumber field but I get the following error:
MISSING_ARGUMENT:Name not specified:

If I pass a value for the autonumber field I get the following message:
INVALID_FIELD_FOR_INSERT_UPDATE:Unable to create/update fields

Any idea of what the issue might be, should I be passing a value at all?

Hi there,

I want to be able to bring data from an on premise Oracle database into external objects within a Salesforce Org.

Can the OData connectors be used to connect to an on premise Oracle database?
If not, is there a type of connector that will allow me to connect to an on premise Oracle database or will I have to write an Apex solution or use Heroku?

Any help appreciated. I understand the concept of using external objects, its just determini g the best way to connect to the Oracle database.

Many thanks

Jon

Hello,

I have an Apex controller that updates a Case record then redirects back to a Case Lightning Record Page. Although the redirect to the Case page is successful, the values on the page are not refreshed, so still showing the old values?

I am using the code below:

        PageReference retURL = new PageReference('/lightning/r/Case/' + updatedCase.Id + '/view');
        retURL.setRedirect(true);
        return retURL;

I don't understand why it would navigate to the Case Lightning Page but not display the latest values?

Anybody had similar issues, if so how did you resolve this?
 

Hello all,

I am having some difficulty with Step 8 of the Advanced Apex Specialist Superbadge.

I am getting the following error:



I have written all my test classes and test methods and have the sufficient coverage as below:



I can't see what the issue is, I have tried a few things but nothing seems to work. I'm not sure what I could have changed so that the logic that was working for a previous challenge is no longer working?

My guess is that it is some random thing and the error message is misleading.

Anybody had a similar error message?

Thanks in advance.
 

I keep getting this on the 'Check Challenge' for Step 4 of the Adavanced Apex Specialist:

Ensure constructAccounts returns a list of size cnt of uniquely named Account records with all of the required fields populated.

This makes no sense to me as my method does create the correct number of Accounts and places them in a List? They are also uniquely named?

     /**
     * @name CreateAccounts
     * @description Constructs a list of Account records for unit tests
    **/
    public static List<Account> ConstructAccounts(Integer cnt) {
    
        // Ensure this method returns a list of size cnt of uniquely named Account records
        // with all of the required fields populated.
        
        List<Account> accounts = new List<Account>();
        
        // Create the number of Accounts that was passed in
        for (Integer i=0; i < cnt; i++ ) {
            
            Account oAccount = new Account();
            
            oAccount.Name = 'TestAccountLtd_' + cnt;
            
            accounts.add(oAccount);
            
        }
        
        return accounts;
    }

Any ideas why it is failing this?

 

Hi All,

I am facing below issue with Advance apex specialist Challenge 8.

Challenge Not yet complete... here's what's wrong: 
Ensure that product2Controller is still working as specified in the earlier challenge.

Not able to resolve it even after lot of attempts.Any help would be greatly appreciated.

Note: My code coverage seems to be fine for all the classes

Hi,

 We have a requirement to integrate salesforce with oracle DB. We need the the ability to create, read, edit and delete on the oracle DB and data should be stored in oracle DB from salesforce.

 We can use lightening connect to create, read, edit and delete data from and into an external system using any of these adapters.
A.    OData 2.0 adapter or OData 4.0 adapter
B.    Salesforce adapter
C.    Custom adapter created via Apex

***But we read from blogs and lighting connect documentation that there are limitations/challenges in using lightining connect for write/delete/update to external system.

We have any ODBC/JDBC kind of plug ins to connect from salesforce to Oracle DB?. Please provide any information  or any other options on how can we connect salesforce to oracle DB other then lightning connect adapters.

Thanks,
Naveen