{"id":1844,"date":"2022-07-06T14:32:28","date_gmt":"2022-07-06T14:32:28","guid":{"rendered":"https:\/\/logicbuilder.integroscrm.com\/help\/?page_id=1844"},"modified":"2022-07-14T09:27:24","modified_gmt":"2022-07-14T09:27:24","slug":"teams","status":"publish","type":"page","link":"https:\/\/logicbuilder.integroscrm.com\/help\/teams\/","title":{"rendered":"Teams"},"content":{"rendered":"\n<p><span style=\"font-size:17px;\">Release date: 2022-02-19<\/span><\/p>\n\n\n\n<p><span style=\"font-size:22px\"><b>New operators for manipulating teams for Records<\/b><\/span><\/p>\n\n\n\n<p>There are a bunch of new operators that allow you to read, add or remove teams for records.<\/p>\n\n\n\n<p><b>Get Entity Teams&nbsp;<\/b><\/p>\n\n\n\n<p>Now you can get all Teams that are assigned to the record with an operator <strong><span style=\"color:#ec8f45;\">Get Entity Teams<\/span><\/strong>. Useful to check whether there is a particular Team set for the record.<\/p>\n\n\n\n<p>Just provide <em><span style=\"color:#AC0723;\">entity<\/span><\/em> and as output there is an <span style=\"color:#6888c9;\">Array<\/span> of all Teams assigned to the record:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-4.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-4-1024x233.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p>Several notes that apply to the following operators of Teams manipulating:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>In Sugar each teamset for record consists of two components: team_id as Primary Team and team_set_id as all other teams. New operators work with team_set_id only. See chapter <a href=\"#manipulating\">Manipulating Primary Team<\/a> to find out how to work with team_id aka Primary Team.&nbsp;<\/li><li>The recommended approach is to use new operators on After Save flowcharts than on Before Save.<\/li><li>Do not use <strong><span style=\"color:#ec8f45;\">Save Entity<\/span><\/strong> to preserve team changes. Each of the new operators applies team changes itself.<\/li><li>Despite any changes that might be applied with new operators, the standard Sugar logic, which ensures access of Assigned User to a record, works. Let\u2019s say that you created flowcharts and because of its execution a teamset for the record do not contain any Team, to which an Assigned user belongs. In this case, standard Sugar behavior adds Assigned Users\u2019 Private Team.<\/li><\/ol>\n\n\n\n<p><b>Add Teams<\/b><\/p>\n\n\n\n<p>It does what it says \u2013 adds Team or several Teams to the record.<\/p>\n\n\n\n<p>To add one Team simply provide an ID of a Team to add an <em><span style=\"color:#AC0723;\">entity<\/span><\/em> for which Team(s) must be added:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-5.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-5-1024x359.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><em>As a result of the flowchart execution team West is added to the set of teams of Account Record.<\/em><\/p>\n\n\n\n<p>To add several Teams, provide an <span style=\"color:#6888c9;\">Array<\/span> of Team IDs or <span style=\"color:#6888c9;\">Collection<\/span> of Team IDs add and entity for which Team(s) must be added:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-6.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-6-1024x328.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><em>As a result of the flowchart execution two teams West and Poland are added to the set of teams of Account Record.<\/em><\/p>\n\n\n<p><a name=\"remove\"><\/a><\/p>\n\n\n<p><b>Remove Teams<\/b><\/p>\n\n\n\n<p>Conversely to the operator <strong><span style=\"color:#ec8f45;\">Add Teams<\/span><\/strong>, this operator removes Team or Teams from the record.<\/p>\n\n\n\n<p>It works in the same way as <strong><span style=\"color:#ec8f45;\">Add Teams<\/span><\/strong> \u2013 it expects <em><span style=\"color:#AC0723;\">entity<\/span><\/em> from which Teams should be removed and <span style=\"color:#6888c9;\">Collection<\/span>, <span style=\"color:#6888c9;\">Array<\/span>, or one Team ID to be removed:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-7.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-7-1024x430.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><b>Set Entity Teams<\/b><\/p>\n\n\n\n<p>Completely overrides team_set_id with the teams provided in the input. In the same way as the previous two operators, this one expects an <em><span style=\"color:#AC0723;\">entity<\/span><\/em> where Teams must be changed and <span style=\"color:#6888c9;\">Array<\/span>, <span style=\"color:#6888c9;\">Collection<\/span>, or one team ID that must be set as team_set_id.<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-8.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-8-1024x292.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n<p><a name=\"manipulating\"><\/a><\/p>\n\n\n<p><b>Manipulating Primary Team<\/b><\/p>\n\n\n\n<p>As mentioned above, new operators of Teams manipulation work only with team_set_id. However, sometimes you will have to consider Primary Team (or team_id) in your flowcharts as well.<\/p>\n\n\n\n<p>You can work with a Primary Team as with the usual field in Logic Builder using <strong><span style=\"color:#ec8f45;\">Get<\/span><\/strong>\/<strong><span style=\"color:#ec8f45;\">Set Entity Attributes<\/span><\/strong> on <u>Before Save<\/u>.<\/p>\n\n\n\n<p>For example, when it is needed to remove a Team based on conditions and you do not know where this Team was set \u2013 as Primary or not, this challenge could be addressed with two flowcharts:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>first one on Before Save ensuring that Team will be removed from the Primary. Please note that the Primary Team must be always set:<\/li><\/ul>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-9.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-9-1024x324.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<ul class=\"wp-block-list\"><li>and the second flowchart on After Save to remove Team for the case when this Team is not Primary (see section <a href=\"#remove\">Remove Teams<\/a>).<\/li><\/ul>\n\n\n\n<p><b>I need to update an entity and change teams; how should I do this?<\/b><\/p>\n\n\n\n<p>In one After Save flowchart.<\/p>\n\n\n\n<p>If you add (or remove) Teams and then update the record, any other flowchart that works on team change (for example, if you have implemented logic of teams inheriting from Account to related records) will be triggered.<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-10.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-10-1024x253.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p>Otherwise \u2013 firstly, update the record, then update the Team \u2013 other flowcharts that work on team change won\u2019t be triggered.<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-11.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-11-1024x239.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><span style=\"font-size:22px\"><b>Flowchart unique name in Audit Log<\/b><\/span><\/p>\n\n\n\n<p>Whenever a flowchart changes a field, which is being audited, the flowchart name is displayed in the Audit Log:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-1.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-1-1024x349.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><span style=\"font-size:22px\"><b>New operators to ease connection via API<\/b><\/span><\/p>\n\n\n\n<p>If you build an integration between Sugar and the 3d party system and provide parameters via URL, you can encode parameters with one operator <strong><span style=\"color:#ec8f45;\">Encode URL Component<\/span><\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-2-1024x267.png\" alt=\"\" class=\"wp-image-1852\" width=\"650\" height=\"169\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-2-1024x267.png 1024w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-2-300x78.png 300w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-2-768x200.png 768w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-2.png 1263w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p><strong><span style=\"color:#ec8f45;\">Encode URL Component<\/span><\/strong> converts reserved or non-ASCII characters passed in input into accepted ones by servers.<\/p>\n\n\n\n<p>For example, \u201cJohn Smith\u201d is converted to \u201cJohn %20Smith\u201d<\/p>\n\n\n\n<p>Example of usage where Account Name (which may contain spaces) is encoded prior to being put as a parameter into URL:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-3.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-3-1024x441.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><span style=\"font-size:22px\"><b>New operator to perform Direct SQL Requests to the Database<\/b><\/span><\/p>\n\n\n\n<p>Now you can write your own SQL queries with operator <strong><span style=\"color:#ec8f45;\">Query<\/span><\/strong>.<\/p>\n\n\n\n<p>To use it input SQL request directly in the operator. Use the symbol \u201c?\u201d for parameters in your query and input parameters values in the operator. Symbols \u201c?\u201d are filled with provided values in order they are inputted. As a result there is:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Array of arrays of returned records for <em>select<\/em> queries<\/li><li>1 (true) or 0\/empty (false) for updates\/inserts<\/li><li>Error text in case of issues with query<\/li><\/ul>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-12.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/work-with-teams-12-1024x285.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p><span style=\"font-size:22px\"><b>Fixed Issues:<\/b><\/span><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Fixed unexpected results of comparison operators when there is a comparison with 0.<\/li><li>Added spaces trim in <strong><span style=\"color:#ec8f45;\">Get<\/span><\/strong>\/<strong><span style=\"color:#ec8f45;\">Set Array Element<\/span><\/strong>, <strong><span style=\"color:#ec8f45;\">Get<\/span><\/strong>\/<strong><span style=\"color:#ec8f45;\">Set Array Elements by Path<\/span><\/strong>.<\/li><li>Fixed error when the latest deployed Service was called instead of the enabled one. <p>Please update <strong>LB Services Extension<\/strong> and <strong>LB SugarBPM Extension<\/strong> to resolve this issue. Also, flowcharts On Service Call should be re-generated and re-deployed on the instance if you encounter this error.<\/p><\/li><\/ol>\n<div style=\"text-align:left\" class=\"yasr-auto-insert-visitor\"><!--Yasr Visitor Votes Shortcode--><div id='yasr_visitor_votes_1844' class='yasr-visitor-votes'><div class=\"yasr-custom-text-vv-before yasr-custom-text-vv-before-1844\">Click to rate this post!<\/div><div id='yasr-vv-second-row-container-deaea70ec65e9' \n                                        class='yasr-vv-second-row-container'><div id='yasr-visitor-votes-rater-deaea70ec65e9'\n                                      class='yasr-rater-stars-vv'\n                                      data-rater-postid='1844' \n                                      data-rating='0'\n                                      data-rater-starsize='24'\n                                      data-rater-readonly='false'\n                                      data-rater-nonce='fa81b01ba5' \n                                      data-issingular='false'\n                                    ><\/div><div class=\"yasr-vv-stats-text-container\" id=\"yasr-vv-stats-text-container-deaea70ec65e9\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" width=\"20\" height=\"20\" \n                               class=\"yasr-dashicons-visitor-stats\"\n                               data-postid=\"1844\" \n                               id=\"yasr-stats-dashicon-deaea70ec65e9\">\n                            <path d=\"M18 18v-16h-4v16h4zM12 18v-11h-4v11h4zM6 18v-8h-4v8h4z\"><\/path>\n                          <\/svg><span id=\"yasr-vv-text-container-deaea70ec65e9\" class=\"yasr-vv-text-container\">[Total: <span id=\"yasr-vv-votes-number-container-deaea70ec65e9\">0<\/span>  Average: <span id=\"yasr-vv-average-container-deaea70ec65e9\">0<\/span>]<\/span><\/div><div id='yasr-vv-loader-deaea70ec65e9' class='yasr-vv-container-loader'><\/div><\/div><div id='yasr-vv-bottom-container-deaea70ec65e9' class='yasr-vv-bottom-container'><\/div><\/div><!--End Yasr Visitor Votes Shortcode--><\/div>","protected":false},"excerpt":{"rendered":"<p>Release date: 2022-02-19 New operators for manipulating teams for Records There are a bunch of new operators that allow you to read, add or remove teams for records. Get Entity Teams&nbsp; Now you can get all Teams that are assigned to the record with an operator Get Entity Teams. Useful to check whether there is &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/logicbuilder.integroscrm.com\/help\/teams\/\"> <span class=\"screen-reader-text\">Teams<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":"","footnotes":""},"tags":[],"class_list":["post-1844","page","type-page","status-publish","hentry"],"yasr_visitor_votes":{"number_of_votes":0,"sum_votes":0,"stars_attributes":{"read_only":false,"span_bottom":false}},"_links":{"self":[{"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages\/1844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/comments?post=1844"}],"version-history":[{"count":21,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages\/1844\/revisions"}],"predecessor-version":[{"id":1977,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages\/1844\/revisions\/1977"}],"wp:attachment":[{"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/media?parent=1844"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/tags?post=1844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}