{"id":109,"date":"2008-12-23T12:01:09","date_gmt":"2008-12-23T18:01:09","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2008\/12\/visualizing-relationships\/"},"modified":"2015-10-26T14:36:03","modified_gmt":"2015-10-26T19:36:03","slug":"visualizing-relationships","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/","title":{"rendered":"Visualizing relationships"},"content":{"rendered":"<p>Once you have more than one table in your <a href=\"http:\/\/www.teamdesk.net\/\" target=\"_blank\">TeamDesk<\/a> application, the relationships become its core functionality. They allow you to pull and calculate the information from related tables.<\/p>\n<p>To display the relationships TeamDesk provides two lists. One, accessible from the left side bar displays all relations in your application. And when you select the table and click on Manage Relations link on a main page, the list is filtered to display only the relations from and to selected table.<\/p>\n<p>Good, but what&#8217;s next? We tried to display essential relationship information in its name: table names, a key and reference columns. But there are much more; what are match conditions? which lookups and summaries are created on the relation? which view is used to display the details?<\/p>\n<p><!--more--><\/p>\n<p>This information is not displayed on the list; in order to\u00a0browse you should select the relation and go to relationship information page. Click, click, click&#8230; that is what we want to get rid of.<\/p>\n<p>See the screenshot from TeamDesk Idea Exchange application<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-504\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif\" alt=\"63,1\" width=\"450\" height=\"287\" \/><\/a><\/p>\n<p>Here, we try to display all the information you may need from the relations in a <em>current table<\/em> context.<\/p>\n<p><strong>References<\/strong> section displays the list of master tables (one-side) the selected table (many-side) is connected to as groups. Under the group, lookup columns are listed. The relationship description is now human readable: Ideas table references Categories table via Category field. From there you may edit relation&#8217;s settings (Edit button), delete it (Delete Button) or add new lookup column without going inside.<\/p>\n<p><strong>Selections<\/strong> section displays the list of detail tables (many-side) for the selected table (one-side). Match conditions, detail views and complete information from summary columns are at your fingertips as well.<\/p>\n<p>We found the new list much more convenient than the old one. To see it in action, navigate to Setup, select the table, on the main page click Manage Relation link in the Table section. Then append the string &#8220;&amp;new=&#8221; (without quotes) to the URL, try it and tell us what do you think.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Once you have more than one table in your TeamDesk application, the relationships become its core functionality. They allow you to pull and calculate the information from related tables. To display the relationships TeamDesk provides two lists. One, accessible from the left side bar displays all relations in your application. And when you select the [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[45,36],"class_list":["post-109","post","type-post","status-publish","format-standard","hentry","category-behind-the-scenes","tag-relation","tag-teamdesk"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Visualizing relationships - TeamDesk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visualizing relationships - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"Once you have more than one table in your TeamDesk application, the relationships become its core functionality. They allow you to pull and calculate the information from related tables. To display the relationships TeamDesk provides two lists. One, accessible from the left side bar displays all relations in your application. And when you select the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2008-12-23T18:01:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T19:36:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"Visualizing relationships\",\"datePublished\":\"2008-12-23T18:01:09+00:00\",\"dateModified\":\"2015-10-26T19:36:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/\"},\"wordCount\":337,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2008\\\/12\\\/631.gif\",\"keywords\":[\"relation\",\"TeamDesk\"],\"articleSection\":[\"Behind the Scenes\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/\",\"name\":\"Visualizing relationships - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2008\\\/12\\\/631.gif\",\"datePublished\":\"2008-12-23T18:01:09+00:00\",\"dateModified\":\"2015-10-26T19:36:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2008\\\/12\\\/631.gif\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2008\\\/12\\\/631.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/behind-the-scenes\\\/visualizing-relationships\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualizing relationships\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Visualizing relationships - TeamDesk Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/","og_locale":"en_US","og_type":"article","og_title":"Visualizing relationships - TeamDesk Blog","og_description":"Once you have more than one table in your TeamDesk application, the relationships become its core functionality. They allow you to pull and calculate the information from related tables. To display the relationships TeamDesk provides two lists. One, accessible from the left side bar displays all relations in your application. And when you select the [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/","og_site_name":"TeamDesk Blog","article_published_time":"2008-12-23T18:01:09+00:00","article_modified_time":"2015-10-26T19:36:03+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif","type":"","width":"","height":""}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"Visualizing relationships","datePublished":"2008-12-23T18:01:09+00:00","dateModified":"2015-10-26T19:36:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/"},"wordCount":337,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif","keywords":["relation","TeamDesk"],"articleSection":["Behind the Scenes"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/","url":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/","name":"Visualizing relationships - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif","datePublished":"2008-12-23T18:01:09+00:00","dateModified":"2015-10-26T19:36:03+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2008\/12\/631.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/behind-the-scenes\/visualizing-relationships\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Visualizing relationships"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":1,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":505,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/109\/revisions\/505"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}