{"id":21968,"date":"2025-01-21T23:48:50","date_gmt":"2025-01-22T05:48:50","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=21968"},"modified":"2025-01-21T23:48:52","modified_gmt":"2025-01-22T05:48:52","slug":"managing-self-joins-with-multiple-context-in-neo4j","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/managing-self-joins-with-multiple-context-in-neo4j\/","title":{"rendered":"Managing Self Joins with Multiple Context in Neo4J"},"content":{"rendered":"\n

Example of Cypher Query using Relationship <\/strong> design pattern.<\/h3>\n\n\n\n

Query:<\/h4>\n\n\n\n
MATCH (manager:Employee)<-[rel:PRIMARY_REPORTS_TO|DOTTED_REPORTS_TO]-(e:Employee)\nWHERE manager.name = \"Alice\"\nRETURN e.name AS employee, \n       type(rel) AS relationship_type, \n       rel.role AS role, \n       rel.start_date, \n       rel.end_date;\n<\/code><\/pre>\n\n\n\n
Sample Graph Data:<\/h4>\n\n\n\n
Assume we have the following graph:<\/p>\n\n\n\n
  1. Bob<\/code> reports to Alice<\/code> as the primary manager<\/strong>.<\/li>
  2. Charlie<\/code> reports to Alice<\/code> as a dotted-line report<\/strong> for a project.<\/li>
  3. Diana<\/code> reports to Alice<\/code> as a dotted-line report<\/strong> for mentorship.<\/li><\/ol>\n\n\n\n
    Query Results:<\/h4>\n\n\n\n
    employee<\/th>relationship_type<\/th>role<\/th>start_date<\/th>end_date<\/th><\/tr><\/thead>
    Bob<\/td>PRIMARY_REPORTS_TO<\/td>NULL<\/td>2023-01-01<\/td>NULL<\/td><\/tr>
    Charlie<\/td>DOTTED_REPORTS_TO<\/td>Project Lead<\/td>2023-02-01<\/td>2024-01-31<\/td><\/tr>
    Diana<\/td>DOTTED_REPORTS_TO<\/td>Mentor<\/td>2023-03-15<\/td>2023-12-31<\/td><\/tr><\/tbody><\/table>\n\n\n\n
    \n\n\n\n
    type(rel) AS relationship_type<\/code><\/strong><\/h3>\n\n\n\n
    1. \nPurpose of type(rel)<\/code><\/strong>:\n
      • type(rel)<\/code> retrieves the name of the relationship type for each match.<\/li>
      • In this query, it can return either:\n
        • PRIMARY_REPORTS_TO<\/code><\/li>
        • DOTTED_REPORTS_TO<\/code><\/li><\/ul>\n<\/li>
        • This is useful when multiple types of relationships are being matched in the same query.<\/li><\/ul>\n<\/li>
        • \nHow It Works in the Query<\/strong>:\n
          • The query matches any rel<\/code> of type PRIMARY_REPORTS_TO<\/code> or DOTTED_REPORTS_TO<\/code> between Alice<\/code> (the manager) and her employees.<\/li>
          • The type(rel)<\/code> function determines whether the relationship is a primary or dotted-line report.<\/li><\/ul>\n<\/li>
          • \nPractical Use<\/strong>:\n
            • It allows you to differentiate between primary and dotted-line reports in the result set.<\/li>
            • For instance, in the results above:\n
              • Bob\u2019s relationship is labeled as PRIMARY_REPORTS_TO<\/code>.<\/li>
              • Charlie and Diana\u2019s relationships are labeled as DOTTED_REPORTS_TO<\/code>.<\/li><\/ul>\n<\/li><\/ul>\n<\/li>
              • \nHandling NULL Values<\/strong>:\n
                • In relationships like PRIMARY_REPORTS_TO<\/code>, there may not be a role<\/code> property (e.g., Bob has no role<\/code> in his primary reporting line). This is reflected as NULL<\/code> in the role<\/code> column of the results.<\/li><\/ul>\n<\/li><\/ol>\n\n\n\n
                  \n\n\n\n
                  Why This Query is Powerful<\/strong><\/h3>\n\n\n\n
                  1.  Insight Across Multiple Reporting Lines<\/strong>: 
                    • Combines both primary and dotted-line reporting relationships into a single result set.<\/li>
                    • Useful for identifying all employees managed by a specific manager, regardless of the type of reporting. <\/li><\/ul><\/li>
                    •  Dynamic Role Attribution<\/strong>: 
                      • The rel.role<\/code> property allows capturing contextual information about the dotted-line relationships (e.g., “Project Lead” or “Mentor”). <\/li><\/ul><\/li>
                      •  Time-Bounded Relationships<\/strong>: 
                        • The start_date<\/code> and end_date<\/code> fields allow filtering based on active reporting periods. For example, you could modify the query to find employees who are currently reporting to Alice<\/strong>: MATCH (manager:Employee)<-[rel:PRIMARY_REPORTS_TO|DOTTED_REPORTS_TO]-(e:Employee) WHERE manager.name = \"Alice\" AND (rel.end_date IS NULL OR date(rel.end_date) >= date()) RETURN e.name AS employee, type(rel) AS relationship_type, rel.role, rel.start_date, rel.end_date; <\/code>  <\/li><\/ul><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"
                          Example of Cypher Query using Relationship design pattern. Query: Sample Graph Data: Assume we have the following graph: Bob reports to Alice as the primary manager. Charlie reports to Alice as a dotted-line report for a project. Diana reports to Alice as a dotted-line report for mentorship. Query Results: employee relationship_type role start_date end_date Bob […]<\/p>\n","protected":false},"author":2,"featured_media":21496,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[],"class_list":["post-21968","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-dashboards-analytics"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2024\/12\/neo4j_logo-facebook-3405355569.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/21968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=21968"}],"version-history":[{"count":4,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/21968\/revisions"}],"predecessor-version":[{"id":21972,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/21968\/revisions\/21972"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/21496"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=21968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=21968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=21968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}