{"id":2672,"date":"2019-03-25T17:40:41","date_gmt":"2019-03-25T20:40:41","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/setting-up-where-e3-applications-queries-will-be-executed\/"},"modified":"2019-03-25T17:40:41","modified_gmt":"2019-03-25T20:40:41","slug":"setting-up-where-e3-applications-queries-will-be-executed","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/setting-up-where-e3-applications-queries-will-be-executed\/","title":{"rendered":"Setting up where E3 application&#8217;s queries will be executed."},"content":{"rendered":"<div align=\"justify\"><span style=\"font-weight:bold;\">Question:<\/span><\/p>\n<p>Where are E3 application&#8217;s queries executed: in the Viewer or in the Server? <\/p>\n<p><span style=\"font-weight:bold;\">Solution:<\/span><\/p>\n<p>This will depend on <i>EnableLocalCreation <\/i>property&#8217;s value.<\/p>\n<p>If <i>EnableLocalCreation <\/i>property is set as <span style=\"font-weight:bold;\">TRUE<\/span>, the Viewer will try to connect directly to the Database, without going through E3Server\/E3Run. If it connects successfully, then it will execute the queries itself.<\/p>\n<p>If <i>EnableLocalCreation <\/i>property is set as <span style=\"font-weight:bold;\">FALSE<\/span>, the queries will always be executed in E3Run, and the results will be passed to the Viewer via REC protocol. <\/div>\n<div align=\"justify\"><\/div>\n<div align=\"justify\"><b><font color=\"#ff0000\">NOTE:<\/font><\/b> From version 4.6 on, the EnableLocalCreation property has been removed from the DBServer object. Since then, the Viewers have no longer been able to access the database directly, and all access now take place via server.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question: Where are E3 application&#8217;s queries executed: in the Viewer or in the Server? Solution: This will depend on EnableLocalCreation property&#8217;s value. If EnableLocalCreation property is set as TRUE, the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[743],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Setting up where E3 application&#039;s queries will be executed. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up where E3 application&#039;s queries will be executed.\" \/>\n<meta property=\"og:description\" content=\"Question: Where are E3 application&#8217;s queries executed: in the Viewer or in the Server? Solution: This will depend on EnableLocalCreation property&#8217;s value. If EnableLocalCreation property is set as TRUE, the&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:40:41+00:00\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Setting up where E3 application&#8217;s queries will be executed.\",\"datePublished\":\"2019-03-25T20:40:41+00:00\",\"dateModified\":\"2019-03-25T20:40:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\"},\"wordCount\":132,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"E3Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\",\"url\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\",\"name\":\"[:pt]Setting up where E3 application's queries will be executed.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:40:41+00:00\",\"dateModified\":\"2019-03-25T20:40:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up where E3 application&#8217;s queries will be executed.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up where E3 application's queries will be executed. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Setting up where E3 application's queries will be executed.[:] - Elipse Knowledgebase","og_description":"Question: Where are E3 application&#8217;s queries executed: in the Viewer or in the Server? Solution: This will depend on EnableLocalCreation property&#8217;s value. If EnableLocalCreation property is set as TRUE, the&hellip;","og_url":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:40:41+00:00","author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Setting up where E3 application&#8217;s queries will be executed.","datePublished":"2019-03-25T20:40:41+00:00","dateModified":"2019-03-25T20:40:41+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/"},"wordCount":132,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["E3Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/","url":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/","name":"[:pt]Setting up where E3 application's queries will be executed.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:40:41+00:00","dateModified":"2019-03-25T20:40:41+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/setting-up-where-e3-applications-queries-will-be-executed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Setting up where E3 application&#8217;s queries will be executed."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2672"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2672"}],"version-history":[{"count":0,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2672\/revisions"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}