{"id":20450,"date":"2022-09-15T16:11:38","date_gmt":"2022-09-15T14:11:38","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/sql-queries\/sql-query-in-a-table\/"},"modified":"2026-05-13T10:47:50","modified_gmt":"2026-05-13T08:47:50","slug":"sql-query-in-a-table","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-portal\/administrators-guide\/sql-connectivity-module\/sql-queries\/sql-query-in-a-table\/","title":{"rendered":"SQL query in a table"},"content":{"rendered":"\n<p>You can perform a SQL query with a column in a table as a trigger. In this case, the query will populate one or more columns of the same table.<\/p>\n\n<p>In the SQL query block, you must first call the array metadata, then the metadata corresponding to the column that will trigger the query.  <\/p>\n\n<p>The 2 metadata should be entered as follows: <strong>&lt;Table&gt;&lt;colonne_qui_d\u00e9clenche_la_requ\u00eate&gt;<\/strong>.<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2026\/03\/requete_tableau-translated.png\" alt=\"\" class=\"wp-image-12772\"\/><\/figure>\n\n<p>After entering the query, click <strong>Perform Association<\/strong>, then select The result will<strong> populate one or more columns in a row of the table<\/strong> to move the cursor to the right.<\/p>\n\n<p>In the <strong>Table<\/strong> section, you can choose the metadata for the table. Thus, you will be able to choose the columns of the table to be associated in the correspondence area between the external columns reported by the Select of the SQL query and the metadata.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can perform a SQL query with a column in a table as a trigger. In this case, the query will populate one or more columns of the same table. In the SQL query block, you must first call the array metadata, then the metadata corresponding to the column that will trigger the query. The [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":20447,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/ob-help-products.php","meta":{"footnotes":""},"class_list":["post-20450","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20450","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=20450"}],"version-history":[{"count":7,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20450\/revisions"}],"predecessor-version":[{"id":38745,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20450\/revisions\/38745"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/20447"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=20450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}