From 4821fe20741129eb934378f442d593585bb89dc9 Mon Sep 17 00:00:00 2001 From: "vincent@cubedesigners.com" Date: Mon, 24 Apr 2023 16:46:36 +0000 Subject: [PATCH] wip #5873 @0.25 --- inc/commons/class.common.core.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/inc/commons/class.common.core.php b/inc/commons/class.common.core.php index d884cf29e..68752e18b 100644 --- a/inc/commons/class.common.core.php +++ b/inc/commons/class.common.core.php @@ -544,7 +544,7 @@ class commonCore extends cubeCore IF(company = 7, JSON_VALUE(address,"$.city"), \'\') AS agence, e1_notes AS notes, company AS entreprise, UNIX_TIMESTAMP(created_at) AS date_creation FROM extranet_users.user'); - $this->views->createView('e2_c', 'SELECT id AS entreprise_id, name AS nom, + $this->views->createView('e2_c', 'SELECT id AS entreprise_id, name AS nom, fluidbooks_managed, JSON_VALUE(address,"$.address") AS adresse, JSON_VALUE(address,"$.postcode") AS code_postal, JSON_VALUE(address,"$.country") AS pays, -- 2.39.5