Entradas

Mostrando las entradas de junio, 2024

Building the ATP Dashboard Tennis.com with Javascript

Imagen
Building the ATP Dashboard The goal of this project was to create a web page capable of displaying ATP rankings in a simple and visually appealing way. To accomplish this, I built a dashboard that retrieves data directly from Tennis API using JavaScript and the Fetch API. The application includes several useful features: ATP Top 3 players overview. Total number of players returned by the API. Dynamic player search. Interactive ATP ranking table. All information is loaded in real time and updated whenever the page is refreshed. You can try the live version of the dashboard here: ATP Tennis Dashboard Demo I also recorded a short video showing how to obtain an API Key through RapidAPI, explore the available endpoints, and test the dashboard: Watch the English Video Tutorial Download the Source Code If you'd like to experiment with the project or customize it for your own applications, the complete source code is available for download. The package includes: Compl...

Querys Oracle fusión

Imagen
En esta publicación les quiero compartir algunos querys de Oracle El siguiente query te ayuda a obtener los datos bancarios de una lista de proveedores A continuación un query para saber que clientes no tienen asignado ninguna cuenta de referencia para receivables,revenue y taxes. select hcsu.site_use_id,hca.ACCOUNT_NUMBER,hcsu.LOCATION,hcsu.status,hcsu.LAST_UPDATE_DATE from hz_parties hp, HZ_CUST_ACCOUNTS hca, HZ_CUST_ACCT_SITES_ALL hcsa, HZ_CUST_SITE_USES_ALL hcsu where hcsa.SET_ID = 9999 and hp.party_id = hca.party_id and hca.cust_account_id = hcsa.cust_account_id and hcsa.cust_acct_site_id = hcsu.cust_acct_site_id and hcsu.SITE_USE_CODE = 'BILL_TO' and hcsu.status = 'A' and hcsu.site_use_id NOT IN ( select ara.source_ref_account_id from AR_REF_ACCOUNTS_ALL ara WHERE  ara.source_ref_table = 'HZ_CUST_SITE_USES_ALL' and hcsu.site_use_id= ara.source_ref_account_id) order by LAST_UPDATE_DATE desc Con el siguiente query puedes obtener el listado de facturas de AR ...

🚀 Mantener este blog funcionando requiere tiempo y café. ¡Puedes contribuir con uno aquí!