SELECT businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote AS col_1_0_, businesspa0_.C_BPartner_ID AS col_2_0_, businesspa0_.AD_Org_ID AS col_3_0_, businesspa0_.Name AS col_4_0_, businesspa0_.Name AS col_5_0_, businesspa0_.Value AS col_6_0_, businesspa0_.Description AS col_7_0_, businesspa0_.TaxID AS col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID AS col_9_0_, businesspa0_.M_PriceList_ID AS col_10_0_, businesspa0_.FIN_Paymentmethod_ID AS col_11_0_, businesspa0_.C_PaymentTerm_ID AS col_12_0_, businesspa0_.InvoiceRule AS col_13_0_, aduserlist4_.Email AS col_14_0_, aduserlist4_.AD_User_ID AS col_15_0_, aduserlist4_.Phone AS col_16_0_, aduserlist4_.Phone2 AS col_17_0_, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) AS col_18_0_, aduserlist4_.Lastname AS col_19_0_, pricingpri1_.IsTaxIncluded AS col_20_0_, pricingpri1_.C_Currency_ID AS col_21_0_, pricingpri1_.Name AS col_22_0_, businesspa0_.C_BP_Group_ID AS col_23_0_, businesspa5_.Name AS col_24_0_, businesspa0_.SO_CreditLimit AS col_25_0_, businesspa0_.SO_CreditUsed AS col_26_0_, businesspa0_.IsTaxExempt AS col_27_0_, businesspa0_.Customer_Blocking AS col_28_0_, businesspa0_.SO_Order_Blocking AS col_29_0_, businesspa0_.Birthday AS col_30_0_, businesspa0_.Birthplace AS col_31_0_, businesspa0_.IsActive AS col_32_0_, businesspa0_.Is_Customer_Consent AS col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat AS col_34_0_, adlanguage2_.AD_Language AS col_35_0_, adlanguage2_.Name AS col_36_0_, greeting3_.C_Greeting_ID AS col_37_0_, greeting3_.Name AS col_38_0_, aduserlist4_.Comments AS col_39_0_, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed AS col_40_0_, aduserlist4_.Commercialauth AS col_41_0_, aduserlist4_.Viaemail AS col_42_0_, aduserlist4_.Viasms AS col_43_0_, businesspa0_.business_partner_type AS col_44_0_, businesspa0_.BP_Currency_ID AS col_45_0_, businesspa0_.SO_Creditminamt AS col_46_0_, now () AS col_47_0_ FROM C_BPartner businesspa0_ INNER JOIN M_PriceList pricingpri1_ ON businesspa0_.M_PriceList_ID = pricingpri1_.M_PriceList_ID LEFT OUTER JOIN AD_Language adlanguage2_ ON businesspa0_.AD_Language = adlanguage2_.AD_Language LEFT OUTER JOIN C_Greeting greeting3_ ON businesspa0_.C_Greeting_ID = greeting3_.C_Greeting_ID LEFT OUTER JOIN AD_User aduserlist4_ ON businesspa0_.C_BPartner_ID = aduserlist4_.C_BPartner_ID CROSS JOIN C_BP_Group businesspa5_ WHERE businesspa0_.C_BP_Group_ID = businesspa5_.C_BP_Group_ID AND 1 = 1 AND businesspa0_.IsCustomer = 'Y' AND (businesspa0_.AD_Client_ID IN ('4D6E1B072E684D59B1C90D09F4017E13', '0')) AND (businesspa0_.AD_Org_ID IN ($1, $2, $3, $4, $5, $6)) AND businesspa0_.IsActive = 'Y' AND (aduserlist4_.AD_User_ID IN ( SELECT aduser6_.AD_User_ID FROM AD_User aduser6_ WHERE aduser6_.EM_OBRETCO_Default_Pos_Contact = 'Y' AND aduser6_.C_BPartner_ID = businesspa0_.C_BPartner_ID)) AND businesspa0_.C_BPartner_ID > $7 GROUP BY businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL, businesspa0_.EM_Gcnv_Uniquecreditnote, businesspa0_.C_BPartner_ID, businesspa0_.AD_Org_ID, businesspa0_.Name, businesspa0_.Name, businesspa0_.Value, businesspa0_.Description, businesspa0_.TaxID, businesspa0_.SO_Bp_Taxcategory_ID, businesspa0_.M_PriceList_ID, businesspa0_.FIN_Paymentmethod_ID, businesspa0_.C_PaymentTerm_ID, businesspa0_.InvoiceRule, aduserlist4_.Email, aduserlist4_.AD_User_ID, aduserlist4_.Phone, aduserlist4_.Phone2, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name), aduserlist4_.Lastname, pricingpri1_.IsTaxIncluded, pricingpri1_.C_Currency_ID, pricingpri1_.Name, businesspa0_.C_BP_Group_ID, businesspa5_.Name, businesspa0_.SO_CreditLimit, businesspa0_.SO_CreditUsed, businesspa0_.IsTaxExempt, businesspa0_.Customer_Blocking, businesspa0_.SO_Order_Blocking, businesspa0_.Birthday, businesspa0_.Birthplace, businesspa0_.IsActive, businesspa0_.Is_Customer_Consent, businesspa0_.Is_Customer_Consent_PapFormat, adlanguage2_.AD_Language, adlanguage2_.Name, greeting3_.C_Greeting_ID, greeting3_.Name, aduserlist4_.Comments, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed, aduserlist4_.Commercialauth, aduserlist4_.Viaemail, aduserlist4_.Viasms, businesspa0_.business_partner_type, businesspa0_.BP_Currency_ID, businesspa0_.SO_Creditminamt, now () HAVING 1 = 1 ORDER BY businesspa0_.C_BPartner_ID LIMIT $8;

Date: 2026-07-18 09:38:44
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS col_0_0_, businesspa0_.EM_Gcnv_Uniquecreditnote AS col_1_0_, businesspa0_.C_BPartner_ID AS col_2_0_, businesspa0_.AD_Org_ID AS col_3_0_, businesspa0_.Name AS col_4_0_, businesspa0_.Name AS col_5_0_, businesspa0_.Value AS col_6_0_, businesspa0_.Description AS col_7_0_, businesspa0_.TaxID AS col_8_0_, businesspa0_.SO_Bp_Taxcategory_ID AS col_9_0_, businesspa0_.M_PriceList_ID AS col_10_0_, businesspa0_.FIN_Paymentmethod_ID AS col_11_0_, businesspa0_.C_PaymentTerm_ID AS col_12_0_, businesspa0_.InvoiceRule AS col_13_0_, aduserlist4_.Email AS col_14_0_, aduserlist4_.AD_User_ID AS col_15_0_, aduserlist4_.Phone AS col_16_0_, aduserlist4_.Phone2 AS col_17_0_, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name) AS col_18_0_, aduserlist4_.Lastname AS col_19_0_, pricingpri1_.IsTaxIncluded AS col_20_0_, pricingpri1_.C_Currency_ID AS col_21_0_, pricingpri1_.Name AS col_22_0_, businesspa0_.C_BP_Group_ID AS col_23_0_, businesspa5_.Name AS col_24_0_, businesspa0_.SO_CreditLimit AS col_25_0_, businesspa0_.SO_CreditUsed AS col_26_0_, businesspa0_.IsTaxExempt AS col_27_0_, businesspa0_.Customer_Blocking AS col_28_0_, businesspa0_.SO_Order_Blocking AS col_29_0_, businesspa0_.Birthday AS col_30_0_, businesspa0_.Birthplace AS col_31_0_, businesspa0_.IsActive AS col_32_0_, businesspa0_.Is_Customer_Consent AS col_33_0_, businesspa0_.Is_Customer_Consent_PapFormat AS col_34_0_, adlanguage2_.AD_Language AS col_35_0_, adlanguage2_.Name AS col_36_0_, greeting3_.C_Greeting_ID AS col_37_0_, greeting3_.Name AS col_38_0_, aduserlist4_.Comments AS col_39_0_, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed AS col_40_0_, aduserlist4_.Commercialauth AS col_41_0_, aduserlist4_.Viaemail AS col_42_0_, aduserlist4_.Viasms AS col_43_0_, businesspa0_.business_partner_type AS col_44_0_, businesspa0_.BP_Currency_ID AS col_45_0_, businesspa0_.SO_Creditminamt AS col_46_0_, now () AS col_47_0_ FROM C_BPartner businesspa0_ INNER JOIN M_PriceList pricingpri1_ ON businesspa0_.M_PriceList_ID = pricingpri1_.M_PriceList_ID LEFT OUTER JOIN AD_Language adlanguage2_ ON businesspa0_.AD_Language = adlanguage2_.AD_Language LEFT OUTER JOIN C_Greeting greeting3_ ON businesspa0_.C_Greeting_ID = greeting3_.C_Greeting_ID LEFT OUTER JOIN AD_User aduserlist4_ ON businesspa0_.C_BPartner_ID = aduserlist4_.C_BPartner_ID CROSS JOIN C_BP_Group businesspa5_ WHERE businesspa0_.C_BP_Group_ID = businesspa5_.C_BP_Group_ID AND 1 = 1 AND businesspa0_.IsCustomer = 'Y' AND (businesspa0_.AD_Client_ID IN ('4D6E1B072E684D59B1C90D09F4017E13', '0')) AND (businesspa0_.AD_Org_ID IN ($1, $2, $3, $4, $5, $6)) AND businesspa0_.IsActive = 'Y' AND (aduserlist4_.AD_User_ID IN ( SELECT aduser6_.AD_User_ID FROM AD_User aduser6_ WHERE aduser6_.EM_OBRETCO_Default_Pos_Contact = 'Y' AND aduser6_.C_BPartner_ID = businesspa0_.C_BPartner_ID)) AND 1 = 1 GROUP BY businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL, businesspa0_.EM_Gcnv_Uniquecreditnote, businesspa0_.C_BPartner_ID, businesspa0_.AD_Org_ID, businesspa0_.Name, businesspa0_.Name, businesspa0_.Value, businesspa0_.Description, businesspa0_.TaxID, businesspa0_.SO_Bp_Taxcategory_ID, businesspa0_.M_PriceList_ID, businesspa0_.FIN_Paymentmethod_ID, businesspa0_.C_PaymentTerm_ID, businesspa0_.InvoiceRule, aduserlist4_.Email, aduserlist4_.AD_User_ID, aduserlist4_.Phone, aduserlist4_.Phone2, COALESCE (aduserlist4_.Firstname, aduserlist4_.Name, businesspa0_.Name), aduserlist4_.Lastname, pricingpri1_.IsTaxIncluded, pricingpri1_.C_Currency_ID, pricingpri1_.Name, businesspa0_.C_BP_Group_ID, businesspa5_.Name, businesspa0_.SO_CreditLimit, businesspa0_.SO_CreditUsed, businesspa0_.IsTaxExempt, businesspa0_.Customer_Blocking, businesspa0_.SO_Order_Blocking, businesspa0_.Birthday, businesspa0_.Birthplace, businesspa0_.IsActive, businesspa0_.Is_Customer_Consent, businesspa0_.Is_Customer_Consent_PapFormat, adlanguage2_.AD_Language, adlanguage2_.Name, greeting3_.C_Greeting_ID, greeting3_.Name, aduserlist4_.Comments, businesspa0_.SO_CreditLimit - businesspa0_.SO_CreditUsed, aduserlist4_.Commercialauth, aduserlist4_.Viaemail, aduserlist4_.Viasms, businesspa0_.business_partner_type, businesspa0_.BP_Currency_ID, businesspa0_.SO_Creditminamt, now () HAVING 1 = 1 ORDER BY businesspa0_.C_BPartner_ID LIMIT $7;

Date: 2026-07-18 11:07:51
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

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-18 08:01:42
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-18 17:01:49
Duration: 36s294ms
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-18 18:05:26
Duration: 35s83ms
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-18 20:38:31
Duration: 34s486ms
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-18 18:05:18
Duration: 31s688ms
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-18 13:02:03
Duration: 31s621ms
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-18 20:38:22
Duration: 30s124ms
Database: openbravo
User: tad
Remote: 87.98.152.184
Application: [unknown]
Bind query: yes

x Hide

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-18 17:19:47
Duration: 18m40s
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-18 16:23:39
Duration: 18m38s
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-18 20:56:29
Duration: 18m37s
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-18 07:49:27
Duration: 0ms
Database: openbravo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

INSERT INTO M_Movement (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, UpdatedBy, Updated, Name, MovementDate, Processed, Processing, Move_FromTo_Locator, DocumentNo, EM_Izi_Exported, EM_Izi_Exported_Interstore, M_Movement_ID) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16);

Date: 2026-07-18 18:08:11
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-18 07:30:08
Duration: 4s223ms
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-18 07:30:07
Duration: 0ms
Database: openbravo
User: izipiziro
Remote: 51.103.17.13
Application: PostgreSQL JDBC Driver

x Hide