Questions tagged [hierarchy]
Hierarchical relationships, i.e. Account, Case, User, Campaign hierarchies.
2
votes
1answer
80 views
How to redirect to the standard Lightning Account Hierarchy page? [closed]
How can I add a button to the custom lightning component, which will be hidden is Account is not a part of hierarchy and, if visible, will redirect to the standard Lightning Account Hierarchy page for ...
0
votes
2answers
51 views
Retrieve the subscribers from each business unit
Starting from the All Subscribers list of the parent business unit, I'm trying to know which subscribers are being part of each child business unit.
As it is not defined any Subscriber Filter, how ...
0
votes
1answer
19 views
Selecting a hierarchy column from the same object
I have a query I've written for the Organization/Account object
SELECT ID, Name, BillingStreet, BillingCity, BillingState,
BillingPostalCode, County__c, Phone, ParentId
FROM Account
This ...
0
votes
2answers
35 views
Add list in another list (building hierarchy tree)
I'm new to Apex (actually in programming in general) and am trying to build a hierarchy tree with 4 objects: Account, Carteira__c, Produtos_das_carteiras__r and AtivosFundo__c
One Account can have N ...
0
votes
0answers
43 views
Sharing Account's Related Records of Custom Object for Communities User
I know this question has been asked, and as I browsed the questions I'm still confused about how to approach my problem.
My custom object is related to Account with a lookup relationship. I want ...
0
votes
2answers
227 views
How to query the Hierarchical Relationship inside the User Object?
I want to get the Users which report to a particular user (A manager) by using the Hierarchical Relationship inside the User Object. Appreciate if someone can give an example.
Small clarification:
...
1
vote
0answers
43 views
Programmatic Access to “Grant Access Using Hierarchies”?
Is there any way to retrieve the "Grant Access Using Hierarchies" setting programmatically (i.e. through Metadata, SOQL, or other means)?
I am referring to the checkbox next to each object under ...
1
vote
1answer
42 views
Update Parent record in hierarchical relationship
I want to be able to update parent record based on changes that I make in child record. Object A has 2 record types ABC and XYZ. And object A has self lookup. ABC is parent and XYZ is child record. ...
1
vote
1answer
48 views
How can I pull the manager's manager?
I have a request to build an approval process on a custom object and the request should be routed to the "Director" (ie, the record owner's manager's manager), and it appears the way to accomplish ...
0
votes
0answers
48 views
Multiple Managers on a Forecast hierarchy scenario
In our Org we have 3 levels on Sales department :
-CCO
-Team Leader
-Sales
So the thing is we have at the moment 3 teams, each one with it's leader and 4 Sales on each of those teams.
Upon ...
0
votes
0answers
22 views
Access Parent Levels in a sObject dynamicly given a parent field [duplicate]
I am attempting to build a query where I can attain values from "N" levels upwards.
This is what I want to implement to SOQL
select id from OBJECT where searching-field LIKE ‘TERM%’ AND
(...
0
votes
2answers
651 views
Hierarchy diagram in Lightning
Has anyone ever tried to create a role hierarchy type relationship logic in Lightning with similar visualization of the hierarchical diagram?
I've a VF page where the same has been done using a JS ...
2
votes
0answers
49 views
Grant Access Hierarchy
I have a query on Grant access hierarchy and sharing rule.
I have in my system Accounts being shared to Users through Account Share , Group and Territory. Now, I have A1 account shared to T1 ...
0
votes
1answer
83 views
What is better - self relationship or custom object?
I need to relate Opportunities to other Opportunities. What is the best way to go about this?
Lookup to itself?
Create a custom object for a many to many relationship between Opps?
Eg a potential ...
0
votes
2answers
121 views
Comparing account.parentId SOQL
Is it possible to to compare the parent id of an account to another account? i.e.
SELECT Id from Account WHERE child_account.parentId = parent_account.Id;
I keep getting the 'Unknown Error parsing ...
0
votes
0answers
89 views
Need count of closed won Opportunity of Account in 3 Account Hierarchy level
We are maintaining Account Hierarchy in our Org as below.
I need to write a Trigger on Opportunity and update the Account field 'countofOpps__c'with count of closedwon Opportunity under each Account(...
3
votes
1answer
55 views
Can the My Domain feature support multiple domains
Salesforce Org has two companies using it - where one is a wholly owned subsidiary of the other. We now need to enable My Domain for Lightning components to work and have a business request that we ...
0
votes
1answer
103 views
Custom Picklist field of the custom object values that have hierarchy levels
I want to implement the following idea:
Account has a custom picklist field where you can select the related territory (another custom object that has name and parent territory) for it. Territory ...
1
vote
1answer
437 views
How can I create a hierarchy (parent/child relationship) within the same object?
I have custom object Territory that can have a parent Territory and child Territory. For example, Territory "United Kingdom" with child territories "Scotland", "Wales", "North Ireland" etc. Each of ...
0
votes
0answers
318 views
Creating Account Hierarchy Page
I'm trying to utilize a piece of AppShare for hierarchy presentation which drops down and closes when clicked, found here:
When I run the page I'm getting the following error:
System....
0
votes
1answer
92 views
Expose Hierarchical Objects
I would like the parent's view of an Account object to see the opportunities of their children. For example:
Let's say in Accounts, I have a hierarchy: say Acct1_Global it has some children ...
1
vote
2answers
2k views
Get a list of child accounts for any given parent account using apex [closed]
I have a requirement where i have the following need. If the account is a parent account, i need to loop and traverse through each child account and get a list of child accounts at any level deep. ...
3
votes
1answer
103 views
Apex example code to create, get and update user settings?
<Long intro that can be skipped>
I have a VFP that displays output from a standard controller. It's a very simple setup with nothing particularly difficult in it however it does allow the user ...
2
votes
1answer
196 views
Salesforce process builder - When removing active account from hierarchy, failed but works when added to hierarchy
I currently created a process which checks if a parent account is present, has been changed and checks if a parent field contains a certain value. If these conditions are met, update other fields in ...
3
votes
1answer
706 views
Cascade delete records
I have one object, for example Area. It has two lookup relationships to itself, Parent__c, Child__c. In result I can create record with Parent and Child parameters. I am trying build hierarchy.
And ...
0
votes
1answer
258 views
Visual Work Flow Account Hierarchy
I have a visual work flow on Accounts and I need to evaluate whether a field on the parent, sibling, or child accounts related to the account the flow was launched on is blank or not. I'm looking at ...
1
vote
0answers
55 views
Stop at 1 level while traversing account hierarchy using parent accounts
I have an interesting requirement. The requirement is that if an account is a parent account and a custom field is changed say account manager field, then immediately update the children of the parent ...
0
votes
0answers
1k views
Build a dynamic hierarchy tree in Visulforce using VF Components
I'm trying to create a tree hierarchy in Visualforce using a Visualforce component in order to be able to reuse as much code as I can and make it as dynamic as possible. I'll post my code below, but ...
2
votes
1answer
2k views
Account Hierarchy - Trigger - Update All Accounts in Hierarchy
I have following requirement in hand -
Update each account's field count__c in the Account Hierarchy.
where count__c = Count_of_Custom_Object_Records on Account + count from all Accounts who are ...
3
votes
1answer
237 views
Unit Testing Complex Account hierarchies w/o SeeAllData
I need to write some unit tests for a project that involve some complex account hierarchies where most, if not all are related to some kind of master account or parent account that I can't create from ...
2
votes
3answers
671 views
Need a custom field Grand parent Account which has highest level of account heirarchy
I need to create a custom field "Grand parent account" which has the highest level of account hierarchy. Maximum child records can be up to 500 as per salesforce. So,how can i get grand parent account ...
3
votes
0answers
159 views
Show direct ancestors/descendents only, not siblings/aunts/uncles/cousins
I used unmanged package account inline hierarchy from appexchange :
https://appexchange.salesforce.com/listingDetail?listingId=a0N300000016chCEAQ
and tweaked the code to use it for custom object.
...
1
vote
1answer
81 views
Query for parent in hierarchy
Trying to query the main parent in the hierarchy.
I have a case whose related account is a child of another account in hierarchy. Can someone please suggest how to query for the main parent in the ...
1
vote
0answers
23 views
Report with a wrong Territory View
I created
a custom Report Type "O-p-p".
A report X with the "O-p-p" custom Report Type.
When I build the report I cannot see any row, because it is set with a certain territory point of view in the ...
3
votes
3answers
390 views
Users hierarchy
I can't find how to create an Users hierarchy. I have several users in SalesForce and I want to create a hierarchy. For example, I will have Developers and Manager. I want to attach some Developers to ...
1
vote
1answer
743 views
How to deal with Activities in a Case Hierarchy?
Let's consider a Case in the service sense of the word - a caller calls up with a situation ("My printer's broken."). Now, maybe the caller calls up about more than one situation ("My printer's ...
1
vote
1answer
161 views
Trigger not working, not able to understand the concept of list map
I am building a trigger on an object called project board. so whenever a record is updated/inserted I want it to fire. It is linked to another object called project. So what I want is to count all the ...
0
votes
1answer
438 views
How do I reference a custom field of datatype hierarchy in a Workflow rule
I have a custom field on my Account object which is of type Hierarchy (which is for the Object User). I have never come across this before, and I cannot find out how to reference that field in my ...
2
votes
2answers
2k views
Visualizing Many to Many relationship between Accounts (as Network-Structure not as Tree)
I have a many-to-many relationship between accounts. Somewhat like below:
A B
| |
|_|
C
|____
| | |
D E F
I want to give the user a nice hierarchical view to see all the parents (including ...
1
vote
4answers
4k views
How to use Save Hierarchy level in Salesforce reports
Any idea about How to use Save Hierarchy level in Salesforce reports. Cannot see the option to choose this on the report. How do I see data based on roles.
2
votes
2answers
3k views
How can I see aggregated sales per account according to it's parent account?
Our accounts are structured into hierarchies, each can have it's own opptys.
I need a report that aggregates the sales/opptys to the parent (even for a multi-tiered tree - more than 2 levels)
How ...
2
votes
1answer
225 views
Campaign Hierarchy in search layout?
Is it possible to show campaign hierarchy in the search layout?
Ideally I'd like the search layout to mimic the indentation that gives a visual representation of search layout on the campaign layout ...
2
votes
1answer
252 views
Reporting Query to use in Klipfolio for 3 levels deep case hierarcy
- I have a 3 levels deep case hierarchy:
Case level 1 (1.createdate, 1.closedate, 1.type, 1.subtype)
|
+---> Case level 2 (2.createdate, 2.closedate, 2.type, 2.subtype)
|
+---> Case ...
1
vote
1answer
2k views
Account hierarchy in salesforce
We have school district offices that have numerous buildings such as high schools, middle schools, and elementary schools underneath them. We need a way to assign the district office as the Parent ...
6
votes
1answer
2k views
Avoiding SOQL limits in a recursive method
I have a SOQL query in a recursive FOR loop. It didn't give me SOQL limit issues on my test data, but apparently we have a managed package whose Apex is hitting the limit due to this code.
public ...
4
votes
1answer
3k views
Trigger to update child with parent values
I currently have this trigger which updates the Parent of the record being saved with field values from the GRANDparent of the record being saved :
trigger updateParentwithGrandparent on ...
3
votes
2answers
6k views
Account hierarchy with variable levels of parents
We have a requirement for some account to have variable levels of parent accounts. Currently the salesforce account hierarchy only accommodates 2 levels of parents (grandparent, parent). Is there a ...
5
votes
1answer
392 views
Structuring content inside Knowledge
After a product demo with the Salesforce crew and also some poking around other companies’ help sites I’m coming to the conclusion that it’s difficult to publish content (or Articles) in a hierarchy. ...
