SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-19 17:23:46
Duration: 18m44s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-19 20:56:32
Duration: 18m39s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."m_transaction_id" AS "m_transaction_id", "_"."m_locator_id" AS "m_locator_id", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."updated" AS "updated", "_"."m_product_id" AS "m_product_id", "_"."trxprocessdate" AS "Date mvt", "_"."Type de mouvement" AS "Type mvt", "_"."Quantité de mouvement" AS "Qté mvt", "_"."€ Coût de transaction" AS "€ Coût de transaction", "_"."€ Coût moyen du produit" AS "€ Coût moyen du produit", "_"."Nom de l'inventaire" AS "Nom de l'inventaire", "_"."Bon de livraison" AS "Bon de livraison", "_"."Document Commande" AS "Document Commande", "_"."TPV" AS "TPV", "_"."Type de document" AS "Type doc" FROM ( SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc (mt.trxprocessdate) AS trxprocessdate, mt.movementtype AS "Type de mouvement", mt.movementqty AS "Quantité de mouvement", mt.transactioncost AS "€ Coût de transaction", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coût moyen du produit", COALESCE (mi2. "name", 'n-a') AS "Nom de l'inventaire", COALESCE (mi4. "documentno", 'n-a') AS "Bon de livraison", COALESCE (o. "documentno", 'n-a') AS "Document Commande", COALESCE (oa. "name", 'n-a') AS "TPV", COALESCE (cd. "name", 'n-a') AS "Type de document" FROM m_transaction mt LEFT JOIN m_locator ml ON ml.m_locator_id = mt.m_locator_id LEFT JOIN m_inventoryline mi ON mi.m_inventoryline_id = mt.m_inventoryline_id LEFT JOIN m_inventory mi2 ON mi2.m_inventory_id = mi.m_inventory_id LEFT JOIN m_inoutline mi3 ON mi3.m_inoutline_id = mt.m_inoutline_id LEFT JOIN m_inout mi4 ON mi4.m_inout_id = mi3.m_inout_id LEFT JOIN c_orderline ol ON ol.c_orderline_id = mi3.c_orderline_id LEFT JOIN c_order o ON o.c_order_id = ol.c_order_id LEFT JOIN obpos_applications oa ON o.em_obpos_applications_id = oa.obpos_applications_id LEFT JOIN c_doctype cd ON cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y') "_";

Date: 2026-07-19 15:23:12
Duration: 18m38s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

SELECT DISTINCT ON (bp.c_bpartner_id) bp.c_bpartner_id, bp.updated, bp.AD_Language, CAST (bp.birthday AS varchar), bp.is_customer_consent, bp.isactive, usr.created, usr.firstname, usr.lastname, usr.commercialauth, usr.em_izir_updated_optin AS updatedCommercialauth, usr.email, usr.viasms, usr.viaemail, usr.phone, c_country.countrycode AS description /*replace BY countrycode*/ , c_location.regionname, c_location.postal, c_location.city, c_location.address1, grt.name, grp.value, created_user.default_ad_org_id AS created_by_org FROM c_bpartner bp LEFT JOIN ad_user usr ON bp.c_bpartner_id = usr.c_bpartner_id LEFT JOIN c_bpartner_location ON bp.c_bpartner_id = c_bpartner_location.c_bpartner_id LEFT JOIN c_location ON c_bpartner_location.c_location_id = c_location.c_location_id LEFT JOIN c_country ON c_country.c_country_id = c_location.c_country_id LEFT JOIN c_greeting grt ON bp.c_greeting_id = grt.c_greeting_id LEFT JOIN c_bp_group grp ON bp.c_bp_group_id = grp.c_bp_group_id LEFT JOIN ad_user created_user ON bp.createdby = created_user.ad_user_id WHERE (bp.updated >= now () - 2 OR usr.updated >= now () - 2);

Date: 2026-07-19 08:01:33
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 87.98.152.184
Application: [unknown]

x Hide

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-19 18:05:24
Duration: 32s394ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-19 19:38:57
Duration: 31s885ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."fin_payment_detail_v_id" AS "fin_payment_detail_v_id", "_"."ad_client_id" AS "ad_client_id", "_"."ad_org_id" AS "ad_org_id", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."c_order_id" AS "c_order_id", "_"."orderno" AS "Comande No.", "_"."invoiceno" AS "Facture No.", "_"."paymentno" AS "Paiement No.", "_"."duedate" AS "Date comptable", "_"."paymentdate" AS "Date de paiement", "_"."invoicedamt" AS "Montant de la facture", "_"."expected" AS "Attendu", "_"."paidamt" AS "Montant payé", "_"."expectedconverted" AS "Converti attendu", "_"."paidconverted" AS "Payé converti", "_"."paymentmethod" AS "Mode de paiement", "_"."status" AS "Status" FROM ( SELECT fpdv.fin_payment_detail_v_id, fpdv.ad_client_id, ( CASE WHEN cd.isreturn = 'Y' THEN co.ad_orgtrx_id ELSE fpdv.ad_org_id END) ad_org_id, fpdv.c_bpartner_id, fpdv.fin_payment_sched_ord_v_id AS "c_order_id", fpdv.orderno, fpdv.invoiceno, fpdv.paymentno, fpdv.duedate, fpdv.paymentdate, fpdv.invoicedamt, fpdv.expected, fpdv.paidamt, fpdv.expectedconverted, fpdv.paidconverted, fp.name AS "paymentmethod", fpdv.status FROM fin_payment_detail_v fpdv LEFT JOIN c_order co ON co.c_order_id = fpdv.fin_payment_sched_ord_v_id LEFT JOIN c_doctype cd ON co.c_doctype_id = cd.c_doctype_id LEFT JOIN fin_paymentmethod fp ON fp.fin_paymentmethod_id = fpdv.fin_paymentmethod_id WHERE co.issotrx = 'Y') "_";

Date: 2026-07-19 08:37:03
Duration: 31s709ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-19 13:02:24
Duration: 39s46ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-19 08:37:11
Duration: 35s363ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

SELECT "_"."c_order_id" AS "c_order_id", "_"."ad_org_id" AS "ad_org_id", "_"."isactive" AS "isactive", "_"."issotrx" AS "issotrx", "_"."m_pricelist_id" AS "m_pricelist_id", "_"."Documento" AS "Documento", "_"."Estado Pedido" AS "Estado Pedido", "_"."Accion Pedido" AS "Accion Pedido", "_"."Tipo Documento" AS "Tipo Documento", "_"."Descripción" AS "Descripción", "_"."Fecha Pedido" AS "Fecha Pedido", "_"."Fecha Comprometida" AS "Fecha Comprometida", "_"."c_bpartner_id" AS "c_bpartner_id", "_"."Referencia Proveedor" AS "Referencia Proveedor", "_"."c_currency_id" AS "c_currency_id", "_"."Currency ISO" AS "Currency ISO", "_"."m_warehouse_id" AS "m_warehouse_id", "_"."Ciudad" AS "Ciudad", "_"."Codigo Postal" AS "Codigo Postal", "_"."Pais" AS "Pais", "_"."Region" AS "Region", "_"."TPV Name" AS "TPV Name", "_"."Vendedor" AS "Vendedor", "_"."Nombre y Apellido Vendedor" AS "Nombre y Apellido Vendedor", "_"."salesrep_id" AS "salesrep_id", CAST ("_"."Fecha Pedido" AS date) AS "t0_0", CAST ("_"."Fecha Comprometida" AS date) AS "t1_0" FROM ( SELECT "c_order_id", "ad_org_id", "isactive", "issotrx", "m_pricelist_id", "Documento", "Estado Pedido", "Accion Pedido", "Tipo Documento", "Descripción", "Fecha Pedido", "Fecha Comprometida", "c_bpartner_id", "Referencia Proveedor", "c_currency_id", "Currency ISO", "m_warehouse_id", "Ciudad", "Codigo Postal", "Pais", "Region", "TPV Name", "Vendedor", "Nombre y Apellido Vendedor", "salesrep_id" FROM ( SELECT O.c_order_id, ( CASE WHEN DT.isreturn = 'Y' THEN O.ad_orgtrx_id ELSE O.ad_org_id END) ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno AS "Documento", O.docstatus AS "Estado Pedido", O.docaction AS "Accion Pedido", O.processed AS "Procesado", DT.name AS "Tipo Documento", O.description AS "Descripción", O.dateordered AS "Fecha Pedido", O.datepromised AS "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Proveedor", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city AS "Ciudad", cl.postal AS "Codigo Postal", cc. "name" AS "Pais", cr. "name" AS "Region", OA. "name" AS "TPV Name", COALESCE (au.name, 'n-a') AS "Vendedor", concat (COALESCE (au.firstname, ''), ' ', COALESCE (au.lastname, '')) AS "Nombre y Apellido Vendedor", O.salesrep_id FROM c_order O LEFT JOIN c_doctype DT ON DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu ON cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl ON cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl ON cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc ON cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr ON cr.c_region_id = cl.c_region_id LEFT JOIN obpos_applications OA ON OA.obpos_applications_id = O.em_obpos_applications_id LEFT JOIN ad_user au ON au.ad_user_id = O.salesrep_id WHERE 1 = 1 AND O.issotrx = 'Y' AND O.dateordered >= current_date - interval '3 years') "$Table") "_";

Date: 2026-07-19 19:38:50
Duration: 33s966ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

'0' AS AD_ROLE_ID, NULL AS AD_USER_ID, 'Business Partner: "' || AD_COLUMN_IDENTIFIER ('C_BPartner', bp.C_BPARTNER_ID, 'en_US') || '" has defined different countries as Tax Location. Only one country should be defined as Tax Location' AS DESCRIPTION, 'Y' AS ISACTIVE, bp.AD_ORG_ID AS AD_ORG_ID, bp.AD_CLIENT_ID AS AD_CLIENT_ID, now () AS CREATED, '0' AS CREATEDBY, now () AS UPDATED, '0' AS UPDATEDBY, AD_COLUMN_IDENTIFIER ('C_BPartner', bp.C_BPARTNER_ID, 'en_US') AS RECORD_ID FROM c_bpartner bp WHERE EXISTS ( SELECT 1 FROM c_bpartner_location bpl INNER JOIN c_location l ON (bpl.c_location_id = l.c_location_id) WHERE bpl.c_bpartner_id = bp.c_bpartner_id AND bpl.istaxlocation = 'Y' GROUP BY bpl.c_bpartner_id, bpl.istaxlocation HAVING count (DISTINCT (l.c_country_id)) > 1)) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

Date: 2026-07-19 08:58:51
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

INSERT INTO obmobc_logclient (obmobc_logclient_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, tstamp, deviceid, context, msg, loglevel, cache_session_id, isonline) VALUES ($1, $2, $3, 'Y', to_timestamp (to_char ($4), to_char ('YYYY-MM-DD HH24:MI:SS')), $5, to_timestamp (to_char ($6), to_char ('YYYY-MM-DD HH24:MI:SS')), $7, to_number ($8), $9, $10, $11, $12, $13, $14);

Date: 2026-07-19 16:03:28
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT c_country.countrycode AS "Code Pays", substring (c_order.ad_org_id, 1, 25) AS "Code magasin", ad_org.name AS "Nom magasin", to_char (c_order.dateordered::date, 'yyyy-mm-dd') AS Date, SUM (c_orderline.linenetamt) AS "CA HT", NULL AS Traffic, count (DISTINCT CASE WHEN subquery.total_linenetamt > 0 THEN c_order.c_order_id ELSE NULL END) - count (DISTINCT CASE WHEN subquery.total_linenetamt < 0 THEN c_order.c_order_id ELSE NULL END) AS "Nombre de tickets" FROM c_orderline INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id LEFT JOIN ad_org ON c_order.ad_org_id = ad_org.ad_org_id LEFT JOIN c_country ON ad_org.em_obretco_dbp_countryid = c_country.c_country_id INNER JOIN ( SELECT c_order_id, SUM (linenetamt) AS total_linenetamt FROM c_orderline GROUP BY c_order_id) AS subquery ON c_orderline.c_order_id = subquery.c_order_id WHERE c_order.issotrx = 'Y' AND c_orderline.qtyordered <> 0 AND c_order.dateordered >= current_date - interval '30 days' GROUP BY to_char (c_order.dateordered::date, 'yyyy-mm-dd'), c_country.countrycode, c_order.ad_org_id, ad_org.name;

Date: 2026-07-19 07:30:07
Duration: 4s294ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver
Bind query: yes

SELECT c_country.countrycode AS "Code Pays", substring (c_order.ad_org_id, 1, 25) AS "Code magasin", ad_org.name AS "Nom magasin", to_char (c_order.dateordered::date, 'yyyy-mm-dd') AS Date, SUM (c_orderline.linenetamt) AS "CA HT", NULL AS Traffic, count (DISTINCT CASE WHEN subquery.total_linenetamt > 0 THEN c_order.c_order_id ELSE NULL END) - count (DISTINCT CASE WHEN subquery.total_linenetamt < 0 THEN c_order.c_order_id ELSE NULL END) AS "Nombre de tickets" FROM c_orderline INNER JOIN c_order ON c_orderline.c_order_id = c_order.c_order_id LEFT JOIN ad_org ON c_order.ad_org_id = ad_org.ad_org_id LEFT JOIN c_country ON ad_org.em_obretco_dbp_countryid = c_country.c_country_id INNER JOIN ( SELECT c_order_id, SUM (linenetamt) AS total_linenetamt FROM c_orderline GROUP BY c_order_id) AS subquery ON c_orderline.c_order_id = subquery.c_order_id WHERE c_order.issotrx = 'Y' AND c_orderline.qtyordered <> 0 AND c_order.dateordered >= current_date - interval '30 days' GROUP BY to_char (c_order.dateordered::date, 'yyyy-mm-dd'), c_country.countrycode, c_order.ad_org_id, ad_org.name;

Date: 2026-07-19 07:30:06
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver

x Hide