{"id":21230,"date":"2022-04-11T13:56:06","date_gmt":"2022-04-11T11:56:06","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/jse_database\/"},"modified":"2026-05-13T09:39:59","modified_gmt":"2026-05-13T07:39:59","slug":"jse_database","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/jse_database\/","title":{"rendered":"JSE_Database"},"content":{"rendered":"\n<p>Introduction<\/p>\n\n<p>The JSE_Database class allows you to run queries on different databases by connecting using an ODBC connection string. This class can be instantiated or used in static mode<\/p>\n\n<h1 class=\"wp-block-heading\" id=\"JSE_Database-Constructeurs\">Manufacturers<\/h1>\n\n<h3 class=\"wp-block-heading\" id=\"JSE_Database-JSE_Database(StringconnectionString,intdatabaseType)\">JSE_Database(String connectionString, int databaseType)<\/h3>\n\n<ul class=\"wp-block-list\">\n<li>databaseType:\n<ul class=\"wp-block-list\">\n<li>0 = ODBC<\/li>\n\n\n\n<li>1 = OLEDB<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n<pre class=\"wp-block-code\"><code>var database = new JSE_Database(\"DSN=SQLODBC32\", 1);<\/code><\/pre>\n\n<h3 class=\"wp-block-heading\" id=\"JSE_Database-JSE_Database(StringconnectionString)\">JSE_Database(String connectionString)<\/h3>\n\n<ul class=\"wp-block-list\">\n<li>databaseType: 0 by default = ODBC<\/li>\n<\/ul>\n\n<pre class=\"wp-block-code\"><code>var database = new JSE_Database(\"DSN=SQLODBC32\");<\/code><\/pre>\n\n<h1 class=\"wp-block-heading\" id=\"JSE_Database-Fonctions\">Duties<\/h1>\n\n<h2 class=\"wp-block-heading\" id=\"JSE_Database-Modeinstanci&#xE9;\">Instanced Mode<\/h2>\n\n<h3 class=\"wp-block-heading\" id=\"JSE_Database-executeRequest(Stringrequest):Array\">executeRequest(String request): Array<\/h3>\n\n<p>This function allows you to execute the request request using the connection string passed as a parameter in the class&#8217;s constructor<\/p>\n\n<pre class=\"wp-block-code\"><code>var database = new JSE_Database(\"DSN=SQLODBC32\");\nvar res = database.executeRequest(\"SELECT * FROM obp_document;\");\nvar date = new Date(res&#91;0]&#91;\"creation_date\"]);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Introduction The JSE_Database class allows you to run queries on different databases by connecting using an ODBC connection string. This class can be instantiated or used in static mode Manufacturers JSE_Database(String connectionString, int databaseType) JSE_Database(String connectionString) Duties Instanced Mode executeRequest(String request): Array This function allows you to execute the request request using the connection string [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":21211,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-21230","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21230"}],"version-history":[{"count":2,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21230\/revisions"}],"predecessor-version":[{"id":24125,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21230\/revisions\/24125"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21211"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}