{"id":21244,"date":"2024-01-22T10:15:20","date_gmt":"2024-01-22T09:15:20","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/objects\/jse_datatable\/"},"modified":"2026-05-13T09:40:01","modified_gmt":"2026-05-13T07:40:01","slug":"jse_datatable","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-scan-capture\/knowledge-base\/how-to-guides\/scripts-in-capture\/objects\/jse_datatable\/","title":{"rendered":"JSE_Datatable"},"content":{"rendered":"\n<p>JSE_Datatable is a special type, because it is an object that must be built inside the script. It is used to generate data or retrieve external data that will be used in a consistency index.<\/p>\n\n<p><strong>In the context of a consistency index, the script associated with the part of the data must return an object of type JSE_Datatable.<\/strong><\/p>\n\n<h1 class=\"wp-block-heading\" id=\"JSE_Result-Structure\">Structure<\/h1>\n\n<ul class=\"wp-block-list\">\n<li><strong><code>headers<\/code><\/strong> : Liste des ent\u00eates de donn\u00e9e\n\n\n\n\n\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code>title<\/code> <\/strong>: Title of the header that will be visible from the videocoding interface<\/li>\n\n\n\n<li><strong><code>id<\/code> <\/strong>: Header ID, to identify the values of each row and retrieve them from the scripts.<\/li>\n\n\n\n<li><code><strong>type<\/strong><\/code>  : Column Type (String, Date, Decimal, Text, State)<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code><strong>availableValues<\/strong><\/code>  : (Optional) lists of values available. The value input box will be replaced by a drop-down list)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>values<\/strong> : List of data values in the &#8220;key&#8221; form: &#8220;value&#8221;<\/li>\n<\/ul>\n\n<pre class=\"wp-block-code\"><code>{\n\t\"values\": &#91;\n\t\t{\"CODE_ITEM\" : \"#253\", \"NAME\" : \"HDD 2To\", \"DATE\" : \"24\/07\/2023\" },\n\t\t{\"CODE_ITEM\" : \"#254\", \"NAME\" : \"HDD 1To\", \"DATE\" : \"01\/08\/2023\" }\n\t],\n\t\"headers\" : &#91;\n\t\t{\"title\" : \"Code\", \"id\" : \"CODE_ITEM\", \"type\" : \"String\", \"availableValues\" : &#91;\"#253\", \"#254\", \"#255\"] },\n\t\t{\"title\" : \"Nom\", \"id\" : \"NAME\", \"type\" : \"String\" },\n\t\t{\"title\" : \"Date de creation\", \"id\" : \"DATE\", \"type\" : \"Date\" }\n\t]\n}<\/code><\/pre>\n\n<h1 class=\"wp-block-heading\" id=\"JSE_Result-Construction\">Type &#8220;State&#8221;<\/h1>\n\n<p>The &#8220;State&#8221; type is a special type of column for displaying a status icon. It is possible to combine this type with &#8220;<code>availableValues<\/code>&#8221; in order to define the different icons available to the user<\/p>\n\n<ul class=\"wp-block-list\">\n<li>NONE<\/li>\n\n\n\n<li>VALID<\/li>\n\n\n\n<li>ERROR<\/li>\n\n\n\n<li>WARNING<\/li>\n\n\n\n<li>CONSULT<\/li>\n\n\n\n<li>LIST<\/li>\n\n\n\n<li>FLASH<\/li>\n\n\n\n<li>STAR_EMPTY<\/li>\n\n\n\n<li>STAR_HALF<\/li>\n\n\n\n<li>STAR_FULL<\/li>\n\n\n\n<li>MORE  <\/li>\n\n\n\n<li>UNMIS<\/li>\n\n\n\n<li>EMOJI_SAD  <\/li>\n\n\n\n<li>EMOJI_NEUTRAL  <\/li>\n\n\n\n<li>EMOJI_SMILE<\/li>\n<\/ul>\n\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>JSE_Datatable is a special type, because it is an object that must be built inside the script. It is used to generate data or retrieve external data that will be used in a consistency index. In the context of a consistency index, the script associated with the part of the data must return an object [&hellip;]<\/p>\n","protected":false},"author":96,"featured_media":0,"parent":21242,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-21244","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21244","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\/96"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21244"}],"version-history":[{"count":2,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21244\/revisions"}],"predecessor-version":[{"id":24124,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21244\/revisions\/24124"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21242"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}