[SalesForce] Junction Object Lookup field

Solution 1: URL Hacking without JS

URL hacking doesn't require you to use javascript. I created a short video to explain the way URL hacking works a couple of years ago.

The simplest way is to use URL hacking in your live system and refresh your sandbox. The field ids for fields in live and sandbox systems are the same after a refresh.

However, this doesn't answer your question. Therefore there is solution 2.

Solution 2: Apex and Tooling API

As proposed by Andy you can use the Tooling API to get field Ids from Salesforce. He is using APEX and a Tooling API wrapper to query the required field ids:

// Constructs the Tooling API wrapper (default constructor uses user session Id)
ToolingAPI toolingAPI = new ToolingAPI();

// Query CustomObject object by DeveloperName (note no __c suffix required)
List<ToolingAPI.CustomObject> customObjects = (List<ToolingAPI.CustomObject>)
     toolingAPI.query('Select Id, DeveloperName, NamespacePrefix From CustomObject Where DeveloperName = \'Test\'').records;

// Query CustomField object by TableEnumOrId (use CustomObject Id not name for Custom Objects)
ToolingAPI.CustomObject customObject = customObjects[0];
Id customObjectId = customObject.Id;
List<ToolingAPI.CustomField> customFields = (List<ToolingAPI.CustomField>)
     toolingAPI.query('Select Id, DeveloperName, NamespacePrefix, TableEnumOrId From CustomField Where TableEnumOrId = \'' + customObjectId + '\'').records;

// Dump field names (reapply the __c suffix) and their Id's
System.debug(customObject.DeveloperName + '__c : ' + customObject.Id);
for(ToolingAPI.CustomField customField : customFields)
     System.debug(
          customObject.DeveloperName + '__c.' +
          customField.DeveloperName + '__c : ' +
          customField.Id);

In the most scenarios this kind of "hack" seems to be a bit too complicated compared to standard URL hacks...

Implementation outline for Solution 2

1. Create a new visualforce page. Make sure that you are using the standard controller of your object.
2. Create a new custom controller to extend the existing standard controller
3. Implement a method which returns a page reference.
4. use the tooling api right, within your method to query the required field ids and construct the new url (like you would have done it in a standard URL hack.)
5. don't forget to wire the visualforce page action attribute with the action method which was implemented before

6. Create a new button which opens the new visualforce page.

7. Don't forget to write a test class. Don't forget to mock all call outs. (callouts are not available during test)

Before implementing 1-6 please consider the following aspects:

• Using the tooling API will consume a bunch of API request. (Make sure that consuming the requests is ok. Or implement a caching mechanism.)
• The implementation takes some time (I assume that it will take about 1 day to implement.) Additional testing might be required.

Try this

1. Create a formula field on package version object and which gets the program value for the related Package record. Something like this

   Package__r.Program__c

2. Create another formula field on Release object to get the related Program value.

   Program__c

3. Create a lookup filter to match both of these values.

Select field in the Value/Field section of the filter editor and it will let you to compare with Version record.

Hope this helps !!