Good morning!
When updating to the latest version of RODA 9.7, an error occurs in the Schema Modeler.
My work environment is:
IDE RAD STUDIO TOKYO 10.2.3
DATABASE FIREBIRD.
PLEASE, CAN YOU SEE IT?
SELECT Cast(I.cod_item AS BIGINT) AS "Product_id",
I.descripcion AS "Model",
ad.descripcion_d AS "Name",
( R."ParentId" ) AS "ParentId",
( R."CategoryId" ) AS "CategoryId",
COALESCE(L.id_lista, 1) AS "Customer_group_id",
cast(LP.precio as Float) AS "Price",
CASE
WHEN I.imagen IS NULL THEN ''
ELSE 'Catalog/Demo/'
|| ( I.cod_item )
|| '_1.jpg'
END AS "Image",
I.observaciones AS "Description",
COALESCE(ST.stock, 0.0) AS "Stock",
CASE
WHEN I.inactivo = 'S' THEN 1
WHEN I.inactivo = 'N' THEN 0
ELSE 0
END AS "Status",
Date_Modified AS "DateModified"
FROM items I
JOIN (SELECT DISTINCT cod_item,
Cast(date_modified AS DATE) AS Date_Modified
FROM repl$opencart_items_view
WHERE replicated = 'N'
AND date_modified > :DateModified) REPL
ON REPL.cod_item = I.cod_item
JOIN articulos_discriminados AD
ON I.cod_item = AD.cod_item
AND I.id_empresa = AD.id_empresa
JOIN vm_categorias R
ON I.cod_rubro = R."Category_Master"
LEFT JOIN listas L
ON L.id_lista = 1
AND L.id_empresa = I.id_empresa
LEFT JOIN listasprecios LP
ON AD.cod_item = LP.cod_item
AND AD.id_tipo_subcodigo1 = LP.id_tipo_subcodigo1
AND AD.id_subcodigo1 = LP.id_subcodigo1
AND AD.id_tipo_subcodigo2 = LP.id_tipo_subcodigo2
AND AD.id_subcodigo2 = LP.id_subcodigo2
AND AD.id_empresa = LP.id_empresa
AND LP.id_lista = 1
LEFT JOIN stock ST
ON AD.cod_item = ST.cod_item
AND AD.id_tipo_subcodigo1 = ST.id_tipo_subcodigo1
AND AD.id_subcodigo1 = ST.id_subcodigo1
AND AD.id_tipo_subcodigo2 = ST.id_tipo_subcodigo2
AND AD.id_subcodigo2 = ST.id_subcodigo2
AND AD.id_empresa = ST.id_empresa
WHERE REPL.date_modified >= :DateModified
GROUP BY "Product_id",
"Model",
"Name",
"ParentId",
"CategoryId",
"Customer_group_id",
"Price",
"Image",
"Description",
"Stock",
"Status",
"DateModified";
I enclose the sql statement that maybe has some unsupported join.
Best Regards
