I have used Eclipse in the past but unfortunately, Eclipse and Force.com IDE no longer work for me. I have switched over to VSCode along with the Salesforce DX and forcecode extensions (among many others) and this is the first time I have used this software. I was able to download all of the metadata from my salesforce instance. Now I need to perform a search to find all reports that use a specific field. Can anyone help walk me through the process to achieve this search? And once the search is completed, how do I replace a specific field used in a report with another field?
I've created a custom Lookup field to look into Accounts and have the ability to multi-select accounts. I want to place this field on the Opportunity Object as we have an Account Record Type for Partners. I want to be able to select multiple partners that will work on an opportunity. The lookup works but I am not able to display checkboxes for a multiselect function. Can anyone help?
Apex Class CustomAccountLookupController
public with sharing class CustomAccountLookupController {
public Account account {get;set;} // new account to create
public List<Account> results{get;set;} // search results
public string searchString{get;set;} // search keyword
public CustomAccountLookupController() {
account = new Account();
// get the current search string
searchString = System.currentPageReference().getParameters().get('lksrch');
runSearch();
}
// performs the keyword search
public PageReference search() {
runSearch();
return null;
}
// prepare the query and issue the search command
private void runSearch() {
// TODO prepare query string for complex serarches & prevent injections
results = performSearch(searchString);
}
// run the search and return the records found.
private List<Account> performSearch(string searchString) {
String soql = 'select id, name from account';
if(searchString != '' && searchString != null)
soql = soql + ' where name LIKE \'%' + searchString +'%\'';
soql = soql + ' limit 25';
System.debug(soql);
return database.query(soql);
}
// save the new account record
public PageReference saveAccount() {
insert account;
// reset the account
account = new Account();
return null;
}
// used by the visualforce page to send the link to the right dom element
public string getFormTag() {
return System.currentPageReference().getParameters().get('frm');
}
// used by the visualforce page to send the link to the right dom element for the text box
public string getTextBox() {
return System.currentPageReference().getParameters().get('txt');
}
}
Apex Class MyCustomLookupController
public with sharing class MyCustomLookupController {
public Contact contact {get;set;}
public MyCustomLookupController() {
contact = new Contact();
}
}
<apex:page controller="MyCustomLookupController" id="Page" tabstyle="Contact">
<script type="text/javascript">
function openLookup(baseURL, width, modified, searchParam){
var originalbaseURL = baseURL;
var originalwidth = width;
var originalmodified = modified;
var originalsearchParam = searchParam;
var lookupType = baseURL.substr(baseURL.length-3, 3);
if (modified == '1') baseURL = baseURL + searchParam;
var isCustomLookup = false;
// Following "001" is the lookup type for Account object so change this as per your standard or custom object
if(lookupType == "001"){
var urlArr = baseURL.split("&");
var txtId = '';
if(urlArr.length > 2) {
urlArr = urlArr[1].split('=');
txtId = urlArr[1];
}
// Following is the url of Custom Lookup page. You need to change that accordingly
baseURL = "/apex/CustomAccountLookup?txt=" + txtId;
// Following is the id of apex:form control "myForm". You need to change that accordingly
baseURL = baseURL + "&frm=" + escapeUTF("{!$Component.myForm}");
if (modified == '1') {
baseURL = baseURL + "&lksearch=" + searchParam;
}
// Following is the ID of inputField that is the lookup to be customized as custom lookup
if(txtId.indexOf('Account') > -1 ){
isCustomLookup = true;
}
}
if(isCustomLookup == true){
openPopup(baseURL, "lookup", 350, 480, "width="+width+",height=480,toolbar=no,status=no,directories=no,menubar=no,resizable=yes,scrollable=no", true);
}
else {
if (modified == '1') originalbaseURL = originalbaseURL + originalsearchParam;
openPopup(originalbaseURL, "lookup", 350, 480, "width="+originalwidth+",height=480,toolbar=no,status=no,directories=no,menubar=no,resizable=yes,scrollable=no", true);
}
}
</script>
<apex:sectionHeader title="Demo" subtitle="Custom Lookup" />
<apex:form id="myForm">
<apex:PageBlock id="PageBlock">
<apex:pageBlockSection columns="1" title="Custom Lookup">
<apex:inputField id="Account" value="{!contact.AccountId}" />
</apex:pageBlockSection>
</apex:PageBlock>
</apex:form>
</apex:page>
I have a lookup field to the Contacts object on Opportunities object which is to define the Primary Point of Contact (dont want to use Contact Roles). There is another lookup field on that Contact record page which is supposed to be a lookup back to the Opportunity.
When a Lead gets converted to an Opportunity, I want my sales rep to use the lookup field (Primary Point of Contact) to select the contact. From there, I would like to have the Opportunity lookup field on the Contact Record page to be populated.
I have a lookup field to the Contacts object on Opportunities object which is to define the Primary Point of Contact (dont want to use Contact Roles). There is another lookup field on that Contact record page which is supposed to be a lookup back to the Opportunity.
When a Lead gets converted to an Opportunity, I want my sales rep to use the lookup field (Primary Point of Contact) to select the contact. From there, I would like to have the Opportunity lookup field on the Contact Record page to be populated.
