Open niclopup opened 1 week ago
con este url fallo
curl 'http://spdev02.solopapp.com:24814/api/report-engine/views/1000131?report_type=&filters=[%7B%22name%22:%22C_AcctSchema_ID%22,%22operator%22:%22equal%22,%22values%22:1000001%7D,%7B%22name%22:%22DateAcct%22,%22operator%22:%22between%22,%22values%22:[%222023-08-01%22,%222023-11-30%22]%7D,%7B%22name%22:%22AD_Org_ID%22,%22operator%22:%22equal%22,%22values%22:1000007%7D,%7B%22name%22:%22PostingType%22,%22operator%22:%22equal%22,%22values%22:%22A%22%7D,%7B%22name%22:%22isShowRetainedEarnings%22,%22operator%22:%22equal%22,%22values%22:false%7D]&page_size=15&page_token=1&print_format_id=1000131&report_view_id=153&is_summary=true' --globoff -H 'User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:129.0) Gecko/20100101 Firefox/129.0' -H 'Accept: application/json, text/plain, */*' -H 'Accept-Language: es-ES,es;q=0.8,en-US;q=0.5,en;q=0.3' -H 'Accept-Encoding: gzip, deflate' -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiJ9.eyJqdGkiOiIyMDIyNzQxIiwiQURfQ2xpZW50X0lEIjoxMDAwMDAxLCJBRF9PcmdfSUQiOjEwMDAwMDksIkFEX1JvbGVfSUQiOjEwMDAwMDIsIkFEX1VzZXJfSUQiOjEwMDEyMTIsIk1fV2FyZWhvdXNlX0lEIjoxMDAwMDc5LCJBRF9MYW5ndWFnZSI6ImVzX01YIiwiaWF0IjoxNzI4NjAxNzQzLCJleHAiOjE3Mjg2ODgxNDN9.jKrl04TmHWud4wMBvmRHHUWaeSEoeoS7DdqOTkBygaU' -H 'Origin: http://localhost:9527' -H 'Connection: keep-alive' -H 'Referer: http://localhost:9527/' -H 'Priority: u=0'
Hay columnas virtuales mal definidas.
SELECT T_TrialBalance.Account_ID, (t1.Value|| '_' ||t1.Name) AS Account_ID_1005210_DisplayValue, T_TrialBalance.DateAcct, T_TrialBalance.AmtSourceBalance, T_TrialBalance.AmtSourceCr, T_TrialBalance.AmtSourceDr, T_TrialBalance.C_Currency_ID, (SELECT COALESCE(C_Currency.ISO_Code,'') FROM C_Currency WHERE T_TrialBalance.C_Currency_ID=C_Currency.C_Currency_ID) AS C_Currency_ID_1005226_DisplayValue, T_TrialBalance.AmtAcctBalance, T_TrialBalance.AmtAcctDr, T_TrialBalance.AmtAcctCr, T_TrialBalance.C_BPartner_ID, (SELECT COALESCE(C_BPartner.Name,'') FROM C_BPartner WHERE T_TrialBalance.C_BPartner_ID=C_BPartner.C_BPartner_ID) AS C_BPartner_ID_1005221_DisplayValue, T_TrialBalance.C_Activity_ID, (SELECT COALESCE(C_Activity.Name,'') FROM C_Activity WHERE T_TrialBalance.C_Activity_ID=C_Activity.C_Activity_ID) AS C_Activity_ID_1005218_DisplayValue, T_TrialBalance.Description, ((CASE WHEN AD_Table_ID=318 THEN (SELECT C_DocType_ID FROM C_Invoice WHERE C_Invoice_ID=Record_ID) WHEN AD_Table_ID=335 THEN (SELECT C_DocType_ID FROM C_Payment WHERE C_Payment_ID=Record_ID) WHEN AD_Table_ID=224 THEN (SELECT C_DocType_ID FROM GL_Journal WHERE GL_Journal_ID=Record_ID) WHEN AD_Table_ID=735 THEN 1000010 ELSE NULL END)) AS C_DocType_ID, (SELECT COALESCE(C_DocType.Name,'') FROM C_DocType WHERE ((CASE WHEN AD_Table_ID=318 THEN (SELECT C_DocType_ID FROM C_Invoice WHERE C_Invoice_ID=Record_ID) WHEN AD_Table_ID=335 THEN (SELECT C_DocType_ID FROM C_Payment WHERE C_Payment_ID=Record_ID) WHEN AD_Table_ID=224 THEN (SELECT C_DocType_ID FROM GL_Journal WHERE GL_Journal_ID=Record_ID) WHEN AD_Table_ID=735 THEN 1000010 ELSE NULL END))=C_DocType.C_DocType_ID) AS C_DocType_ID_1005229_DisplayValue, T_TrialBalance.C_Period_ID, (SELECT COALESCE(C_Period.Name,'') FROM C_Period WHERE T_TrialBalance.C_Period_ID=C_Period.C_Period_ID) AS C_Period_ID_1005237_DisplayValue, T_TrialBalance.M_Product_ID, (SELECT COALESCE(M_Product.Value,'')||' - '||COALESCE(M_Product.Name,'') FROM M_Product WHERE T_TrialBalance.M_Product_ID=M_Product.M_Product_ID) AS M_Product_ID_1005240_DisplayValue, T_TrialBalance.C_Project_ID, (SELECT COALESCE(C_Project.Value,'')||' - '||COALESCE(C_Project.Name,'') FROM C_Project WHERE T_TrialBalance.C_Project_ID=C_Project.C_Project_ID) AS C_Project_ID_1005241_DisplayValue, T_TrialBalance.AD_Table_ID, (SELECT COALESCE(AD_Table.TableName,'')||' - '||COALESCE(AD_Table.Name,'') FROM AD_Table WHERE T_TrialBalance.AD_Table_ID=AD_Table.AD_Table_ID) AS AD_Table_ID_1005248_DisplayValue, T_TrialBalance.Record_ID, (t2.TableName) AS TableName
sp_dev-# FROM T_TrialBalance
sp_dev-# LEFT OUTER JOIN C_ElementValue t1 ON (t1.C_ElementValue_ID=T_TrialBalance.Account_ID)
sp_dev-# LEFT OUTER JOIN C_ElementValue_Trl tt1 ON (tt1.C_ElementValue_ID = T_TrialBalance.Account_ID)
sp_dev-# LEFT OUTER JOIN AD_Table t2 ON (t2.AD_Table_ID=T_TrialBalance.AD_Table_ID);
ERROR: column reference "ad_table_id" is ambiguous
LINE 1: ...ayValue, T_TrialBalance.Description, ((CASE WHEN AD_Table_I..
Las columnas virtuales deben tener el nombre de la tabla para que no sea marcada como ambigua
Bug report
Se intenta cambiar de vista en el balance de prueba pero da error
Screenshot or Gif(截图或动态图)
https://github.com/user-attachments/assets/711667e8-8610-4a40-b70c-7952e97289d5
Other relevant information
Additional context
Add any other context about the problem here.