{"id":1947,"date":"2022-07-08T15:15:47","date_gmt":"2022-07-08T15:15:47","guid":{"rendered":"https:\/\/logicbuilder.integroscrm.com\/help\/?page_id=1947"},"modified":"2022-07-08T15:25:45","modified_gmt":"2022-07-08T15:25:45","slug":"lb-search-and-dates","status":"publish","type":"page","link":"https:\/\/logicbuilder.integroscrm.com\/help\/lb-search-and-dates\/","title":{"rendered":"LB Search &#038; Dates"},"content":{"rendered":"\n<p><span style=\"font-size:17px;\">Release date: 2021-01-23<\/span><\/p>\n\n\n\n<p><span style=\"font-size:17px\"><b>Filtering flowcharts<\/b><\/span><\/p>\n\n\n\n<p>With a new <strong><span style=\"color:#ec8f45;\">Flowchart Filtering<\/span><\/strong> feature, you can search for flowcharts by field and module names used in them. This filtering feature is available right on <strong><span style=\"color:#ec8f45;\">Load Flowchart<\/span><\/strong> dialog box. The following pictures demonstrate the process of searching for flowcharts related to Accounts module:<\/p>\n\n\n<p><a href=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-1.png\" rel=\"prettyPhoto\"><img decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-1.png\" alt=\"\" class=\"wp-image-378\"><\/a><\/p>\n\n\n<p>You can narrow down the list to find only those flowcharts that mention a specific field of the module. The following pictures demonstrate the process of searching for flowcharts related to Priority field of Tasks module:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-2.png\" alt=\"\" class=\"wp-image-1950\" width=\"709\" height=\"458\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-2.png 750w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-2-300x194.png 300w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure>\n\n\n\n<p><span style=\"font-size:17px\"><b>Locating operators in flowcharts<\/b><\/span><\/p>\n\n\n\n<p><strong><span style=\"color:#ec8f45;\">Find Operator<\/span><\/strong> feature allows easily locating specific operators on large flowcharts. <strong><span style=\"color:#ec8f45;\">Find Operator<\/span><\/strong> dialog box displays all operators from the currently loaded (or created) flowchart. You can narrow down the list of operators by typing any part of the operator name in <strong><span style=\"color:#ec8f45;\">Search<\/span><\/strong> field. When you click any operator in the list, it is displayed in the center of the drawing area.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"565\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-3.png\" alt=\"\" class=\"wp-image-1951\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-3.png 315w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-3-167x300.png 167w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/figure>\n\n\n\n<p>The old way of locating operators with the help of the mini-map is still available. You can type the name of the operator in <strong><span style=\"color:#ec8f45;\">Highlight<\/span><\/strong> field of <strong><span style=\"color:#ec8f45;\">Mini-map<\/span><\/strong> dialog box and it will highlight the correspondent operators. Click on any point of the mini-map in order to display it in the center of the drawing area.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"390\" height=\"432\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-4.png\" alt=\"\" class=\"wp-image-1952\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-4.png 390w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-4-271x300.png 271w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/figure>\n\n\n\n<p><span style=\"font-size:17px\"><b>New operators for working with dates<\/b><\/span><\/p>\n\n\n\n<p>A number of new operators added to enhance the way you can work with dates in your flowcharts.<\/p>\n\n\n\n<p><strong><span style=\"color:#ec8f45;\">Get Date from String<\/span><\/strong> operator is intended for converting strings to dates. Feed <strong><span style=\"color:#ec8f45;\">String<\/span><\/strong> and <strong><span style=\"color:#ec8f45;\">Format<\/span><\/strong> ports of the operator with the string representing some date and its format respectively. You can find the allowed date formats <a href=\"https:\/\/www.php.net\/manual\/en\/datetime.format.php\">here<\/a>. If you want a resulting date to be converted according to the current Sugar user\u2019s time zone settings, then select Yes in <strong><span style=\"color:#ec8f45;\">Is In User\u2019s Timezone<\/span><\/strong> port.<\/p>\n\n\n\n<p>The following picture shows the example of converting a string representing UNIX timestamp to a date:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-5.png\" alt=\"\" class=\"wp-image-1953\" width=\"856\" height=\"588\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-5.png 977w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-5-300x206.png 300w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-5-768x527.png 768w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<p>In order to convert a date back to a string, you can use <strong><span style=\"color:#ec8f45;\">Get String From Date<\/span><\/strong> operator. <strong><span style=\"color:#ec8f45;\">Format<\/span><\/strong> port defines the resulting string format. Allowed formats are the same that are used for <strong><span style=\"color:#ec8f45;\">Get Date from String<\/span><\/strong> operator.<\/p>\n\n\n\n<p>&nbsp;The following picture shows the example of converting a date to a string using d\/m\/Y format:<\/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\/lb-search-and-dates-6-1024x246.png\" alt=\"\" class=\"wp-image-1954\" width=\"844\" height=\"203\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-6-1024x246.png 1024w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-6-300x72.png 300w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-6-768x185.png 768w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-6.png 1135w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/><\/figure>\n\n\n\n<p>The following are the examples of some commonly used date formats:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Y-m-d H:i:s (2020-12-17 10:24:59)<\/li><li>U &#8211; Seconds since the Unix Epoch (e.g. 1608222665)<\/li><li>c &#8211; ISO 8601 date (e.g. 2004-02-12T15:19:21+00:00)<\/li><\/ul>\n\n\n\n<p><strong><span style=\"color:red\">Important notice: <\/span><\/strong>If you use Date Type fields to compose API requests (using <strong><span style=\"color:#ec8f45;\">Rest Client<\/span><\/strong> operator), then you\u2019ll need to use <strong><span style=\"color:#ec8f45;\">Get String From Date<\/span><\/strong> operator there in order to format dates properly.<\/p>\n\n\n\n<p><span style=\"font-size:17px\"><b>Checking values for emptiness<\/b><\/span><\/p>\n\n\n\n<p><strong><span style=\"color:#ec8f45;\">Is Empty<\/span><\/strong> operator is useful when you need to check if any particular value is empty. The result of this operator will be True if a value-under-test is either NULL or empty string. The following picture shows the example of using <strong><span style=\"color:#ec8f45;\">Is Empty<\/span><\/strong> operator.<\/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\/lb-search-and-dates-7-1024x293.png\" alt=\"\" class=\"wp-image-1955\" width=\"846\" height=\"242\" srcset=\"https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-7-1024x293.png 1024w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-7-300x86.png 300w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-7-768x220.png 768w, https:\/\/logicbuilder.integroscrm.com\/help\/wp-content\/uploads\/2022\/07\/lb-search-and-dates-7.png 1205w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/figure>\n\n\n\n<p><span style=\"font-size:17px\"><b>New ready-made metadata<\/b><\/span><\/p>\n\n\n\n<p>A bunch of new ready-made metadata packages added to Logic Builder. Now you can create new projects based on the following presets:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Sugar 10.0.2 Pro<\/li><li>Sugar 10.0.3 Ent<\/li><li>Sugar Sell &amp; Serve 10.2<\/li><\/ul>\n<div style=\"text-align:left\" class=\"yasr-auto-insert-visitor\"><!--Yasr Visitor Votes Shortcode--><div id='yasr_visitor_votes_1947' class='yasr-visitor-votes'><div class=\"yasr-custom-text-vv-before yasr-custom-text-vv-before-1947\">Click to rate this post!<\/div><div id='yasr-vv-second-row-container-065ed9fa651a0' \n                                        class='yasr-vv-second-row-container'><div id='yasr-visitor-votes-rater-065ed9fa651a0'\n                                      class='yasr-rater-stars-vv'\n                                      data-rater-postid='1947' \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-065ed9fa651a0\"><svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" width=\"20\" height=\"20\" \n                               class=\"yasr-dashicons-visitor-stats\"\n                               data-postid=\"1947\" \n                               id=\"yasr-stats-dashicon-065ed9fa651a0\">\n                            <path d=\"M18 18v-16h-4v16h4zM12 18v-11h-4v11h4zM6 18v-8h-4v8h4z\"><\/path>\n                          <\/svg><span id=\"yasr-vv-text-container-065ed9fa651a0\" class=\"yasr-vv-text-container\">[Total: <span id=\"yasr-vv-votes-number-container-065ed9fa651a0\">0<\/span>  Average: <span id=\"yasr-vv-average-container-065ed9fa651a0\">0<\/span>]<\/span><\/div><div id='yasr-vv-loader-065ed9fa651a0' class='yasr-vv-container-loader'><\/div><\/div><div id='yasr-vv-bottom-container-065ed9fa651a0' class='yasr-vv-bottom-container'><\/div><\/div><!--End Yasr Visitor Votes Shortcode--><\/div>","protected":false},"excerpt":{"rendered":"<p>Release date: 2021-01-23 Filtering flowcharts With a new Flowchart Filtering feature, you can search for flowcharts by field and module names used in them. This filtering feature is available right on Load Flowchart dialog box. The following pictures demonstrate the process of searching for flowcharts related to Accounts module: You can narrow down the list &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/logicbuilder.integroscrm.com\/help\/lb-search-and-dates\/\"> <span class=\"screen-reader-text\">LB Search &#038; Dates<\/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-1947","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\/1947","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=1947"}],"version-history":[{"count":4,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages\/1947\/revisions"}],"predecessor-version":[{"id":1966,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/pages\/1947\/revisions\/1966"}],"wp:attachment":[{"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/media?parent=1947"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/logicbuilder.integroscrm.com\/help\/wp-json\/wp\/v2\/tags?post=1947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}