Posts

Oracle APEX 26.1 and local AI Model

Image
With the recent release of APEX 26.1 using AI is easier on APEX. I wanted to try it but I stil don't want to spend money on that, Im just learning to configure it so I don't want to spend money just by making a "Hello world!" test, if that's your case or you are worried about your privacy and want to run only local models this post is for you, we'll set up a local AI model, enable external access and configure it on APEX. Computer Specs The AI model you can run on your PC will depend on your hardware, these are my PC Specs so you can compare, maybe you can run a better model. Processor: Intel Core Ultra 5 245K RAM: 32 GB Graphic Card: GTX 1050 Ti (4 GB VRAM) Operative system: Windows 11 Home single language As you can see, my graphic card is not the best but it works. Installing Ollama We'll use Ollama as our tool for AI, you can install it from here:  https://ollama.com/download After installing Ollama you need to downl...

Dynamic filter on Interactive Reports

Image
This feature will allow you to select a row on one Interactive Report and add a filter a second Interactive report using the selected value. This can be achieved easily with a Master Detail Page, APEX will use interactive grids for this, but if you want to use two interactive Reports or if your filter value doesn't come from a report, you can use the solution on this post. This is the demo app , if this is what you are looking for, keep reading the blog. For this example we'll use two interactive reports and one item to store the selected value. In this case we have the Department and Employee Reports, when the user clicks on one department, the employee report will be filtered by the department name. First, in the Department report, set the following properties on the column you want to use as link: Type: Link Target Type: URL URL: javascript:void(0); Link Text: <span class="name-filter"># DNAME #</span> Link attributes: d...