{"id":2536442,"date":"2024-11-12T22:00:35","date_gmt":"2024-11-13T06:00:35","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2536442"},"modified":"2024-11-12T23:56:54","modified_gmt":"2024-11-13T07:56:54","slug":"the-new-sql-field-calculate-experience","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience","title":{"rendered":"The New SQL Field Calculate Experience"},"author":319692,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851],"tags":[766432,33371,216532,776962],"industry":[],"product":[36551],"class_list":["post-2536442","blog","type-blog","status-publish","format-standard","hentry","category-data-management","tag-calculate-field","tag-map-viewer","tag-sql","tag-whats-new-november-2024","product-arcgis-online"],"acf":{"authors":[{"ID":319692,"user_firstname":"Taylor","user_lastname":"McNeil","nickname":"Taylor McNeil","user_nicename":"tmcneil","display_name":"Taylor McNeil","user_email":"tmcneil@esri.com","user_url":"","user_registered":"2022-10-06 12:43:53","user_description":"Taylor is a Product Engineer on the ArcGIS Online team based in Nova Scotia, Canada. She has received a BSc in Biology and a MSc in Applied Geomatics. When she's not at work, she can be found taking care of her houseplants, reading copious amounts of fiction, and exploring local thrift stores.","user_avatar":""}],"short_description":"A new way to calculate field values using SQL is now available in Map Viewer. ","flexible_content":[{"acf_fc_layout":"content","content":"

In the June 2024 update we introduced a new way to calculate field values in Map Viewer. At that time, Arcade was the only supported language within the new experience. Fast forward to today, we\u2019re excited to announce full SQL support for calculating field values in Map Viewer with the November 2024 update. As part of this work, we\u2019ve also built a new SQL editor for authoring expressions. Keep reading to learn more about the new SQL calculate field experience in Map Viewer.<\/p>\n"},{"acf_fc_layout":"content","content":"

\n
\"A
The classic SQL expression editor (left) found in the Data tab, compared to the new SQL expression editor (right) accessed via Calculate field in Map Viewer.<\/a><\/figcaption><\/figure>\n<\/div>\n"},{"acf_fc_layout":"content","content":"

When should you use SQL?<\/h2>\n

SQL calculations are more performant compared to calculations that use Arcade, particularly when you\u2019re working with a dataset with many features. As a result, we recommend using SQL to calculate your field values when possible. For example, if your calculation does not require spatial attributes (e.g., feature geometry) or comparison with other features in the dataset.<\/p>\n

Additionally, if your layer has editing settings like Sync<\/a> or Change tracking<\/a> enabled, SQL is the only supported language to calculate field values.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2565042,"id":2565042,"title":"sql_arcade_tiles_w_border","filename":"sql_arcade_tiles_w_border.png","filesize":34446,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\/sql_arcade_tiles_w_border","alt":"The two language options for calculating fields (Arcade and SQL) are displayed. The Arcade language is unavailable for selection due to settings configured on the layer.","author":"319692","description":"","caption":"SQL is the only supported language for calculating field values if Sync or Change tracking is enabled on the service.","name":"sql_arcade_tiles_w_border","status":"inherit","uploaded_to":2536442,"date":"2024-11-06 16:50:45","modified":"2024-11-06 20:15:57","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":684,"height":538,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","medium-width":332,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","medium_large-width":684,"medium_large-height":538,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","large-width":684,"large-height":538,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","1536x1536-width":684,"1536x1536-height":538,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","2048x2048-width":684,"2048x2048-height":538,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border-591x465.png","card_image-width":591,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png","wide_image-width":684,"wide_image-height":538}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/sql_arcade_tiles_w_border.png"},{"acf_fc_layout":"content","content":"

Calculating fields with SQL<\/h2>\n

The workflow and steps to calculate fields with SQL is virtually identical to Arcade field calculation. If you haven\u2019t already, check out this blog post<\/a> first for an overview of the various pieces of functionality available to you throughout the workflow.<\/p>\n

After selecting SQL as the calculation language, you will have the ability to set a filter on your calculation. This is an optional step in the workflow, but can be particularly helpful if you want to refine which features will receive the calculated value. You can think of the filter as a WHERE clause for your SQL expression. Only features that meet the condition(s) outlined in the WHERE clause will be impacted by the calculation.<\/p>\n"},{"acf_fc_layout":"content","content":"

\n
\"Auto-completion
A function snippet can be inserted into the editor using the available auto-completion menu. After authoring an expression, the expected result can be previewed using the table or pop-up before running the calculation.<\/a><\/figcaption><\/figure>\n<\/div>\n"},{"acf_fc_layout":"content","content":"

After the optional filter step, you\u2019re ready to start authoring your SQL expression! Just like Arcade, you\u2019ll be able to preview your calculation result prior to running the expression using the preview pop-up and table.<\/p>\n

If you\u2019ve used SQL to calculate fields in the Data tab, you may recall that there was a button to check the validity of your expression prior to execution. In the new experience, we don\u2019t have an explicit button to check this. Instead, the validity of your expression is periodically evaluated as you author it in the editor. If your expression is valid, you will be allowed to run the expression on the full dataset using the Run calculation button.<\/p>\n"},{"acf_fc_layout":"content","content":"

The SQL expression editor<\/h2>\n

The new SQL expression editor incorporates all the features you know and love from the Arcade editor<\/a> into a new and exciting SQL calculation experience.<\/p>\n

Syntax highlighting<\/strong><\/h4>\n

The SQL expression editor leverages the same color palette<\/a> as the Arcade editor for highlighting syntax elements. Accordingly, all colors used in the editor are compliant with WCAG 2.0 guidelines for maintaining sufficient contrast between foreground and background element colors.<\/p>\n

Validation & auto-completion<\/strong><\/h4>\n

The editor will help you validate your SQL expression by flagging invalid field names, unsupported characters, or missing function parameters. As you type in the editor suggestions for functions, snippets, and layer fields will appear based on the characters you\u2019ve entered. Additionally, certain keywords will display as options for function parameters where appropriate. For example, when using the EXTRACT() function relevant keywords like YEAR, MONTH, DAY, etc. will appears as options in the suggestions menu for the part_ parameter.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2567942,"id":2567942,"title":"SQL-CALC-AUTOCOMPLETE-EDITOR","filename":"2024-11-07_09-22-58.gif","filesize":141588,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\/2024-11-07_09-22-58","alt":"The EXTRACT function is added to the editor and its parameters populated using the auto-completion functionality.","author":"319692","description":"","caption":"Relevant suggestions for functions and function parameters will appear in the auto-completion menu as you type in the editor.","name":"2024-11-07_09-22-58","status":"inherit","uploaded_to":2536442,"date":"2024-11-07 14:23:35","modified":"2024-11-07 14:26:54","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":680,"height":224,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","medium-width":464,"medium-height":153,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","medium_large-width":680,"medium_large-height":224,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","large-width":680,"large-height":224,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","1536x1536-width":680,"1536x1536-height":224,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","2048x2048-width":680,"2048x2048-height":224,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","card_image-width":680,"card_image-height":224,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif","wide_image-width":680,"wide_image-height":224}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/2024-11-07_09-22-58.gif"},{"acf_fc_layout":"content","content":"

Integrated documentation<\/strong><\/h4>\n

Detailed documentation for all supported SQL functions can be accessed using the Functions button in the side panel. The documentation includes descriptions of each function, the expected return type(s), required parameters, and example code snippets. You can also insert a function snippet with parameter placeholders by selecting the Insert button on the bottom of the function\u2019s documentation page.<\/p>\n"},{"acf_fc_layout":"content","content":"

\n
\"The
The Fields menu in the editor side panel is used to display information about fields, including domain values. The Functions menu allows you to quickly insert functions into the editor to streamline expression authoring.<\/a><\/figcaption><\/figure>\n<\/div>\n"},{"acf_fc_layout":"content","content":"

Layer fields<\/strong><\/h4>\n

The Fields button in the side panel will display an overview of your layer\u2019s fields, including their type, alias, and field name. If you have domains or subtypes configured on your fields, you can also view these by drilling into the field using the > button.<\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Pro tip:<\/strong> The width of the editor can also be increased or decreased by clicking and dragging with the mouse on the right-hand side of the editor. If the editor is under a certain minimum width, the side panel<\/em> will be hidden to provide you with more space to author your expression. If you don\u2019t see the side panel, increase the width of the editor until it appears.<\/em><\/p>\n

 <\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

Conclusion<\/h2>\n

The new SQL calculate field experience should behave exactly the same as the previous experience still found in the Data tab. If you have existing workflows or SQL expressions that you use to calculate fields you can bring them into the new experience in Map Viewer seamlessly. In future updates of ArcGIS Online, we plan to continue to improve the field calculate experience for both Arcade and SQL.<\/p>\n

Have you used the calculate field experience in Map Viewer? What do you think? Let us know your thoughts and provide any feedback on Esri Community<\/a>.<\/p>\n

Happy Mapping!<\/p>\n

 <\/p>\n"}],"related_articles":[{"ID":2359242,"post_author":"319692","post_date":"2024-06-27 03:00:15","post_date_gmt":"2024-06-27 10:00:15","post_content":"","post_title":"Introducing Calculate Field in Map Viewer","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"introducing-calculate-field-in-map-viewer","to_ping":"","pinged":"","post_modified":"2026-02-10 09:55:13","post_modified_gmt":"2026-02-10 17:55:13","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2359242","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/card_image_sql_calc.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/wide_image_sql_calc.png"},"yoast_head":"\nThe New SQL Field Calculate Experience<\/title>\n<meta name=\"description\" content=\"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.\" \/>\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.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The New SQL Field Calculate Experience\" \/>\n<meta property=\"og:description\" content=\"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-13T07:56:54+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\"},\"author\":{\"name\":\"Taylor McNeil\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/63839a1126b72563ed17ee37fc4a3257\"},\"headline\":\"The New SQL Field Calculate Experience\",\"datePublished\":\"2024-11-13T06:00:35+00:00\",\"dateModified\":\"2024-11-13T07:56:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\"},\"wordCount\":6,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"calculate field\",\"Map Viewer\",\"SQL\",\"what's new November 2024\"],\"articleSection\":[\"Data Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\",\"name\":\"The New SQL Field Calculate Experience\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2024-11-13T06:00:35+00:00\",\"dateModified\":\"2024-11-13T07:56:54+00:00\",\"description\":\"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The New SQL Field Calculate Experience\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/63839a1126b72563ed17ee37fc4a3257\",\"name\":\"Taylor McNeil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/BlogProfilePicCrop-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/BlogProfilePicCrop-213x200.jpg\",\"caption\":\"Taylor McNeil\"},\"description\":\"Taylor is a Product Engineer on the ArcGIS Online team based in Nova Scotia, Canada. She has received a BSc in Biology and a MSc in Applied Geomatics. When she's not at work, she can be found taking care of her houseplants, reading copious amounts of fiction, and exploring local thrift stores.\",\"jobTitle\":\"product engineer\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/tmcneil\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The New SQL Field Calculate Experience","description":"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.","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.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience","og_locale":"en_US","og_type":"article","og_title":"The New SQL Field Calculate Experience","og_description":"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-11-13T07:56:54+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience"},"author":{"name":"Taylor McNeil","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/63839a1126b72563ed17ee37fc4a3257"},"headline":"The New SQL Field Calculate Experience","datePublished":"2024-11-13T06:00:35+00:00","dateModified":"2024-11-13T07:56:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience"},"wordCount":6,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["calculate field","Map Viewer","SQL","what's new November 2024"],"articleSection":["Data Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience","name":"The New SQL Field Calculate Experience","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2024-11-13T06:00:35+00:00","dateModified":"2024-11-13T07:56:54+00:00","description":"With the November 2024 update, the ability to calculate field values with SQL is now available in Map Viewer.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/the-new-sql-field-calculate-experience#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"The New SQL Field Calculate Experience"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/63839a1126b72563ed17ee37fc4a3257","name":"Taylor McNeil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/BlogProfilePicCrop-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/10\/BlogProfilePicCrop-213x200.jpg","caption":"Taylor McNeil"},"description":"Taylor is a Product Engineer on the ArcGIS Online team based in Nova Scotia, Canada. She has received a BSc in Biology and a MSc in Applied Geomatics. When she's not at work, she can be found taking care of her houseplants, reading copious amounts of fiction, and exploring local thrift stores.","jobTitle":"product engineer","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/tmcneil"}]}},"text_date":"November 12, 2024","author_name":"Taylor McNeil","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/tmcneil","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/10\/wide_image_sql_calc.png","primary_product":"ArcGIS Online","tag_data":[{"term_id":766432,"name":"calculate field","slug":"calculate-field","term_group":0,"term_taxonomy_id":766432,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":33371,"name":"Map Viewer","slug":"map-viewer","term_group":0,"term_taxonomy_id":33371,"taxonomy":"post_tag","description":"","parent":0,"count":155,"filter":"raw"},{"term_id":216532,"name":"SQL","slug":"sql","term_group":0,"term_taxonomy_id":216532,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":776962,"name":"what's new November 2024","slug":"whats-new-november-2024","term_group":0,"term_taxonomy_id":776962,"taxonomy":"post_tag","description":"","parent":0,"count":26,"filter":"raw"}],"category_data":[{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":921,"filter":"raw"}],"product_data":[{"term_id":36551,"name":"ArcGIS Online","slug":"arcgis-online","term_group":0,"term_taxonomy_id":36551,"taxonomy":"product","description":"","parent":0,"count":2428,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-online","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2536442","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/319692"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2536442"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2536442\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2536442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2536442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2536442"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2536442"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2536442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}