11
votes
Accepted
How to identify look up relations to an object in Salesforce
You could get this with apex describe methods:
for ( Schema.ChildRelationship scr : Account.sObjectType.getDescribe().getchildRelationships() ){
system.debug('');
system.debug('**** Child ...
- 12.5k
5
votes
How to identify look up relations to an object in Salesforce
There are couple of tools thats very helpful
1.Workbench
You can see the Childrelationships to see all the all the objects for which the object is looked upto
2.Appexchange app named Schema Surfer
...
- 89.3k
3
votes
How to identify look up relations to an object in Salesforce
You can also use Etherios EasyDescribe - Free MetaData Viewer/Extractor from AppExchange which is shown below. You can also export the result to excel format.
And also it has many other features.
- 35.7k
2
votes
How to Print/Export the schema builder?
There is a product called Safyr that extracts metadata from SFDC and among other things, allows tables to be visualized as e-r diagrams, both within the product itself, and in a bunch of data ...
- 21
2
votes
Data view schema in marketing cloud
The most common case would be to leverage joins on "jobid" or "SubscriberKey".
For instance (I am using _job and _open data views)
SELECT
j.[JobID]
,j.[JobType]
,o.[EventDate]
FROM _job as j
...
- 768
2
votes
Issues with SchemaSpy
It's a good few years since I wrote and used this (assuming you are using force-metadata-jdbc-driver here), but looking at the stacktrace, you need more escaping in the url that is buried in the ...
- 134k
1
vote
Accepted
Get Schema of all sObjects in one Api Call, like Schema Builder
Composite REST resource would have been our suggestion but it has a limit of 25 sub-requests, same as Batch. A better out of the box solution is describeSObjects() in SOAP API:
<soapenv:Envelope ...
- 6,879
1
vote
Accepted
Match two Sobject field API Names and put the common in a Set
Try this:
public static String Compare(String str, String str1){
String sObjectName = str;
String sObjectName1 = str1;
List<String> fieldsS1 = new list<String>();
List<...
- 1,438
1
vote
Why note & attachment object is not displayed in schema builder
Imagine they do this to prevent clutter in the UI. You can see the erd here.
https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_erd_documents.htm
- 2,375
1
vote
How to identify look up relations to an object in Salesforce
I assume that you need this info for your use and do not need it in apex.
if that is true then are two MORE easy ways to get it.
A)Use eclipse (or any IDE)and find in files.
Here are steps:
1) ...
- 9,090
1
vote
Alternative to schema builder?
Not sure about what profile settings are required to run this as I usually use an SA account, but it basically uses describe calls to pull out the information thand then uses SchemaSpy to format the ...
- 134k
1
vote
Alternative to schema builder?
If the use case is to view the schema (As I understand from your question), you can install one of the many apps from AppExchange and provide the team access for that.
The one app I can find is ERD ...
- 7,893
1
vote
Printable ERD from Salesforce that you can Edit
Safyr is a tool from Silwood Technology that pulls metadata out of any Force based environment and allow data models to be built in a range of data modelling tools like ERwin and ER/Studio. It also ...
- 11
Only top scored, non community-wiki answers of a minimum length are eligible