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-17 20:53:23
Duration: 18m33s
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-17 13:20:15
Duration: 18m28s
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-17 19:57:17
Duration: 18m26s
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

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-17 19:38:42
Duration: 34s25ms
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-17 17:04:37
Duration: 33s850ms
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-17 15:02:30
Duration: 30s406ms
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-17 08:01:31
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 87.98.152.184
Application: [unknown]

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-17 15:02:40
Duration: 40s243ms
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-17 16:02:30
Duration: 39s291ms
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-17 13:02:20
Duration: 33s465ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

SELECT orderline0_.M_Product_ID AS col_0_0_, product1_.Name AS col_1_0_, sum (orderline0_.QtyOrdered) AS col_2_0_, uom3_.Name AS col_3_0_, product1_.C_UOM_ID AS col_4_0_ FROM C_OrderLine orderline0_ CROSS JOIN M_Product product1_ CROSS JOIN C_UOM uom3_ CROSS JOIN C_Order order5_ CROSS JOIN M_Product product7_ WHERE orderline0_.M_Product_ID = product1_.M_Product_ID AND product1_.C_UOM_ID = uom3_.C_UOM_ID AND orderline0_.C_Order_ID = order5_.C_Order_ID AND orderline0_.M_Product_ID = product7_.M_Product_ID AND order5_.DocStatus = 'CO' AND order5_.IsSOTrx = 'Y' AND 1 = 1 AND orderline0_.AD_Client_ID = $1 AND (product7_.Name LIKE $2) AND (orderline0_.AD_Org_ID IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59)) GROUP BY product1_.Name, uom3_.Name, orderline0_.M_Product_ID, product1_.C_UOM_ID ORDER BY sum (orderline0_.QtyOrdered) DESC LIMIT $60;

Date: 2026-07-17 09:49:13
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

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-17 07:51:41
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

INSERT INTO C_OrderLine_Offer (AD_Client_ID, AD_Org_ID, IsActive, Created, Createdby, Updated, Updatedby, C_OrderLine_ID, Line, M_Offer_ID, Priceoffer, Amtoffer, Priceoffergross, TotalAmt, DisplayedTotalAmt, EM_Obdisc_Qtyoffer, EM_Obdisc_Identifier, EM_Obpos_Discountinstance, C_Orderline_Offer_ID) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19);

Date: 2026-07-17 10:51:09
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-17 07:30:07
Duration: 4s213ms
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-17 07:30:06
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver

x Hide