{"id":567,"date":"2013-03-18T08:00:47","date_gmt":"2013-03-18T07:00:47","guid":{"rendered":"http:\/\/www.nav.info.pl\/?p=567"},"modified":"2013-03-18T12:44:52","modified_gmt":"2013-03-18T11:44:52","slug":"setautocalcfields-microsoft-dynamics-nav-2013","status":"publish","type":"post","link":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/","title":{"rendered":"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS"},"content":{"rendered":"

W Microsoft Dynamics NAV 2013 mamy do dyspozycji now\u0105 funkcj\u0119- SETAUTOCALCFIELDS, kt\u00f3rej umiej\u0119tne wykorzystanie mo\u017ce przyczyni\u0107 si\u0119 do poprawy wydajno\u015bci projektowanych rozwi\u0105za\u0144.<\/p>\n

\"SETAUTOCALFILEDS<\/a><\/p>\n

Wspomniana funkcja pozwala na automatyczne wyliczanie warto\u015bci p\u00f3l typu FlowField podczas pobierania ich z bazy danych, b\u0119d\u0105c swoist\u0105 alternatyw\u0105 dla funkcji CALCFIELDS. Aby funkcja SETAUTOCALCFIELDS zadzia\u0142a\u0142a prawid\u0142owo nale\u017cy u\u017cy\u0107 jej przed rozpocz\u0119ciem przegl\u0105dania tabeli tak jak zaprezentowano to w poni\u017cszym przyk\u0142adzie:<\/p>\n


GeSHi Error:<\/strong> GeSHi could not find the language cside (using path \/home\/babaczyk\/public_html\/d365bc.info.pl\/wp-content\/plugins\/codecolorer\/lib\/geshi\/) (code 2)
<\/div>\n

Zamiast ka\u017cdorazowego u\u017cywania jak funkcji CALCFIELDS:<\/p>\n


GeSHi Error:<\/strong> GeSHi could not find the language cside (using path \/home\/babaczyk\/public_html\/d365bc.info.pl\/wp-content\/plugins\/codecolorer\/lib\/geshi\/) (code 2)
<\/div>\n

Jaki zatem rezultat daje u\u017cycie funkcji SETAUTOCALCFIELDS w Microsoft Dynamics NAV 2013? Jest to zwyczajne z\u0142\u0105czenie dw\u00f3ch tabel, kt\u00f3re zaprezentowa\u0142em poni\u017cej:<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
<\/div><\/td>
SELECT<\/span>
\nISNULL(<\/span>"Item"<\/span>.<\/span>"timestamp"<\/span>,<\/span>@0)<\/span> AS<\/span> "timestamp"<\/span>,<\/span>
\nISNULL(<\/span>"Item"<\/span>.<\/span>"No_"<\/span>,<\/span>@1)<\/span> AS<\/span> "No_"<\/span>,<\/span>
\n...<\/span>
\nISNULL(<\/span>"SUB$Inventory"<\/span>.<\/span>"Inventory$Item Ledger Entry$SUM$Quantity"<\/span>,<\/span>@120)<\/span> AS<\/span> "Inventory"<\/span>
\nFROM<\/span> "Cronus 2013"<\/span>.<\/span>"dbo"<\/span>.<\/span>"CRONUS International Ltd_$Item"<\/span> AS<\/span> "Item"<\/span>
\nWITH<\/span>(<\/span>READUNCOMMITTED)<\/span> OUTER<\/span> APPLY (<\/span>
\nSELECT<\/span> TOP (<\/span>1<\/span>)<\/span> ISNULL(<\/span>SUM<\/span>(<\/span>"Inventory$Item Ledger Entry"<\/span>.<\/span>"Quantity"<\/span>)<\/span>,<\/span>@119)<\/span> AS<\/span> "Inventory$Item Ledger Entry$SUM$Quantity"<\/span>
\nFROM<\/span> "Cronus 2013"<\/span>.<\/span>"dbo"<\/span>.<\/span>"CRONUS International Ltd_$Item Ledger Entry"<\/span> AS<\/span> "Inventory$Item Ledger Entry"<\/span>
\nWITH<\/span>(<\/span>READUNCOMMITTED)<\/span>
\nWHERE<\/span> (<\/span>"Inventory$Item Ledger Entry"<\/span>.<\/span>"Item No_"<\/span>=<\/span>"Item"<\/span>.<\/span>"No_"<\/span>)<\/span>)<\/span> AS<\/span> "SUB$Inventory"<\/span>
\nORDER<\/span> BY<\/span> "No_"<\/span> ASC<\/span> OPTION<\/span>(<\/span>OPTIMIZE<\/span> FOR<\/span> UNKNOWN<\/span>,<\/span> FAST 50<\/span>
\n)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Co w tym niezwyk\u0142ego? Ot\u00f3\u017c to, \u017ce w przeciwie\u0144stwie do tego, czego nas uczono od kilku lat o Dynamics NAV i T-SQL, funkcja SETAUTOCALCFIELDS nie korzysta z widok\u00f3w SIFT. Mimo to przyczynia si\u0119 ona do znacznej poprawy wydajno\u015bci.<\/p>\n

Kolejn\u0105 wa\u017cn\u0105 spraw\u0105 dotycz\u0105c\u0105 SETAUTOCALFIELDS jest umiej\u0119tno\u015b\u0107 poprawnego jej resetowania – podobnie do filtr\u00f3w SETRANGE, aby wy\u0142\u0105czy\u0107 jej dzia\u0142anie nale\u017cy wywo\u0142a\u0107 j\u0105 bez parametr\u00f3w (SETAUTOCALCFIELDS()).<\/p>\n

Znaj\u0105c te dwie zasady na pewno bez problemu poradzicie sobie z poprawnym korzystaniem z tej nowo\u015bci tworz\u0105c nowe modu\u0142y w Microsoft Dynamics NAV 2013.<\/p>\n","protected":false},"excerpt":{"rendered":"

W Microsoft Dynamics NAV 2013 mamy do dyspozycji now\u0105 funkcj\u0119- SETAUTOCALCFIELDS, kt\u00f3rej umiej\u0119tne wykorzystanie mo\u017ce przyczyni\u0107 si\u0119 do poprawy wydajno\u015bci projektowanych rozwi\u0105za\u0144.<\/p>\n","protected":false},"author":1,"featured_media":588,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false,"jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[17,13,15,14],"tags":[77,20,125,76,124],"jetpack_publicize_connections":[],"yoast_head":"\nMicrosoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central<\/title>\n<meta name=\"description\" content=\"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:locale:alternate\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central\" \/>\n<meta property=\"og:description\" content=\"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji\" \/>\n<meta property=\"og:url\" content=\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog o Microsoft Dynamics 365 Business Central\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-18T07:00:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-03-18T11:44:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"957\" \/>\n\t<meta property=\"og:image:height\" content=\"492\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"rafal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rbabaczyk\" \/>\n<meta name=\"twitter:site\" content=\"@rbabaczyk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rafal\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/\",\"url\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/\",\"name\":\"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central\",\"isPartOf\":{\"@id\":\"https:\/\/d365bc.info.pl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1\",\"datePublished\":\"2013-03-18T07:00:47+00:00\",\"dateModified\":\"2013-03-18T11:44:52+00:00\",\"author\":{\"@id\":\"https:\/\/d365bc.info.pl\/#\/schema\/person\/f5cb8e045a4a97815cd6e40491adefad\"},\"description\":\"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji\",\"breadcrumb\":{\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1\",\"width\":\"957\",\"height\":\"492\",\"caption\":\"SETAUTOCALFILEDS - Microsoft Dynamics NAV 2013\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/d365bc.info.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/d365bc.info.pl\/#website\",\"url\":\"https:\/\/d365bc.info.pl\/\",\"name\":\"Blog o Microsoft Dynamics 365 Business Central\",\"description\":\"Polski blog o Microsoft Dynamics 365 Business Central (dawniej Dynamics NAV)\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/d365bc.info.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/d365bc.info.pl\/#\/schema\/person\/f5cb8e045a4a97815cd6e40491adefad\",\"name\":\"rafal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/d365bc.info.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/76728b0891ff455b2cb63205ba51106e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/76728b0891ff455b2cb63205ba51106e?s=96&d=mm&r=g\",\"caption\":\"rafal\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central","description":"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji","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:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central","og_description":"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji","og_url":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/","og_site_name":"Blog o Microsoft Dynamics 365 Business Central","article_published_time":"2013-03-18T07:00:47+00:00","article_modified_time":"2013-03-18T11:44:52+00:00","og_image":[{"width":"957","height":"492","url":"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1","type":"image\/png"}],"author":"rafal","twitter_card":"summary_large_image","twitter_creator":"@rbabaczyk","twitter_site":"@rbabaczyk","twitter_misc":{"Written by":"rafal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/","url":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/","name":"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS - Blog o Microsoft Dynamics 365 Business Central","isPartOf":{"@id":"https:\/\/d365bc.info.pl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage"},"image":{"@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1","datePublished":"2013-03-18T07:00:47+00:00","dateModified":"2013-03-18T11:44:52+00:00","author":{"@id":"https:\/\/d365bc.info.pl\/#\/schema\/person\/f5cb8e045a4a97815cd6e40491adefad"},"description":"Odpowiednie u\u017cycie nowej funkcji SETAUTOCALCFIELDS, dost\u0119pnej w Microsoft Dynamics NAV 2013, zamist znanego CALCFIELDS poprawi znacznie wydajno\u015b\u0107 aplikacji","breadcrumb":{"@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#primaryimage","url":"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1","contentUrl":"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1","width":"957","height":"492","caption":"SETAUTOCALFILEDS - Microsoft Dynamics NAV 2013"},{"@type":"BreadcrumbList","@id":"https:\/\/d365bc.info.pl\/en\/setautocalcfields-microsoft-dynamics-nav-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/d365bc.info.pl\/"},{"@type":"ListItem","position":2,"name":"Microsoft Dynamics NAV 2013 i SETAUTOCALCFIELDS"}]},{"@type":"WebSite","@id":"https:\/\/d365bc.info.pl\/#website","url":"https:\/\/d365bc.info.pl\/","name":"Blog o Microsoft Dynamics 365 Business Central","description":"Polski blog o Microsoft Dynamics 365 Business Central (dawniej Dynamics NAV)","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/d365bc.info.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/d365bc.info.pl\/#\/schema\/person\/f5cb8e045a4a97815cd6e40491adefad","name":"rafal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/d365bc.info.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/76728b0891ff455b2cb63205ba51106e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/76728b0891ff455b2cb63205ba51106e?s=96&d=mm&r=g","caption":"rafal"}}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/d365bc.info.pl\/wp-content\/uploads\/2013\/03\/SETAUTOCALFILEDS.png?fit=957%2C492&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3iarJ-99","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/posts\/567"}],"collection":[{"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/comments?post=567"}],"version-history":[{"count":29,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"predecessor-version":[{"id":589,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/posts\/567\/revisions\/589"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/media\/588"}],"wp:attachment":[{"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/d365bc.info.pl\/en\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}